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