Question

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 sends you a text message inviting you to lunch on Saturday. She needs your help with her sales analysis. During lunch, Margie tells you she has tried filtering the worksheet sales data, but can’t quite get to the information she needs. You suggest that she ____.

a.	just sort the data in the desired order; then copy the sorted data and paste it on a new worksheet for analysis	c.	copy the data and paste it into a Word document as a table; then analyze the data using Word’s superior analysis tools
b.	hire an accounting firm to do the analysis	d.	create a PivotTable based on the data so that she can interactively group and total her data in a variety of ways

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	c.	create a SmartArt graphic that shows the most important elements from her sales analysis; e-mail the graphic to the banker
b.	bring you to the meeting so that you can explain the data	d.	import the data totals into a text file and then print copies of the text file for the meeting

Answer 1

Question: 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 sends you a text message inviting you to lunch on Saturday. She needs your help with her sales analysis. During lunch, Margie tells you she has tried filtering the worksheet sales data, but can’t quite get to the information she needs. You suggest that she ____.

Answer: d. create a PivotTable based on the data so that she can interactively group and total her data in a variety of ways

Pivot table helps us in analyzing the data in various ways by ways of grouping the in interactive ways with the feature of filter, sort, addition, etc.

Option-a is incorrect as it involves a lot of manual work and may lead to errors. Option-b is incorrect as hire an accounting firm to do the analysis will increase cost when it can be done simply in excel. Option-c is incorrect as Excel is more than sufficient to carry out the analysis and word cannot be used for such analysis.

Question:

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 ____.

Answer: c. create a SmartArt graphic that shows the most important elements from her sales analysis; e-mail the graphic to the banker

SmartArt graphic helps to organize and display the data / information / ideas in form of visual representation.

Option-a is incorrect, as Pivot table does not give a graphic representation and is not easy-to-understand visual aid. Option-b is incorrect as there is no need for us to attend as it can be simply done in SmartArt graphic. Option-d is incorrect ad it does not give a graphic representation and is not easy-to-understand visual aid.