Microsoft Office Tutorials and References
In Depth Information
l The result appears in
the cell.
C ALCULATE BY U SING A UTOSUM
1
3
In adjacent cells, type
numbers.
2
Click the cell in which
you want the result.
3
Click the Formulas tab.
2
1
4
Click here and select an option.
4
This example uses SUM .
l
Excel places =sum() in the cell, with the
cell address for numbers you may want
to add.
l
5
To accept the cell addresses chosen by
Excel, press Enter.
To select other addresses, click and drag
them and then press Enter.
The result appears in the cell selected in
Step 2.
Did You Know?
You can click the chevron ( ) at
the end of the formula bar to
expand and collapse the bar.
Expanding the formula bar lets
you enter longer formulas.
Did You Know?
When you click and drag over
multiple cells, Excel automatically
places the average, a number
count, and the sum of the values
on the status bar, at the bottom
of the screen.
Did You Know?
You can add buttons for equal,
plus, minus, divide, and multiply
to the Quick Access toolbar. You
can use these buttons to enter
formulas quickly. To learn how to
add buttons to the Quick Access
toolbar, see Task #95.
Chapter 2: Work with Formulas and Functions
25
 
Search JabSto ::




Custom Search