4. What is the total annual sales for each region? (Enter your Total Sales to 2 decimal places.) Required information [The following information applies to the questions displayed below.] This Applying Excel worksheet includes an explanation of the Plvot Table and other Data Visualization charts. 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: Required: Create a Plvot 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.) 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.) 6. Now, using the Pivot Table, determine the monthly sales earned by each region. Use that data to create a 20 clustered column chart. Based on that column bar chart, identify the reglons that had the highest and lowest monthly sales for the entire year. (Enter your Total Sales to 2 decimal places.) 3. Which rep has the highest total sales for each region? (Enter your Total Sales to 2 decimal places.) 3. Which rep has the highet 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.) Required information [The following information applies to the questions displayed below.] This Applying Excel worksheet includes an explanation of the Plvot Table and other Data Visualization charts. 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: Required: Create a Plvot 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.) 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.) 6. Now, using the Pivot Table, determine the monthly sales earned by each region. Use that data to create a 20 clustered column chart. Based on that column bar chart, identify the reglons that had the highest and lowest monthly sales for the entire year. (Enter your Total Sales to 2 decimal places.) 3. Which rep has the highest total sales for each region? (Enter your Total Sales to 2 decimal places.) 3. Which rep has the highet total sales for each region? (Enter your Total Sales to 2 decimal places.)
