Microsoft Office Tutorials and References
In Depth Information
Using the AVERAGE, MAX, and MIN Functions
To Determine the Average of a Range of Numbers
Using the Keyboard
1
ENTER
FORMULAS

2
ENTER
FUNCTIONS

3
VERIFY
FORMULAS
4
FORMAT
WORKSHEET

5
CHECK
SPELLING

6
PRINT
WORKSHEET
The AVERAGE function sums the numbers in a specied range and then divides the sum by the number of
cells with numeric values in the range. The following steps use the AVERAGE function to determine the average
of the numbers in the range B4:B12.
Why?
The AVERAGE function creates an accurate average automatically.
1
•
Select the cell to
contain the average,
cell B16 in this case.
•
Type
=av
in
the cell to display
the Formula
AutoComplete
list. Press the
DOWN
ARROW
key
to highlight the
required formula
(Figure 2 – 22).
Name box changes
to Function box as
soon as = (equal
sign) is entered
=av entered in cell
and formula bar
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.
AVERAGE function name
Formula AutoComplete list
Figure 2 – 22
2
•
Doubletap or
doubleclick
AVERAGE in
the Formula
AutoComplete list to
select the function.
•
Select the range
to be averaged,
B4:B12 in this case,
to insert the range
as the argument
to the function
(Figure 2 – 23).
AVERAGE function
with range to
average shows
in active cell and
formula bar
As I drag, why does
the function in cell
B16 change?
When you tap or
click cell B4, Excel
appends cell B4 to
the left parenthesis
in the formula bar and surrounds cell B4 with a marquee. When you begin dragging, Excel appends to the
argument a colon (:) and the cell reference of the cell where the pointer is located.
Figure 2 – 23