6 Management would like to know what is the split in terms of profit, across the Product Categories, for each quarter Use a Line Chart to show the numbers Rank the Product categories in terms of profit a Create a new worksheet titled Q6 Qtr Profit and insert a new pivot table for the data in the sheet Raw data Move the worksheet after 25 worksheet b List all the Product Categories in the 1st column c Split the Quarter across the categories Hint Drag the Date field in the Column Label area) To group the date by Quarter Click on the date field Next, right mouse click to display a menu Click the Group option Another menu will display Click on Months and Quarters 3 d Add the profit by category and quarter Format the data in currency format e Add meaningful column labels f Format the title at the top so stands out Add a meaningful title to the worksheet at the top and center it across the pivot table g Select the Pivot Table and click on Options Pivot Chart h Insert a Column Chart of your choice 6 Management would like to know what is the split in terms of profit, across the Product Categories, for each quarter Use a Line Chart to show the numbers Rank the Product categories in terms of profit a Create a new worksheet titled Q6 Qtr Profit and insert a new pivot table for the data in the sheet Raw data Move the worksheet after 25 worksheet b List all the Product Categories in the 1st column c Split the Quarter across the categories Hint Drag the Date field in the Column Label area) To group the date by Quarter Click on the date field Next, right mouse click to display a menu Click the Group option Another menu will display Click on Months and Quarters 3 d Add the profit by category and quarter Format the data in currency format e Add meaningful column labels f Format the title at the top so stands out Add a meaningful title to the worksheet at the top and center it across the pivot table g Select the Pivot Table and click on Options Pivot Chart h Insert a Column Chart of your choice

Question

6  Management would like to know   what is the split in terms of profit, across the Product Categories, for each quarter  Use a Line Chart to show the numbers  Rank the Product categories in terms of profit  a  Create a new worksheet titled Q6   Qtr  Profit and insert a new pivot table for the data in the sheet Raw data  Move the worksheet after 25 worksheet  b  List all the Product Categories in the 1st column  c  Split the Quarter across the categories   Hint  Drag the Date field in the Column Label area)  To group the date by Quarter   Click on the date field  Next, right mouse click to display a menu  Click the Group option  Another menu will display  Click on Months and Quarters  3 d  Add the profit by category and quarter  Format the data in currency format  e  Add meaningful column labels  f  Format the title at the top so stands out  Add a meaningful title to the worksheet at the top and center it across the pivot table  g  Select the Pivot Table and click on Options  Pivot Chart h  Insert a Column Chart of your choice  6  Management would like to know   what is the split in terms of profit, across the Product Categories, for each quarter  Use a Line Chart to show the numbers  Rank the Product categories in terms of profit  a  Create a new worksheet titled Q6   Qtr  Profit and insert a new pivot table for the data in the sheet Raw data  Move the worksheet after 25 worksheet  b  List all the Product Categories in the 1st column  c  Split the Quarter across the categories   Hint  Drag the Date field in the Column Label area)  To group the date by Quarter   Click on the date field  Next, right mouse click to display a menu  Click the Group option  Another menu will display  Click on Months and Quarters  3 d  Add the profit by category and quarter  Format the data in currency format  e  Add meaningful column labels  f  Format the title at the top so stands out  Add a meaningful title to the worksheet at the top and center it across the pivot table  g  Select the Pivot Table and click on Options  Pivot Chart h  Insert a Column Chart of your choice

SolutionInn · Accepted Answer

The Answer is in the image, click to view ...

Question: 6. Management would like to know - what is the split in terms of profit, across the Product Categories, for each quarter. Use a Line

Step by Step Solution

Students Have Also Explored These Related General Management Questions!