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:
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.