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.
Answer: C
You might also like to view...
In a query, conditions that are used to help select records are called ________
A) Quick Info B) operators C) criteria D) IntelliSense
The Reset command is used to change multiple occurrences of the same text in a presentation
Indicate whether the statement is true or false