Microsoft Office Tutorials and References
In Depth Information
ENTER FORMULAS
using a variety of methods
In Excel, you can carry out calculations such as
simple arithmetic in three ways. One method is to
use the plus (+), minus (–), multiplication (*), and
division (/) signs. Start by typing an equal sign and
the values to be added, subtracted, multiplied, or
divided, each separated by an operator; for example,
=25 + 31 . Press Enter, and Excel does the math and
displays the answer in the same cell. You can also
type an equal sign, click in a cell that contains the
value you want to perform an operation on, and then
type the operator.
A second method involves functions. Functions
perform calculations on your information and make
the results available to you. To use a function, type
an equal sign followed by the function; for example,
=SUM() . Place the numbers you want to add inside
the parentheses, separating them with commas. If
the numbers are on the worksheet, click the cells.
A third method is to use Excel’s AutoSum feature,
which offers a point-and-click interface for several
functions, including SUM , AVERAGE , and COUNT .
C ALCULATE WITH AN O PERATOR
1 Type .
2 Click in the cell with the number
you want to use in your
calculation, or type the first
number.
3 Type an operator, such as plus
(+), minus (–), multiply (*), or
divide (/).
4 Click in the cell with the number
you want to use in your
calculation, or type the next
number.
5 Repeat Steps 2 to 4, if necessary.
6 Press Enter.
l The result appears in the current
cell.
C ALCULATE BY U SING A F UNCTION AND
C ELL A DDRESSES
1
1
3
2
4
5
Type the numbers you want to
calculate into adjacent cells.
2
In another cell, type = followed
by the first few letters of the
function.
A list of options appears.
1
2
3
4
3
Double-click the option you
want to use.
4
Click and drag to select the
numbers you want to calculate.
24
5
Click Check.

Search JabSto ::

Custom Search