When using a spreadsheet package to answer "what if" questions, the user must change:
A) Only a selected variable to see the impact of that change
B) A number of variables to make a single change to the spreadsheet output
C) All the formulas in order to calculate new values
D) Nothing - spreadsheets cannot be used to answer "what if" questions

Question

Quizplus · Accepted Answer

When using a spreadsheet package to answer "what if" questions, the user must change only a selected variable to see the impact of that change. This is the basic concept of conducting sensitivity analysis with spreadsheets. By changing a single variable, the user can see how it affects the entire output of the spreadsheet.

When Using a Spreadsheet Package to Answer "What If" Questions