Microsoft Office Tutorials and References
In Depth Information
EX 100
Excel Chapter 2 Formulas, Functions, Formatting, and Web Queries
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).
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
marquee. When you begin dragging,
Excel appends to the argument a
colon (:) and the cell reference of
the cell where the mouse pointer
is located.
AVERAGE function
with range to average
shows in active cell
and formula bar
Enter box
marquee surrounds
selected range D4:D12
AVERAGE function
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).
Figure 2–17
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
AVERAGE function
Function box changes
back to Name box
right parenthesis
automatically appended
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.
average shares
per stock
Figure 2–18
Other Ways
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, click Average
C6161_EXC_02.4c.indd 100
C6161_EXC_02.4c.indd 100
3/6/07 3:28:26 PM
3/6/07 3:28:26 PM
Search JabSto ::

Custom Search