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)a and b only

Question

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)a and b only

Quizplus · Accepted Answer

Auditing tools in Excel can be used to trace the dependents and precedents of a particular cell, which means option A and B are correct. However, tracing the history of values for a particular cell and determining the valid entries in a particular cell cannot be done with auditing tools in Excel. Hence, option C and D are not correct. Therefore, the best choice is E.

Which of the Following Can Be Done Using the Auditing