All of the following statements are TRUE about auditing formulas EXCEPT:
A)Tracing formulas draws lines from a formula to cells that supply source data and to formulas that use the result of a formula.
B)Formula-auditing tools show you which cells are used in a formula and how they are used.
C)When you select to trace dependents, Excel finds and marks with arrows all the cells that supply values to the active cell.
D)Both tracing a formula and evaluating a formula are useful in understanding how a worksheet is structured, and they are particularly useful if a complex formula is not producing a correct result.

Question

Quizplus · Accepted Answer

Explanation: The statement in C is incorrect because it describes the action of tracing precedents, not dependents. Tracing precedents shows cells that supply values to the active cell, while tracing dependents finds cells that depend on the value of the active cell.

All of the Following Statements Are TRUE About Auditing Formulas