Multiple Choice
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.
Correct Answer:

Verified
Correct Answer:
Verified
Q26: In a well-designed worksheet,row and column headings
Q27: _ validation is generally used to limit
Q28: Data _ is a means of increasing
Q29: _ validation works very similar to decimal
Q30: A(n)_ is a form of computer program
Q32: All of the following statements are TRUE
Q33: When you choose to trace dependents and
Q34: If the location where a file is
Q35: The _ tab is used to hide
Q36: _ represents a means of communicating the