Excel: Sounds Good Page 1 2 3 4 5 6 7 8 9 10 11 12 13

Formulas -> Formula Auditing

Auditing Try it: Select cell E7 and click Trace Precedents. You will see an arrow from cell C7 and cell D7.    Click on Trace Precedents again. you can see where D7 gets its data. Remove All Arrows and try another audit experiment.   Select B2 and Trace Dependents. All of the equations in the D column depend on the data in B2 in order to calculate correctly. Click Trace Dependents a second time, and you will see a call out to another worksheet.   Remember that the Revenue for each product is added together on the Summary sheet. The equation was:   =Legs!E2+Eggs!E2+'Pigs in a Basket'!E5