Microsoft Office Tutorials and References

In Depth Information

Using the AVERAGE, MAX, and MIN Functions
EX 99

bar (Figure 2–16). The method you choose will depend on your typing skills and whether

you can recall the function name and required arguments.

In the following pages, each of the ﬁ rst three methods will be used. The keyboard

and mouse method will be used to determine the average number of shares (cell D14).

The Insert Function button in the formula bar method will be used to determine the

highest number of shares (cell D15). The Sum menu method will be used to determine

the lowest number of shares (cell D16).

To Determine the Average of a Range of Numbers Using the Keyboard and Mouse

The
AVERAGE function
sums the numbers in the speciﬁ ed range and then divides the sum by the number

of nonzero cells in the range. The following steps use the AVERAGE function to determine the average of the

numbers in the range D4:D12.

1

•
Select cell D14.

•
Type
=av
in the

cell to display

the Formula

AutoComplete list.

•
Point to the

AVERAGE function

name (Figure 2–16).

What is happening

as I type?

As you type the

equal sign followed

by the characters

in the name of

a function, Excel

displays the Formula

AutoComplete list.

This list contains

those functions that

alphabetically match

the letters you have

typed. Because you

typed =av, Excel

displays all the

functions that begin

with the letters av.

Name box changes to

Function box as soon as

= (equal sign) is entered

to start function

ScreenTip includes

description of currently

selected function in

Formula AutoComplete list

=av typed in cell D14

Formula

AutoComplete list

AVERAGE

function name

Figure 2–16

C6161_EXC_02.4c.indd 99

C6161_EXC_02.4c.indd 99

3/6/07 3:28:25 PM

3/6/07 3:28:25 PM