Tracing Dependents - Exercise

Contact Us or call 1-877-932-8228
Tracing Dependents - Exercise

Tracing Dependents

Duration: 5 to 10 minutes.

In this exercise, you will practice tracing dependents.

  1. Open Auditing Formulas.xlsx from your Excel2013.3/Exercises folder.
  2. What are the first-level dependents for cell B4?
  3. What are the second-level dependents for cell B4?

Solution:

  1. The first-level dependent for cell B4 is cell B5. To figure this out:
    1. Select cell B4.
    2. On the FORMULAS tab, in the Formula Auditing group, click the Trace Dependents command:Trace Dependents
    3. The dependent cells are indicated by the arrow:Arrow
  2. The second-level dependents for cell B4 are cells B8:E8 and cells B9 and B11. To figure this out:
    1. Click Trace Dependents again.
    2. The dependent cells are indicated by the arrows:Trace Dependents
  3. Remove the arrows by clicking Remove Arrows:Remove Arrows
Next