Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started