Microsoft Office Tutorials and References
In Depth Information
Entering Formulas
1 ENTER FORMULAS | 2 ENTER FUNCTIONS | 3 VERIFY FORMULAS
4 FORMAT WORKSHEET | 5 CHECK SPELLING | 6 PRINT WORKSHEET
To Enter Formulas Using Point Mode
The sketch of the worksheet in Figure 2 – 3 on page EX 68 calls for the federal tax, state tax, tax percent,
and net pay for each employee to appear in columns F, G, H, and I, respectively. All four of these values are
calculated using formulas in row 4:
Federal Tax (cell F4) = 0.22 (Gross Pay – Dependents 24.32) or =0.22 * (E4 – B4 * 24.32)
State Tax (cell G4) = 0.04 Gross Pay or =0.04 * E4
Tax % (cell H4) = (Federal Tax + State Tax) / Gross Pay or =(F4 + G4)/E4
Net Pay (cell I4) = Gross Pay – (Federal Tax + State Tax) or =E4 – (F4 + G4)
An alternative to entering the formulas in cells F4, G4, H4, and I4 using the keyboard is to enter the
formulas using the pointer and Point mode. Point mode allows you to select cells for use in a formula by using
your nger or the pointer. The following steps enter formulas using Point mode. Why? Using Point mode makes it
easier to create formulas without worrying about typographical errors when entering cell references.
1
With cell F4 selected,
type =0.22*( to
begin the formula
and then tap or
a cell reference
in the formula
(Figure 2 – 7).
marquee
surrounds
selected
cell E4
cell reference
E4 appended to
formula
Figure 2 – 7
2
Type (minus
sign) and then tap or
click cell B4 to add a
subtraction operator
and a reference to
another cell to the
formula.
Type *24.32) to
complete the formula
(Figure 2 – 8).
cell reference