Question: Applying Excel - Data Visualization: Exercise (Part 2 of 2) On the Data Visualization Student tab in your Excel spreadsheet, update the price per unit

Applying Excel - Data Visualization: Exercise (Part 2 of 2) On the Data Visualization Student tab in your Excel spreadsheet, update the price per unit for all four products for Office Warehouse Inc. with the data below: Products Available Price per Unit Paper $ 21.00 per case Pens $ 9.00 per box Sticky Notes $ 9.50 per package Envelopes $ 4.50 per box Required: Create a Pivot Table and determine the following information while analyzing the data: 2. Which product has the highest? 3. 3. Which rep has the highest total sales for each region? (Enter your Total Sales to 2 decimal places.) 4. What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places.) 5. Using the data from requirement 4, create a pie chart to determine the sales percentage for each region. 6. Now, using the Pivot Table, determine the monthly sales earned by each region. Use that data to create a 2D clustered column chart. Based on that column bar chart, identify the regions that had the highest and lowest monthly sales for the entire year

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!