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
