Posts
MS Excel : ENTER FORMULAS using a variety of methods
In Excel, you can perform calculations such as
Simple arithmetic in three ways. One method is
use the plus (+), minus (-), multiplication (*) and
signs of division (/). Start by writing an equal sign and
the values to add, subtract, multiply or
divided, each separated by an operator; for example,
= 25 + 31. Press Enter, and Excel does the calculations and
Show the answer in the same cell. You also can
type an equal sign, click on a cell that contains the
value at which you want to perform an operation, and then
write the operator
A second method involves functions. The functions
perform calculations on your information and do
The results available to you. To use a function, type
an equivalent sign pursued by the capacity; for instance,
= SUM (). Place the numbers you want to add inside
parentheses, separating them with commas. Yes
The numbers are on the worksheet, click on the cells.
A third method is to use the Excel AutoSum function,
which offers a point and snap interface for a few
functions, including SUM, AVERAGE and COUNTING.
CALCULATE WITH AN OPERATOR
1 type =.
2 Click in the cell with the number
do you want to use in your
calculation, or write the first
number.
3 Type an operator, as more
(+), minus (-), multiply (*) or
divide (/).
4 Click in the cell with the number
do you want to use in your
calculation, or write the following
number.
5 Repeat steps 2 to 4, if necessary.
6 Press Enter.
l The result appears in the current
cell.
CALCULATE USING A FUNCTION AND
CELLULAR ADDRESSES
1 Enter the numbers you want
calculate in adjacent cells.
2 In another cell, type = followed
for the first letters of the
function.
A list of options appears.
3 Double-click the option that
want to use.
4 Click and drag to select the
numbers you want to calculate.
5 Click Verify.
l The result appears in
the cell.
CALCULATE USING AUTOSUM
1 In adjacent cells, type
numbers.
2 Click on the cell in which
do you want the result
3 Click the Formulas tab.
4 Click here and select an option.
l This example uses SUM.
l Excel places = sum () in the cell, with the
cell address for the numbers you want
to add
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 on the gallon () inthe end of the formula bar to
Expand and contract the bar.
Expand the formula bar allows
You enter longer formulas.
Did you know
When you click and dragMultiple cells, Excel automatically
place the average, a number
account and sum of values
in the status bar, at the bottom
from the screen.
Did you know
You can add buttons for the same,more, less, divide and multiply
to the quick access toolbar. you
you can use these buttons to enter
formulas quickly To learn to
add buttons to quick access
toolbar,
