Microsoft Office Tutorials and References

In Depth Information

**Entering Formulas**

The gross pay for each employee, which appears in column E, is equal to hours worked in column C times

hourly pay rate in column D. Thus, the gross pay for Michael Carl in cell E4 is obtained by multiplying 60.45

(cell C4) by 19.50 (cell D4) or =C4 D4. The following steps enter the initial gross pay formula in cell E4 using

the keyboard.
Why?
In order for Excel to perform the calculations, you must create formulas.

1

•
With cell E4 selected,

type
=c4*d4
in

the cell to display

the formula in the

formula bar and in

the current cell and

to display colored

borders around the

cells referenced

in the formula

(Figure 2 – 5).

formula begins

with equal sign

as formula is typed, it

appears in formula bar

and in active cell E4

What occurs on the

worksheet as I enter

the formula?

The
equal sign
)
=

preceding c4*d4

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 c4 is the arithmetic operator that directs Excel to perform the multiplication operation.

colored cell

borders indicate

cells included

in formula in

active cell

Figure 2 – 5

2

•
Press the
RIGHT

ARROW
key to

complete the

arithmetic operation

indicated by the

formula, to display

the result in the

worksheet, and to

select the cell to the

right (Figure 2 – 6).

The number of

decimal places

shown in cell E4 may

be different, but

these values will be

adjusted later in this

chapter.

active cell is F4

after pressing

RIGHT ARROW key

result of

formula

Figure 2 – 6