Applying Excel - Data Visualization: Exercise (Part 2 of 2) Please answer all

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	$	23.00	per case
Pens	$	9.00	per box
Sticky Notes	$	10.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 total units ordered and the highest total sales? (Enter your Units Ordered to the nearest whole unit and your Total Sales to 2 decimal places.) Units Ordered Total Sales Region 3. Which rep has the highest total sales for each region? (Enter your Total Sales to 2 decimal places.) East Midwest South West Product Region East Midwest South West Rep Name Total 4. What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places.) Total Sales Total Sales 5. Using the data from requirement 4, create a pie chart to determine the sales percentage for each region. (Enter your Sales Percentage to the nearest whole percent.) Region East Midwest South West Sales Percentage %6 % % % 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. (Enter your Total Sales to 2 decimal places.) Region with Highest Earning Month Region with Lowest Earning Month Region Month Total Sales Required: Create a Pivot Table and determine the following information while analyzing the data: 2. Which product has the highest total units ordered and the highest total sales? (Enter your Units Ordered to the nearest whole unit and your Total Sales to 2 decimal places.) Units Ordered Total Sales Region 3. Which rep has the highest total sales for each region? (Enter your Total Sales to 2 decimal places.) East Midwest South West Product Region East Midwest South West Rep Name Total 4. What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places.) Total Sales Total Sales 5. Using the data from requirement 4, create a pie chart to determine the sales percentage for each region. (Enter your Sales Percentage to the nearest whole percent.) Region East Midwest South West Sales Percentage %6 % % % 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. (Enter your Total Sales to 2 decimal places.) Region with Highest Earning Month Region with Lowest Earning Month Region Month Total Sales