The two primary Excel tools for diagnosing problems in models are ___________________.
A) Error Auditing and Formula Checking
B) Error Auditing and Formula Auditing
C) Error Checking and Formula Auditing
D) Error Checking and Formula Checking
E) Error Diagnosing and Formula Debugging

Question

Quizplus · Accepted Answer

The two primary Excel tools for diagnosing problems in models are Error Checking and Formula Auditing. Error Checking identifies and highlights any errors in the formula, while Formula Auditing visually traces the precedent or dependent cells for the selected cell or formula to check if there are any errors. Therefore, the answer is C - Error Checking and Formula Auditing.

The Two Primary Excel Tools for Diagnosing Problems in Models