Microsoft Office Tutorials and References
In Depth Information
EX 102
Excel Chapter 2 Formulas, Functions, Formatting, and Web Queries
Click the OK button to display the
highest value in the range D4:D12
in cell D15 (Figure 2–21).
Why should I not just enter the
highest value that I see in the
range D4:D12 in cell D15?
In this example, rather than
entering the MAX function,
you easily could scan the range
D4:D12, determine that the
highest number of shares is 990,
and manually enter the number
990 as a constant in cell D15.
Excel would display the number
the same as in Figure 2–21. Because
it contains a constant, however,
Excel will continue to display 990
in cell D15, even if the values in
the range D4:D12 change. If you
use the MAX function, Excel will
recalculate the highest value in
the range D4:D9 each time a new
value is entered into the worksheet.
MAX function
highest value in
range D4:D12
highest value in
range D4:D12
Figure 2–21
Other Ways
1. Click Sum button arrow on
Ribbon, click Max function
2. Click Formulas tab on
Ribbon, click AutoSum
button, click Max function
3. Type =MAX in cell
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 D16 to determine the lowest (minimum) number in the
range D4:D12. 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 on the Ribbon.
Select cell D16.
Click the Sum button arrow on the
Ribbon to display the Sum button
menu (Figure 2–22).
Sum button arrow
Why should I use the Sum
button menu?
Using the Sum button menu allows
you to enter one of fi ve often-used
functions easily into a cell, without
having to memorize its name or the
required arguments.
Sum button menu
Min function
D16 is active cell
Figure 2–22
C6161_EXC_02.4c.indd 102
C6161_EXC_02.4c.indd 102
3/6/07 3:28:31 PM
3/6/07 3:28:31 PM
Search JabSto ::

Custom Search