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:

Audience Analysis

The process of examining and understanding the characteristics, interests, and needs of the intended recipients of a message or product.

Sentence Length

Refers to the number of words in a sentence, impacting readability and tone.

Heading

A title or caption used at the beginning of a section of text to indicate its subject or to introduce its main content.

Support Material

Supplementary information or resources provided to enhance understanding, argumentation, or evidence in a presentation or report.