Microsoft Office Tutorials and References

In Depth Information

• Compare versions of a workbook

• Analyze a workbook for potential problem and inconsistencies

• Display interactive diagnostics (shown in the figure here)

• Visualize links between workbook and worksheets

• Clear excess cell formatting

• Manage passwords

Tracing cell relationships

To understand how to trace cell relationships, you need to familiarize yourself with the following two concepts:

•
Cell precedents:
Applicable only to cells that contain a formula, a formula cell's precedents are all the cells

that contribute to the formula's result. A
direct precedent
is a cell that you use directly in the formula. An

indirect precedent
is a cell that is not used directly in the formula, but is instead used by a cell that you refer

to in the formula.

•
Cell dependents:
These are formula cells that depend on a particular cell. A cell's dependents consist of all

formula cells that use the cell. Again, the formula cell can be a direct dependent or an indirect dependent.

For example, consider this simple formula entered into cell A4:

=SUM(A1:A3)

Cell A4 has three precedent cells (A1, A2, and A3), which are all direct precedents. Cells A1, A2, and A3 each

have at least one dependent cell (cell A4), and A4 is a direct dependent of all of them.