Microsoft Office Tutorials and References

In Depth Information

**Entering Formulas**

5

•
in the formula bar to

enter the formula in

cell I4.

Click the Enter box

formula assigned

to cell J4

•

Select cell J4. Type

=(
(equal sign

followed by an open

parenthesis) and then

click cell G4 to add

a reference to the

formula.

•

Type

+
(plus sign)

and then click cell H4

to add a cell reference

to the formula.

value of formula (288.9271 +

53.505 ) / 1337.625

•

Type

)/
(close

parenthesis followed

by a forward slash),

and then click cell F4

to add a cell reference

to the formula.

•
in the formula bar to

enter the formula in

cell J4 (Figure 2 – 11).

Why do three decimal places show in cell J4?

The actual value assigned by Excel to cell J4 from the division operation in step 5 is

0.256000075. While not all the decimal places appear in Figure 2 – 11, Excel maintains all of

them for computational purposes. Thus, if referencing cell J4 in a formula, the value used

for computational purposes is 0.256000075, not 0.256. The cell formatting is set to display six

digits after the decimal point, but the formatting also suppresses trailing zeroes. If the cell

formatting were set to display six digits and show trailing zeroes, then Excel would display

0.256000 in cell J4. If you change the cell formatting of column J to display nine digits after

the decimal point, then Excel displays the true value 0.256000075.

Click the Enter box

Figure 2–11

To Copy Formulas Using the Fill Handle

The i ve formulas for Emily Charvat in cells F4, G4, H4, I4, and J4 now are complete. You could enter the

same i ve formulas one at a time for the eight remaining employees. A much easier method of entering the formulas,

however, is to select the formulas in row 4 and then use the i ll handle to copy them through row 12. When performing

copying operations in Excel, the source area is the cell, or range, from which data or formulas are being copied. When a

range is used as a source, sometimes it is called the source range. The destination area is the cell, or range, to which data

or formulas are being copied. When a range is used as a destination, sometimes it is called the destination range. Recall

from Chapter 1 that the i ll handle is a small rectangle in the lower-right corner of the active cell or active range. The

following steps copy the formulas using the i ll handle.