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:

Gallbladder

A small organ located under the liver, which stores and concentrates bile, a digestive enzyme produced by the liver.

Bile

A digestive fluid produced by the liver and stored in the gallbladder that aids in the digestion of fats.

Feces

Waste matter discharged from the bowels after food has been digested; excrement.

Stools

Feces; the waste matter discharged from the bowels after food has been digested.