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...
Describe the purpose of integrity constraints and identify the main types of constraints on a logical data model.
What will be an ideal response?
A one-way __________ mechanism can provide better password security with very little extra effort.
a. compression b. SSL c. hashing d. biometric
Moving from left to right, the first calculation in the order of operations is negation (-).
Answer the following statement true (T) or false (F)
What type of an IDS is being used when it does not take any action to stop or prevent an activity occurring?
A. dormant system B. nondynamic system C. passive system D. active system