Which of the following is a useful tool for understanding and troubleshooting a spreadsheet model
A) Data tables
B) VLOOKUP function
C) Formula auditing
D) SUMPRODUCT function

Question

Which of the following is a useful tool for understanding and troubleshooting a spreadsheet model
A) Data tables 
B) VLOOKUP function 
C) Formula auditing 
D) SUMPRODUCT function

Quizplus · Accepted Answer

Formula auditing is the best tool for understanding and troubleshooting a spreadsheet model as it helps to trace precedents, dependents, and errors in the formulas used in the model. Data tables are useful for conducting what-if analysis, VLOOKUP function is used to lookup and retrieve data from a range or table, and SUMPRODUCT function is used to sum the product of corresponding values in two or more arrays, but none of these tools are particularly useful for troubleshooting a model.

Which of the Following Is a Useful Tool for Understanding