Microsoft Office Tutorials and References
In Depth Information
To Enter Formulas Using Point Mode
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).
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.
Enter box
value of formula
(440 x 82.99)
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 nine digits after the decimal
point, then Excel displays the true value 0.284873819.
value of formula
(36515.6 – 28419.6)
Figure 2–10
 
 
Search JabSto ::




Custom Search