Microsoft Office Tutorials and References

In Depth Information

Using the AVERAGE, MAX, and MIN Functions
EX 103

2

•
Click Min to display the function

=MIN(D14:D15) in the formula bar

and in cell D16 (Figure 2–23).

Why does Excel select the

range D14:D15?

The range D14:D15 automatically

selected by Excel is not correct.

Excel attempts to guess which

cells you want to include in the

function by looking for adjacent

ranges to the selected cell that

contain numeric data.

MIN function appears

in formula bar

Excel selects range

D14:D15 because it

includes numbers and

is adjacent to cell D16

MIN function appears

in active cell D16

Figure 2–23

3

•
Click cell D4 and then drag

through cell D12 to display the

function in the formula bar and

in cell D14 with the new range

(Figure 2–24).

Enter box

range D4:D12 selected

using Point mode

selected range

appears in active cell

and in formula bar

Figure 2–24

C6161_EXC_02.4c.indd 103

C6161_EXC_02.4c.indd 103

3/6/07 3:28:34 PM

3/6/07 3:28:34 PM