Microsoft Office Tutorials and References
In Depth Information
To Determine the Average of a Range of Numbers Using the Keyboard and Mouse
• Double-click AVERAGE in the
Formula AutoComplete list to
select the AVERAGE function.
• Select the range D4:D12 to insert
the range as the argument to the
AVERAGE function (Figure 2–17).
with range to average
shows in active cell
and formula bar
As I drag, why does the
function in cell D14 change?
When you click cell D4, Excel
appends cell D4 to the left
parenthesis in the formula bar
and surrounds cell D4 with a mar-
quee. When you begin dragging,
Excel appends to the argument a
colon (:) and the cell reference of
the cell where the mouse pointer
selected range D4:D12
• Click the Enter box to compute
the average of the nine numbers
in the range D4:D12 and display
the result in cell D14 (Figure 2–18).
Can I use the arrow keys to
complete the entry instead?
No. When you use Point mode
you cannot use the arrow keys to
complete the entry. While in Point
mode, the arrow keys change
the selected cell reference in the
range you are selecting.
when cell D14 is active
cell, formula bar displays
Function box changes
back to Name box
when Enter box clicked
or ENTER key pressed
What is the purpose of the
parentheses in the function?
The AVERAGE function requires
that the argument (in this case,
the range D4:D12) be included
within parentheses following the
function name. Excel automatically
appends the right parenthesis to
complete the AVERAGE function
when you click the Enter box or
press the ENTER key.
1. Click Insert Function box in
formula bar, click AVERAGE
2. Click Sum button arrow
on Ribbon, click Average
3. Click Formulas tab on
Ribbon, click AutoSum
button arrow, click Average