Microsoft Office Tutorials and References

In Depth Information

17.
In the
Watch Window
, click the watch in the list.

18.
Click
Delete Watch
.

The watch disappears.

19.
On the
Formulas
tab, in the
Formula Auditing
group, click
Watch Window
.

The Watch Window closes.

CLEAN UP
Save the ConveyerBid workbook, and then close it. If you are not

continuing directly to the next chapter, exit Excel.

Key Points

●
You can add a group of cells to a formula by typing the formula, and then at the spot

in the formula in which you want to name the cells, selecting the cells by using the

mouse.

●
By creating named ranges, you can refer to entire blocks of cells with a single term,

saving you lots of time and effort. You can use a similar technique with table data,

referring to an entire table or one or more table columns.

●
When you write a formula, be sure you use absolute referencing ($A$1) if you

want the formula to remain the same when it’s copied from one cell to another,

or use relative referencing (A1) if you want the formula to change to reflect its

new position in the worksheet.

●
Instead of typing a formula from scratch, you can use the Insert Function dialog

box to help you on your way.

●
You can monitor how the value in a cell changes by adding a watch to the Watch

Window.

●
To see which formulas refer to the values in the selected cell, use Trace Dependents;

if you want to see which cells provide values for the formula in the active cell, use

Trace Precedents.

●
You can step through the calculations of a formula in the Evaluate Formula dialog

box or go through a more rigorous error-checking procedure by using the Error

Checking tool.