Which of the following is a useful tool for investigating what-if questions
A) Data tables
B) VLOOKUP function
C) Formula auditing
D) SUMPRODUCT function

Question

Which of the following is a useful tool for investigating what-if questions
A) Data tables 
B) VLOOKUP function 
C) Formula auditing 
D) SUMPRODUCT function

Quizplus · Accepted Answer

Data tables are a useful tool for investigating what-if questions by allowing users to understand how changing variables can impact the outcome of a formula. The user can create a table of possible input values and see how they affect the resulting output. This can be particularly useful in financial analysis or forecasting. VLOOKUP, formula auditing, and SUMPRODUCT can also be useful tools in data analysis, but they are not specifically designed for investigating what-if questions.

Which of the Following Is a Useful Tool for Investigating