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
 
Search JabSto ::




Custom Search