Q: Setting up a spreadsheet so that all the assumptions are contained in a well-defined section is valuable because (more than one answer could be correct)
or
Q: Because more than one response may be right, it is beneficial to set up a spreadsheet such that all of the assumptions are contained in a clearly defined area.
- It makes the calculations more precise
- It allows for easier re-calculation of results under alternative scenarios
- It makes it easier to blame someone else if things go wrong
- It minimizes the number of cells you ever change, thereby reducing the likelihood of inadvertent errors
Explanation: It is easy to change important inputs and observe how various situations impact the outcomes when assumptions are grouped together.It is less necessary to alter several cells when there is a distinct area designated for assumptions, which helps to avoid unintentional modifications in other areas of the spreadsheet.
