# Tracing Precedents - Exercise

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:
3. The preceding cells are indicated by the 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:
3. Remove the arrows showing the precedents for cell B5 by clicking 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:
3. The preceding cells are indicated by the arrow:
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: