Which scenario would best be resolved using precedent cell tracers?
A. Leon opens an Excel spreadsheet and notices that someone types the wrong formula in cell D12.
B. Leon needs to know which other cells use the contents in D12.
C. Leon opens an Excel spreadsheet and notices a formula in cell D12. He wants to know which other cells in different workbooks use that formula. Leon opens an Excel spreadsheet and notices an error in the formula. The formula is very complex, and Leon cannot find the cells that are identifiers in the formula.
D. Leon opens an Excel spreadsheet and sees a Pivot Table. He notices an error in the formula in one of the cells. The formula is very complex, and Leon cannot find the cells that are identifiers in the formula.