Microsoft Office Tutorials and References
In Depth Information
Using the AVERAGE, MAX, and MIN Functions
To Determine the Highest Number in a Range of Numbers Using the Insert Function Box
The next step is to select cell C15 and determine the highest (maximum) number in the range C4:C12. Excel
includes 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. The following steps use the Insert
Function box in the formula bar to enter the MAX function.
1
Select the cell to
contain the maximum
number, cell C15 in
this case.
Insert Function
dialog box
Insert Function box
Click the Insert
Function box in the
formula bar to display
the Insert Function
dialog box.
equal sign
automatically
inserted in
active cell and
formula bar
Search for a
function box
Click MAX in the
Or select a
category box
‘Select a function’
list (Insert Function
dialog box) to select
it (Figure 2 – 19). If
the MAX function is
not displayed in the
‘Select a function’ list,
scroll the list until the
function is displayed.
MAX selected in
Select a function list
Help on this
OK button
Figure 2 – 19
2
Click the OK button
(Insert Function dialog
box) to display the
Function Arguments
dialog box.
Function Arguments
dialog box
function appears
in formula bar
range typed in
Number 1 box
c4:c12 in
the Number1 box
(Function Arguments
dialog box) to enter
the i rst argument
of the function
(Figure 2 – 20).
Why did numbers
appear in the
Function Arguments
dialog box?
As shown in
Figure 2 – 20, Excel
displays the value
the MAX function
C15 in the Function
Arguments dialog
box. It also lists the i rst few numbers in the selected range, next to the Number1 box.
Type
Collapse Dialog button
i rst few numbers
in selected range
result of function
OK button
Help on this                                               