Microsoft Office Tutorials and References

In Depth Information

EX 102

Excel Chapter 2
Formulas, Functions, Formatting, and Web Queries

3

•
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

determines

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.

1

•
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 ﬁ 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