Microsoft Office Tutorials and References
In Depth Information
Using the AVERAGE, MAX, and MIN Functions
3
Click the OK button
MAX function
determines highest
value in range C4:C12
(Function Arguments
dialog box) to display
the highest value
in the chosen range
in the selected cell
(Figure 2 – 21).
Why should I not just
enter the highest value
that I see in the range
C4:C12 in cell C15?
In this example, rather
than entering the
MAX function, you
visually could scan
the range C4:C12,
determine that the highest number of dependents is 3, and manually enter the number 3 as
a constant in cell C15. Excel would display the number the same as in Figure 2 – 21. Because it
contains a constant, however, Excel will continue to display 3 in cell C15, even if the values in
the range C4:C12 change. If you use the MAX function, Excel will recalculate the highest value
in the range C4:C12 each time a new value is entered into the worksheet.
highest value in
range C4:C12
Figure 2 – 21
Other Ways
3. Type =MAX in cell
1. Click Sum button arrow
(Home tab | Editing group),
click Max
2. Click Sum button arrow
(Formulas tab | Function
Library group), click Max
To Determine the Lowest Number in a Range of Numbers Using the Sum Menu
The next step is to enter the MIN function in cell C16 to determine the lowest (minimum) number in the range
C4:C12. Although you can enter the MIN function using either of the methods used to enter the AVERAGE and MAX
functions, the following steps perform an alternative using the Sum button (Home tab | Editing group).
1
Sum button arrow
prepare to enter the
next function.
Select cell C16 to
Editing group
Click the Sum button
arrow (Home tab |
Editing group) to
display the Sum
button menu
(Figure 2–22).
Sum button menu
Min function
Why should I use the
Sum button menu?
Using the Sum button
menu allows you
to enter one of i ve
often-used functions
easily into a cell,
without having to
memorize its name
or the required
arguments.
C16 is active cell
Figure 2 – 22
 
Search JabSto ::




Custom Search