already did step 1 just the rest please

In Steps 1 thru 5. create a new Divot table that shows the answer to the question Label each worksheet with the Step number. Failure to do this will lose lots of points Modily formatting and be as you see fit to make your tables attractive, easy to read and informative . Step 1. How many SERs are supported by each of the Primary Support Locations? Create a Pie chart of the table and include Data Labels on the pie chart Step 2 - How many SERs were logged in each quarter of each year, by complexity? Step 3. What is the average Estimated Effort by Application include a filter by Primary Support Location Show the results to one decimal place Step 4 - Display a count of the number of SERs by Status by Owner Step 5 - What are the maximum, minimum and average Estimated Mort by RequestType? Show the results to one decimal place, and sort them in descending order. Add a Slicer on BusinessArea. Create a column chat from your filtered results. Formatit nicely Step 8. Move the charts from Step 1 and Steps to a new worksheet. Namchis worksheets board Remove gridlines, headers and the formula bar, Label the charts appropriately and format the sheet to be attractive and easy to read Again, be sure to name the worksheets with the Step numbers and 'Dashboardy have to sit and try to figure out which sheet is for which step, probably just mark it wrong and move on mac EUR . WA WWW apie WE wal TAS AU LA w www . WE LINE AL - M WS A w IM We WE RE IN LORE de ER ME WOTE ME med THE TUT - 1 ON he STR datasheet ht SER Complexity Low Medium Medium alidated Appliation O o 0 o o 40 0 es lo NO Pes No ho No res N GSS Cost Centre Purchase Order No. 8550 AZ241233 8562 A2157627 3562 AZ157627 8550 A2241233 8550 AZ241233 8550 ASM to provide 8550 AZ241233 8550 AZ243825 8550 AZ241233 8550 AZ241233 8550 AZ241233 8550 ASM to provide 8SSD AZ 243825 8550 AZ333813 BS50 AZ241233 8550 N2241233 8550 ASM to provide 8550 AZ 241233 8SSO A2243825 8550 AZ243825 8550 AZ243825 8550 A2241233 8550 A2241233 8550 A2243825 BS50 A2 243825 8550 AZ241233 8550 AZ 243825 8550 AZ 241233 3550 A2241233 8550 A2241233 8550 AZ241233 8550 ASM to provide 8550 ASM to provide 8550 ASM to provide 3550 A2241233 Owner Pete Best Pete Best Pete Best Pete Best Pete Best Peter Best Peter Best Paul Seymour Russell Parkin Lasse Blomqvist Lasse Blomqvist Lasse Blomqvist Paul Seymour Russell Parkin Christine Galler Darryl Draper Asa Cordes Lasse Blomqvist Peter Annamatz Rita White Rita White Russell Parkin Asa Cordes Peter Annamatz Peter Annamat: Lasse Blomqvist Paul Seymour Darry Draper Darry Draper Darryl Draper Darryl Draper Lasse Blomqvist Lasse Blomqvist Darryl Draper Chris Corbishley Estimated Effort Primary Support location 2.88 India 1.33 Sweden 2 USA 12 Sweden 19.5 Sweden 5.75 Sweden 3.96 India 20 Sweden 8.75 Sweden 1.88 Sweden 10 Sweden 4.25 Sweden 26 USA India 8 Sweden 6.5 USA 5.5 USA 5.5 Sweden 29 Sweden USA 35 Sweden 3.37 Sweden Sweden 24 India 25 Indu 10.25 Sweden 9 Sweden 1.95 Sweden 1.56 India 4.53 Indu 6.5 Sweden 8.9 Sweden 17.9 Sweden 7 Sweden USA High Medium Low High Medium Low High Medium Medium High Medium Low Low Medium High Medium High Medium Medium High Low Medium Medium Low Low Low Low Medium Medium Low Low No Yes Yes No Yes Yes No Yes Yes No Yes No No NO Na Yes In Steps 1 thru 5. create a new Divot table that shows the answer to the question Label each worksheet with the Step number. Failure to do this will lose lots of points Modily formatting and be as you see fit to make your tables attractive, easy to read and informative . Step 1. How many SERs are supported by each of the Primary Support Locations? Create a Pie chart of the table and include Data Labels on the pie chart Step 2 - How many SERs were logged in each quarter of each year, by complexity? Step 3. What is the average Estimated Effort by Application include a filter by Primary Support Location Show the results to one decimal place Step 4 - Display a count of the number of SERs by Status by Owner Step 5 - What are the maximum, minimum and average Estimated Mort by RequestType? Show the results to one decimal place, and sort them in descending order. Add a Slicer on BusinessArea. Create a column chat from your filtered results. Formatit nicely Step 8. Move the charts from Step 1 and Steps to a new worksheet. Namchis worksheets board Remove gridlines, headers and the formula bar, Label the charts appropriately and format the sheet to be attractive and easy to read Again, be sure to name the worksheets with the Step numbers and 'Dashboardy have to sit and try to figure out which sheet is for which step, probably just mark it wrong and move on mac EUR . WA WWW apie WE wal TAS AU LA w www . WE LINE AL - M WS A w IM We WE RE IN LORE de ER ME WOTE ME med THE TUT - 1 ON he STR datasheet ht SER Complexity Low Medium Medium alidated Appliation O o 0 o o 40 0 es lo NO Pes No ho No res N GSS Cost Centre Purchase Order No. 8550 AZ241233 8562 A2157627 3562 AZ157627 8550 A2241233 8550 AZ241233 8550 ASM to provide 8550 AZ241233 8550 AZ243825 8550 AZ241233 8550 AZ241233 8550 AZ241233 8550 ASM to provide 8SSD AZ 243825 8550 AZ333813 BS50 AZ241233 8550 N2241233 8550 ASM to provide 8550 AZ 241233 8SSO A2243825 8550 AZ243825 8550 AZ243825 8550 A2241233 8550 A2241233 8550 A2243825 BS50 A2 243825 8550 AZ241233 8550 AZ 243825 8550 AZ 241233 3550 A2241233 8550 A2241233 8550 AZ241233 8550 ASM to provide 8550 ASM to provide 8550 ASM to provide 3550 A2241233 Owner Pete Best Pete Best Pete Best Pete Best Pete Best Peter Best Peter Best Paul Seymour Russell Parkin Lasse Blomqvist Lasse Blomqvist Lasse Blomqvist Paul Seymour Russell Parkin Christine Galler Darryl Draper Asa Cordes Lasse Blomqvist Peter Annamatz Rita White Rita White Russell Parkin Asa Cordes Peter Annamatz Peter Annamat: Lasse Blomqvist Paul Seymour Darry Draper Darry Draper Darryl Draper Darryl Draper Lasse Blomqvist Lasse Blomqvist Darryl Draper Chris Corbishley Estimated Effort Primary Support location 2.88 India 1.33 Sweden 2 USA 12 Sweden 19.5 Sweden 5.75 Sweden 3.96 India 20 Sweden 8.75 Sweden 1.88 Sweden 10 Sweden 4.25 Sweden 26 USA India 8 Sweden 6.5 USA 5.5 USA 5.5 Sweden 29 Sweden USA 35 Sweden 3.37 Sweden Sweden 24 India 25 Indu 10.25 Sweden 9 Sweden 1.95 Sweden 1.56 India 4.53 Indu 6.5 Sweden 8.9 Sweden 17.9 Sweden 7 Sweden USA High Medium Low High Medium Low High Medium Medium High Medium Low Low Medium High Medium High Medium Medium High Low Medium Medium Low Low Low Low Medium Medium Low Low No Yes Yes No Yes Yes No Yes Yes No Yes No No NO Na Yes