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




Custom Search