Case 8-2
Last year, your cousin Margie started a small business selling crafting and needlework supplies to small retailers across the state. She has recorded her company's annual sales data totals in a worksheet indicating city, store, and product. Going forward, Margie needs to direct her limited resources toward promoting her top products and improving her business relationships with her top retailers. To do this, she needs to carefully analyze the first year's sales data.
-Margie gives you a call to thank you for your suggestions on analyzing the company's sales data. She tells you that she now needs to prepare some easy-to-understand visual aids based on the data for a meeting with her banker. You suggest that she ____.
A) create one or more PivotChart reports based on the data; move each chart to its own chart sheet; print copies of each chart sheet for the meeting
B) bring you to the meeting so that you can explain the data
C) create a SmartArt graphic that shows the most important elements from her sales analysis; e-mail the graphic to the banker
D) import the data totals into a text file and then print copies of the text file for the meeting

Question

Quizplus · Accepted Answer

Creating PivotChart reports based on the data would allow Margie to easily identify her top products and retailers. Moving each chart to its own sheet would make it easy to print and share with the banker. SmartArt graphics might not be detailed enough for the banker and printing copies of a text file would not provide visual aids for the presentation. Bringing the cousin to the meeting to explain the data would also not provide visual aids for the banker.

Case 8-2 Last Year, Your Cousin Margie Started a Small Business Selling