Shawn Is Doing Some Budgeting for His New Start-Up Business

question 20

Multiple Choice

Shawn is doing some budgeting for his new start-up business. He has developed a budget in Excel using formulas, as he was taught to do in college. Which of the following statements is true?

• A) If Shawn changes one of his assumptions, Excel will automatically recalculate the budget numbers.
• B) Shawn would use sensitivity analysis to check the impact of changing his price.
• C) Shawn would use roll-up to review his summary numbers.
• D) Shawn would use what-if analysis to check the impact of changing his price and the commission he pays his sales people.
• E) Shawn would use goal-seeking analysis to examine the impact of changing his forecast of units sold.

---

Definitions:

Removing

The act of taking something away or eliminating it.

Album

A collection of audio recordings issued as a single item on CD, record, or digital format, typically by a single artist or band.

File

A collection of data or information that is stored under a specific name on a computer or digital device.

Full Collection

A term referring to the complete set of items or data within a specific category or library.