| Use the information provided in “Data” and only Excel Pivot Tables/Charts to provide an answer to the following questions. | |||||||||||||||
| Each question should have its own tab containing at least one Pivot Table. | |||||||||||||||
| Be sure to do so in a professional manner. | |||||||||||||||
| When performing a calculation, please make use of Calculated Fields (PivotTable Tools), as opposed to making the calculation on the “Data” sheet. | |||||||||||||||
| Question 1: Which product line sold most units in 2003? | |||||||||||||||
| Answer: | |||||||||||||||
| Question 2: Which product generated the highest $ revenue in 2004? | |||||||||||||||
| Answer: | |||||||||||||||
| Question 3: Which customers contributed to the top 20% of revenue,orders and sales volume in 2004? | |||||||||||||||
| (Hint: you should use three separate pivot tables) | |||||||||||||||
| Answer: | |||||||||||||||
| Question 4: What was the top selling product line in December 2003? | |||||||||||||||
| Answer: | |||||||||||||||
| Question 5: Build a Pivot Table chart that shows the number of orders by country, month, and year. Do you observe any trends? | |||||||||||||||
| Answer: | |||||||||||||||
