Which of the following can be done using the auditing tools in Excel?
A) Trace the cells that make reference to a particular cell.
B) Trace the cells that a particular cell refers to.
C) Trace the history of values for a particular cell.
D) Determine the valid entries in a particular cell.
E) Trace the cells that make reference to a particular cell and trace the cells that a particular cell refers to only.

Question

Quizplus · Accepted Answer

Excel's auditing tools allow users to trace precedents (cells that a particular cell refers to) and dependents (cells that reference a particular cell), but they do not provide functionality for tracing the history of values for a particular cell or determining valid entries directly.

Which of the Following Can Be Done Using the Auditing