Microsoft Office Tutorials and References
In Depth Information
Using the AVERAGE, MAX, and MIN Functions
To Determine the Lowest Number in
a Range of Numbers Using the Sum Menu
1
ENTER
FORMULAS

2
ENTER
FUNCTIONS

3
VERIFY
FORMULAS
4
FORMAT
WORKSHEET

5
CHECK
SPELLING

6
PRINT
WORKSHEET
The next step is to enter the
MIN function
in cell B15 to determine the lowest (minimum) number in the
range B4:B12. Although you can enter the MIN function using the method used to enter the MAX function,
the following steps illustrate an alternative method using the Sum button (HOME tab  Editing group).
Why?
The Sum menu provides another way that you can insert functions, providing a menu from which you can choose.
1
•
Select cell B15 and then tap or click the Sum arrow (HOME tab  Editing group) to display the Sum menu (Figure 2 – 18).
Why should I use the Sum menu?
Using the Sum menu allows you to enter one of ve oftenused functions easily into a cell, without having to
memorize its name or the required arguments.
Sum arrow
Sum menu
Min function
B15 is active cell
Figure 2 – 18
2
•
Tap or click Min
to display the MIN
function in the
formula bar and
in the active cell
(Figure 2 – 19).
MIN function displays
in formula bar
Why does Excel
select the incorrect
range?
The range
automatically
selected by Excel is
not always correct.
Excel attempts to
guess which cells you
want to include in the
function by looking
for ranges that are
adjacent to the
selected cell and that
contain numeric data.
Excel selects cell B14
because it includes
numbers and is
adjacent to B15
Figure 2 – 19