Tracing Precedents - Exercise

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

Tracing Precedents

Duration: 5 to 15 minutes.

In this exercise, you will practice tracing precedents.

  1. Open Auditing Formulas.xlsx from your Excel2013.3/Exercises folder.
  2. What are the first-level precedents for cell B5?
  3. What are the second-level precedents for cell B5?
  4. What are the first-level precedents for cell B11?
  5. What are the second-level precedents for cell B11?

Solution:

  1. The first-level precedents for cell B5 are cells B3 and B4. To figure this out:
    1. Select cell B5.
    2. On the FORMULAS tab, in the Formula Auditing group, click the Trace Precedents command:Trace Precedents
    3. The preceding cells are indicated by the arrow:Arrow
  2. The second-level precedents for cell B5 are cells B12 and B13 in the sheet named "Revenue". To figure this out:
    1. Click Trace Precedents again.
    2. Double-click the small circles next to the images of the sheets in order to open the Go To dialog box showing the sheets and cells:Go To Dialog Box
  3. Remove the arrows showing the precedents for cell B5 by clicking Remove Arrows:Remove Arrows
  4. The first-level precedents for cell B11 are cells B5 and B10. To figure this out:
    1. Select cell B11.
    2. On the FORMULAS tab, in the Formula Auditing group, click the Trace Precedents command:Formula Auditing Group
    3. The preceding cells are indicated by the arrow:Preceding Cells
  5. The second-level precedents for cell B11 are cells B3:B4 and cells B7:B9. To figure this out:
    1. Click Trace Precedents again.
    2. The preceding cells are indicated by the arrows pointing to B5 and B10:Arrow Pointing to Cells
Next