Microsoft Office Tutorials and References

In Depth Information

**Entering Formulas**

3

•
Tap or click the

Enter box in the

formula bar and

then select cell

G4 to prepare to

enter the next

formula.

•
Type
=0.04*

and then tap or

click cell E4 to add

a cell reference

to the formula

(Figure 2 – 9).

Enter box

cell reference

E4 added to

formula

marquee

surrounds

selected

cell E4

Why 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 touch gestures or the pointer when entering a formula in a cell.

You can use the keyboard to begin the formula, for example, and then use touch gestures or the pointer to select a

range of cells.

Figure 2 – 9

4

•
Tap or click the Enter

box in the formula

bar to enter the

formula in cell G4.

•
Select cell H4.

Type
=(
(equal

sign followed by an

open parenthesis)

and then tap or

click cell F4 to add

a reference to the

formula.

•
Type
+
(plus sign)

and then tap or click

cell G4 to add a cell

reference to the

formula.

•
Type
)/
(close

parenthesis followed

by a forward slash),

and then tap or click

cell E4 to add a cell

reference to the formula.

•
Tap or click the Enter box in the formula

bar to enter the formula in cell H4 (Figure 2 – 10).

formula appears

in formula bar

Enter box

result of formula

to calculate tax

percentage appears

in cell H4

Figure 2 – 10