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

question 69

Multiple Choice

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

---

Definitions:

Departmental Income Statements

Financial statements that report the revenues, costs, and income for individual departments within a company.

Investment Center Managers

Personnel responsible for overseeing an investment center, which is a division or unit within an organization judged on its profitability and return on investment.

Performance Measures

Quantitative or qualitative gauges used to compare, track, and assess the effectiveness or productivity of different aspects of an organization.

Income

Money received, especially on a regular basis, for work or through investments.