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
Search JabSto ::

Custom Search