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

keyboard.

1

•
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

2

•
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