Microsoft Office Tutorials and References
In Depth Information
To Determine the Highest Number in a Range of Numbers Using the Insert Function Box
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
following steps.
1
Select cell D15.
Click the Insert Function box in the
formula bar to display the Insert
Function dialog box.
Insert Function
dialog box
Insert Function button
Or select a
category box
Search for a
function box
When Excel displays the Insert
Function dialog box, click MAX
in the ‘Select a function’ list
(Figure 2–19).
MAX selected in
Select a function list
equal sign
automatically
inserted in active
cell and formula bar
Help on this
function link
OK button
Figure 2–19
2
Click the OK button.
Function Arguments
dialog box
When Excel displays the Function
Arguments dialog box, type
d4:d12 in the Number1 box
(Figure 2–20).
range typed in
Number1 box
Collapse
Dialog button
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 fi rst few numbers in
the selected range, next to the
Number1 box.
fi rst few numbers
in selected range
result of function
last part of function
appears in active cell
Help on this
function link
OK button
Figure 2–20
 
 
Search JabSto ::




Custom Search