Microsoft Office Tutorials and References
In Depth Information
EX 94
Excel Chapter 2 Formulas, Functions, Formatting, and Web Queries
3
Click the Enter box and then click
cell I4 to select cell I4.
Type = (equal sign) and then click
cell H4 to add a reference to cell
H4 to the formula.
formula appears
in formula bar
Type (minus sign) and then
click cell F4 to add a subtraction
operator and reference to cell F4
to the formula (Figure 2–9).
Enter box
value of formula
(440 x 82.99)
When should I use Point mode to
enter formulas?
Using Point mode to enter
formulas often is faster and more
accurate than using the keyboard
to type the entire formula when
the cell you want to select does
not require you to scroll. In many
instances, as in these steps, you may want to use both the keyboard and mouse when entering
a formula in a cell. You can use the keyboard to begin the formula, for example, and then
use the mouse to select a range of cells.
marquee
surrounds
selected cell F4
cell reference
F4 appended
to formula
Figure 2–9
4
Click the Enter box to enter the
formula in cell I4.
Select cell J4. Type = (equal sign)
and then click cell I4 to add a
reference to cell I4 to the formula.
formula
assigned to
cell J4
Type / (forward slash) and then
click cell F4 to add a reference to
cell F4 to the formula.
value of formula
(8096 / 28419.6)
Click the Enter box to enter the
formula in cell J4 (Figure 2–10).
Why do only six decimal places
show in cell J4?
The actual value assigned by Excel
to cell J4 from the division
operation in Step 4 is 0.284873819.
While not all the decimal places
appear in Figure 2–10, Excel maintains
all of them for computational purposes. Thus, if referencing cell J4 in a formula, the value
used for computational purposes is 0.284873819, not 0.284874. Excel displays the value in
cell J4 as 0.284874 because the cell formatting is set to display only six digits after the
decimal point. If you change the cell formatting of column J to display 15 digits after the decimal
point, then Excel displays the true value 0.284873819.
value of formula
(36515.6 – 28419.6)
Figure 2–10
C6161_EXC_02.4c.indd 94
C6161_EXC_02.4c.indd 94
3/6/07 3:28:16 PM
3/6/07 3:28:16 PM
Search JabSto ::




Custom Search