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




Custom Search