Microsoft Office Tutorials and References
In Depth Information
To Determine the Highest Number in a Range of Numbers Using the Insert Function Box
The next step is to select cell D15 and determine the highest (maximum) number in the range D4:D12.
Excel has a function called the MAX function that displays the highest value in a range. Although you could
enter the MAX function using the keyboard and Point mode as described in the previous steps, an alternative
method to entering the function is to use the Insert Function box in the formula bar, as performed in the
• Select cell D15.
• Click the Insert Function box in the
formula bar to display the Insert
Function dialog box.
Insert Function button
Or select a
Search for a
• When Excel displays the Insert
Function dialog box, click MAX
in the ‘Select a function’ list
MAX selected in
Select a function list
inserted in active
cell and formula bar
Help on this
• Click the OK button.
• When Excel displays the Function
Arguments dialog box, type
d4:d12 in the Number1 box
range typed in
Why did numbers appear in the
Function Arguments dialog box?
As shown in Figure 2–20, Excel
displays the value the MAX func-
tion will return to cell D15 in the
Function Arguments dialog box. It
also lists the ﬁ rst few numbers in
the selected range, next to the
ﬁ rst few numbers
in selected range
result of function
last part of function
appears in active cell
Help on this