Applying excel Data Visualization: Exercise On the Data Vision Shident tab in your Excel spreadsheet update the price per unit for all four products for Office Warehouse Inc with the data below Price 53.per 500 per box 5 10.5 per package $3.00 per Lopes 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 tot solet (Enter your units Ordered to the nearest whole unit and your Total Sales to 2 decimal places) IS 5 500 Region Rep Name Philips Total sales $ 8.973.00 $ 9.397.00 $ 8612.00 $ 581000 South West hoore 4 What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places) Tocad Sales $23.50000 Region East Midwest South West 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.) Sales Percentage E Midwest South West 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.) Month Total Sales Region with Highest Earning Month Region with Lowest Earning Month Region East West Applying excel Data Visualization: Exercise On the Data Vision Shident tab in your Excel spreadsheet update the price per unit for all four products for Office Warehouse Inc with the data below Price 53.per 500 per box 5 10.5 per package $3.00 per Lopes 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 tot solet (Enter your units Ordered to the nearest whole unit and your Total Sales to 2 decimal places) IS 5 500 Region Rep Name Philips Total sales $ 8.973.00 $ 9.397.00 $ 8612.00 $ 581000 South West hoore 4 What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places) Tocad Sales $23.50000 Region East Midwest South West 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.) Sales Percentage E Midwest South West 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.) Month Total Sales Region with Highest Earning Month Region with Lowest Earning Month Region East West
