Excel Video Tutorial In Telugu about Formula Auditing Part 17

Trace Precedents

You have to pay $96.00. To show arrows that indicate which cells are used to calculate this value, execute the following steps.

1. Select cell C13.

2. On the Formulas tab, in the Formula Auditing group, click Trace Precedents.
As expected, Total cost and Group size are used to calculate the Cost per person.

3. Click Trace Precedents again.
s expected, the different costs are used to calculate the Total cost.
Remove Arrows

To remove the arrows, execute the following steps.

1. On the Formulas tab, in the Formula Auditing group, click Remove Arrows.