Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
Break Point:
If you wish to take a break, this is a good place to do so. You can exit Excel now. To resume at a later
time, run Excel, open the le called HyperMass Online Storage Salary Report, and continue following the steps from
this location forward.
Verifying Formulas Using Range Finder
One of the more common mistakes made with Excel is to include an incorrect cell
reference in a formula. An easy way to verify that a formula references the cells you
want it to reference is to use Range Finder.
Range Finder
checks which cells are
referenced in the formula assigned to the active cell.
To use Range Finder to verify that a formula contains the intended cell
references, doubletap or doubleclick the cell with the formula you want to check.
Excel responds by highlighting the cells referenced in the formula so that you can
verify that the cell references are correct.
1
ENTER
FORMULAS

2
ENTER
FUNCTIONS

3
VERIFY
FORMULAS
4
FORMAT
WORKSHEET

5
CHECK
SPELLING

6
PRINT
WORKSHEET
To Verify a Formula Using Range Finder
Why?
Range Finder allows you to make immediate changes to the cells referenced in a formula.
The following
steps use Range Finder to check the formula in cell H4.
1
•
Doubletap or
doubleclick cell H4
to activate Range
Finder (Figure 2 – 26).
2
•
Press the
ESC
key to
quit Range Finder
and then tap or click
anywhere in the
worksheet, such as
cell A18, to deselect
the current cell.
cells referenced in formula
in active cell are highlighted
with corresponding colors
Figure 2 – 26
Formatting the Worksheet
Although the worksheet contains the appropriate data, formulas, and functions,
the text and numbers need to be formatted to improve their appearance and
readability.