Microsoft Office Tutorials and References
In Depth Information
Entering Formulas
EX 91
To Enter a Formula Using the Keyboard
The initial cost for each stock, which appears in column F, is equal to the number of shares in column D times
the initial price per share in column E. Thus, the initial cost for Apple Computers in cell F4 is obtained by multiplying
440 (cell D4) by 64.59 (cell E4) or =D4*E4. The following steps enter the initial cost formula in cell F4 using the
With cell F4 selected, type =d4*e4
in the cell to display the formula
in the formula bar and in cell F4
and to display colored borders
around the cells referenced in the
formula (Figure 2–5).
formula begins
with equal sign
What is happening on the worksheet
as I enter the formula?
The equal sign (=) preceding
d4*e4 is an important part of the
formula. It alerts Excel that you
are entering a formula or function
and not text. Because the most
common error when entering a
formula is to reference the wrong
cell in a formula mistakenly, Excel
colors the borders of the cells
referenced in the formula. The
coloring helps in the reviewing process
to ensure the cell references are
correct. The asterisk (*)
following d4 is the arithmetic operator
that directs Excel to perform the
multiplication operation.
as formula is typed, it
appears in the formula
bar and in active cell F4
colored cell borders
indicate cells
included in formula
in active cell
Figure 2–5
Press the RIGHT ARROW key twice to
complete the arithmetic operation
indicated by the formula, display
the result, 28419.6, and to select
cell H4 (Figure 2–6).
active cell is H4
after pressing RIGHT
ARROW key twice
value of formula
(440 x 64.59)
Figure 2–6
C6161_EXC_02.4c.indd 91
C6161_EXC_02.4c.indd 91
3/6/07 3:28:10 PM
3/6/07 3:28:10 PM
Search JabSto ::

Custom Search