E. Data mining can be used to identify customers.
80. 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.
81. Amanda is working for the CEO of a small company. He asks her to develop a dashboard. Amanda
starts thinking about the questions she needs to ask. Which of the following questions is not on
Amanda’s list?
A. How many levels do you wish to drill down?
B. What are your key performance indicators?
C. Do you need real-time data?
D. Do you want graphs and charts or text?
E. Should it run on your iPhone?
82. Elena is trying to decide whether she should expand her ice cream shop to a bigger space. She
decides to be very methodical about it and follow the phases of the decision-making process she
learned in college. Which of the following statements is true?
A. During the intelligence phrase, Elena will build a model using assumptions about the business.
B. During the design phrase, Elena will define the opportunity.
C. During the choice phase, Elena will lay out her options.
D. During the implementation phase, Elena will implement two of her solutions.
E. Elena will use test data to validate her model.