Page 126 - Excle-En-V3

Dependent cells: These cells contain formulas that refer to other cells. For
example, if cell D10 contains the formula =B5, then cell D10 is a dependent cell on
cell B5.

To help verify formulas, you can use the Trace Precedents and Trace Dependents
commands to display relationships between these cells and their formulas
graphically, using arrows as illustrated in this diagram.

Figure 183: Tracking shares

Figure 184: Precedent cells& Dependent cells

Figure 185 Formula Auditing Commands

118 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024