One of the uses of a spreadsheet model is to ask 'what if' questions and carry out analysis. Which of the following is a correct description of a
'what if' analysis?
A) All the cells in a spreadsheet will be updated whenever an entry is changed
B) Numerical cells in a spreadsheet can be formatted in a variety of ways
C) The model can be emptied of data when circumstances require it to be changed
D) Changes in data input will cause the model to recalculate giving an indication of the possible results of the change
E) A management technique which is just a management fad

Question

Quizplus · Accepted Answer

'What if' analysis involves changing data inputs in a model to see how those changes affect the outcomes, allowing for exploration of different scenarios.

One of the Uses of a Spreadsheet Model Is to Ask