Microsoft Office Tutorials and References

In Depth Information

**Verifying Formulas Using Range Finder**

To Save a Workbook Using the Same File Name

Earlier in this project, an intermediate version of the workbook was saved using

the i le name, The Mobile Masses Biweekly Payroll Report. The following step saves the

workbook a second time, using the same i le name.

1

Click the Save button on the Quick Access Toolbar to overwrite the previously saved i le.

Break Point:
If you wish to take a break, this is a good place to do so. You can quit Excel now. To resume at a later time, start

Excel, open the i le called Mobile Masses Biweekly Payroll Report, and continue following the steps from this location forward.

Verifying Formulas Using Range Finder

Entering Functions

You can drag the Function

Arguments dialog box

(Figure 2 – 20 on page

EX 86) out of the way in

order to select a range.

You also can click the

Collapse Dialog button to

the right of the Number 1

box to hide the Function

Arguments dialog box.

The dialog box then

collapses and the Collapse

Dialog button becomes an

Expand Dialog box button.

After selecting the range,

click the Expand Dialog to

expand the dialog box.

One of the more common mistakes made with Excel is to include a wrong cell reference

in a formula. An easy way to verify that a formula references the cells you want it to

reference is to use the Excel Range Finder. Use
Range Finder
to check which cells are

referenced in the formula assigned to the active cell. Range Finder allows you to make

immediate changes to the cells referenced in a formula.

To use Range Finder to verify that a formula contains the intended cell references,

double-click the cell with the formula you want to check. Excel responds by highlighting

the cells referenced in the formula so that you can check that the cell references are correct.

To Verify a Formula Using Range Finder

The following steps use Range Finder to check the formula in cell J4.

1

•

Double-click cell J4 to

activate Range Finder

(Figure 2 – 29).

2

cells referenced in

formula in active cell

are highlighted with

corresponding colors

•

Press the

ESC
key to

quit Range Finder and

then click anywhere

in the worksheet, such

as cell A18, to deselect

the current cell.

colors of cell references

correspond to colors of

highlighted cells

Figure 2 – 29