im in need of help with excel. i have provided the excel worksheets. please show steps. thank you

9. Go to the Scores by Date worksheet. In cell A3, insert another PivotTable based on the Calls table. Use Scores as the name of the Pivottable. Display the Date values as column headings, which automatically groups the data by month. Display the Service Rep names as row headings and the Average score data as values. 10. Change the summary function to Average for the data in the Values area and apply the Number number format with 2 decimal places to those values. 11. In cell A3, use the text Average Scores to identify the values. In cell B3, use the text Months to identify the column headings. In cell A5, use the text Service Reps to identify the row headings. Apply Light Yellow, Pivot Style Medium 12 to the PivotTable to match the other PivotTable. 12. Tiana wants to focus on scores for calls involving technical problems in February. Create a slicer for the Scores PivotTable based on the Call Type field. Resize the slicer to a height of 2.5". Move the slicer so its upper-left corner is in cell F3 and its lower-right corner is in cell G14. Use the slicer to filter the Scores PivotTable by the Tech problem call type. 13. Create a timeline slicer based on the Date field in the Scores PivotTable. Resize the timeline slicer to a width of 7". Move the slicer so that its upper-left corner appears within cell A16 and its lower-right corner appears in cell G23. Use the timeline slicer to show data for February only. 14. Resize columns B:C to 12.00 and center the data in the range B3:C15. Pierce Software Customer Call Log: January-March Ques Gall Typ 7 8 9 Total Calls 20 20 15 13 12 26 9 7 12 Average Score 3.65 3.35 3.60 3.71 3.25 3.41 3.99 3.04 3.46 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 29 30 31 33 34 35 Call Dat Service Re 20191 1/4/21 Wagner 20154 1/4/21 Thanh 21170 1/4/21 Darego 21145 1/5/21 Calder 22103 1/5/21 Shanahan 22246 1/6/21 Bruno 22137 VP2: Thanh 22234 1/7/21 Shanahan 23228 1/7/21 Wagner 23215 1/8/21 Calder 24117 1/9/21 Darego 24140 1/9/21 Bruno 25224 1/11/21 Thanh 23126 1/12/21 Volmann 25210 1/12/21 Barry 20189 1/14/21 Wagner 20126 1/14/21 Shanahan 26157 1/15/21 Bruno 25201 1/16/21 The 26149 1/16/21 Calder 23223 1/16/21 Calder 24241 1/16/21 Bruno 24152 1/12/2: They h 24196 1/17/21 Volmann 26242 1/17/21 Daredo 27143 1/17/21 Volmann 20155 1/18/21 Barry 21171 1/18/2 Thanh 22227 1/18/21 Shanahan 20177 1/20/21 Bruno 27196 1/20/21 Zmmerman 22213 1/20/21 Volmann 25200 1/21/21 Barry 28144 1/22/21 Calder 28147 1/22/21 Zmmerman 29215 1/3/21 Thanh 26128 1/23/21 Bruno 29136 1/24/21 Darego 29182 1/25/21 Zimmerman 24126 1/26/21 Bruno 27147 1/27/21 Barry 28117 1/28/21 Volmann 21178 1/28/21 Thanh 26242 1/29/21 Calder 30119 1/29/21 Thanh 30194 1/29/21 Barry 21223 1/30/21 Zmmerman 24132 1/30/21 Shanahan 30171 1/31/21 Barry 23161 1/31/21 Thanh 23162 2/4/21 Barry 23163 2/4/21 Calder 23170 2/4/21 Zimmerman 24165 2/5/21 Thanh 24166 2/5/21 Bruno 24167 2/6/21 Darego 24168 2/7/21 Zimmerman 24169 2/7/21 Bruno 24170 2/7/21 Barry 24171 2/8/21 Calder 24172 2/9/21 Daredo 24173 2/9/21 Bruno 24174 22/12/2: The Customer Call Log 36 37 Quest Call Codi 1 7 Feature request 4 1 Bug report 2 17 Tech problem 5 16 Tech problem 4 21 Cancellation 4 18 Tech problem 4 7 Feature request 3 1 Bug report 2 2 Bug report 3 Feature request 4 25 Cancellation 5 9 Feature request 3 Bug report 4 2 Bug report 5 12 How to 3 21 Cancellation 1 20 Tech problem 3 22 Cancellation 2 16 Tech problem 4 19 Tech problem 5 3 Bug report 5 17 Tech problem 4 18 Tech problem 5 Tech problem 4 Bug report 4 4 Bug report 4 15 How to 5 5 Bug report 2 22 Cancellation 1 18 Tech problem 3 15 How to 4 23 Cancellation 5 Tech problem 4 6 Feature request S 3 Bug report 4 17 Tech problem 3 5 Bug report 4 16 Tech problem 4 17 Tech problem 3 20 Tech problem 2 10 Feature request 5 11 How to 4 16 Tech problem 4 5 Bug report 3 25 Cancellation 1 21 Cancellation 5 13 How to 5 8 Feature request 3 14 How to 4 20 Tech problem 4 Feature request 1 1 Bug report 3 Bug report Feature request 5 25 Cancellation 4 9 Feature request 5 3 Bug report 4 2 Bug report 3 12 How to 4 21 Cancellation 4 20 Tech problem 22 Cancellation 2 16 Tech sroblem Call Type by Rep Customer Survey Scores Quest Quest Averag Rep 5 2 4 3.75 Barry 1 3 1 1.75 Bruno 5 5 5.00 Calder 5 3 5 4.25 Darego 4 4.00 Shanahan 5 4 4,00 Thanh 3 3 3 3.00 Volmann 1 1 1 1.25 Wagner 2 2 1 2.00 Zimmerman 3 3 2 3.00 5 4.50 2 2.75 4 4.25 5 4 5 4.75 2 2. 1 2.00 1 1 1 1.00 4 2 3.25 3 2 2 2.25 3 4 3.50 5 5 4.75 5 5.00 3 2 3.00 4 5 450 3 3 3.75 2 3.00 3 3 3.25 5 3 5 4.50 3 3 2 2.50 2 1 1.50 3 3 3 3.00 4 3 4 3.75 5 4 4 4.50 4 5 5 4.50 3 2 4 3.50 4 5 5 4.50 4 4 3.75 5 5 4.75 4 4 4 4.00 2 Z 3 2.50 3 2 2.00 4 5 5 4.75 5 5 4.50 3 3.25 2 2 3 2.50 1 1 1 1.00 3 5 4.25 5 3 4.50 5 5 5 4.50 4 4.00 4 3.50 4 2.75 3 3 3.25 1 1 2.75 5 5 4.50 5 5 4.50 3 3 3.75 3.50 4 4 3.50 3 1 3.25 3 3.00 3.00 4 3.25 4.50 Scores by Date Survey Questions 39 41 42 45 47 48 . 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 + Y Analysis Tools V V Get External Data Stocks Geogra... ZI Sort Filter Refresh All Outline Text to F S Columns ] What-If Analysis E20 fx A B D E F G H I ) > Pierce Software 2 Call Types by Service Rep 3 Count of Service Rep Column Labels 4 Row Labels Barry Bruno Calder Darego Shanahan Thanh Voimann Wagner Zimmerman Grand Tot 5 Bug report 5 5 4 4 1 7 2 1 6 35 6 Cancellation 3 4 3 1 3 2 2. 2 20 7 Feature request 3 3 2 1 1 5 1 16 8 How to 6 1 1 1 2. 2. 3 16 9 Tech problem 3 8 5 6 6 10 3 3 8 52 10 Grand Total 20 20 15 13 12 26 9 7 17 139 11 Pierce Software 2 Call Types by Service Rep 3 Count of Service Rep Column Labels 4 Row Labels Barry Bruno Calder Darego Shanahan Thanh Volmann Wagner Zimmerman Grand Tot 5 Bug report 5 5 4 4 1 7 2 1 6 35 6 Cancellation 3 4 3 1 3 2 2 2 20 7 Feature request 3 3 2 1 1 5 1 16 8 How to 6 1 1 1 2 2 3 16 9 Tech problem 3 8 5 6 6 10 3 3 8 52 10 Grand Total 20 20 15 13 12 26 9 7 17 139 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Customer Call Log Call Type by Rep Scores by Date Survey Questions + Data All 1 Columns Analysis fx A B C D E F G H I K L 1 Pierce Software 2 Average Monthly Scores 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 27 4 3 4 4 3 3 5 2 4 4 4 3 3 2. 3 3 3 5 5 2 3 1 12 2. 3 4 5 2 1 3 4 4 3 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 3 5 5 4 5 4 3 4 5 4 4 3 5 2 5 4 5 4 GJEJ 4 24241 1/16/21 Bruno 24152 1/17/21 Thanh 24196 1/17/21 Volmann 26242 1/17/21 Darego 27143 1/17/21 Volmann 20155 1/18/21 Barry 21171 1/18/2 Thanh 22227 1/18/21 Shanahan 20177 1/20/21 Bruno 27196 1/20/21 Zimmerman 22213 1/20/21 Volmann 25200 1/21/21 Barry 28144 1/22/21 Calder 28147 1/22/21 Zimmerman 29215 1/23/2i Thanh 26128 1/23/21 Bruno 29136 1/24/21 Darego 29182 1/25/21 Zimmerman 24126 1/26/21 Bruno 27147 1/27/21 Barry 28117 1/28/21 Volmann 21178 1/28/21 Thanh 26242 1/29/21 Calder 30119 1/29/21 Thanh 30194 1/29/21 Barry 21222 1/30/21 Zimmerman 24132 1/30/21 Shanahan 30171 1/31/21 Barry 23161 1/31/2i Thanh 23162 2/4/21 Barry Customer Call Log 4 17 18 16 4 4 15 5 22 18 15 23 16 6 3 17 5 16 17 20 10 11 16 5 25 21 13 8 14 20 7 4 4 2 4 2. 3 1 2. 5 4 5 4 3 2 5 5 3 3 47 4 4 3 2 3 3 1 5 5 2 1 4 3 3 48 49 50 51 52 53 54 55 3 5 5 4 5 4 3 5 5 5 4 4 4 3 Call Type by Rep Scores by Date Survey Questions Home insert Draw Page Layout Formulas Data Review View Tell me fx IA Define Name Text Insert Function AutoSum Recently Financial Logical Used Date & Lookup & Math & Time Reference Trig More Functions EO Create from Selection G1 A B C D E F G H I ) 16 Tech problem 21 Cancellation Pierce Software 2 Call Type Lookup Table 3 Call Code 0 6 11 4 Call Type Bug report Feature request How to 5 6 Customer Survey Scores 5 Very satisfied 8 4 Satisfied 9 3 Neutral 10 2 Dissatisfied 11 1 Very dissatisfied 12 13 Customer Survey Questions 14 How satisfied are you with: 15 Question 1 The service rep's product knowledge 16 Question 2 How much time it took to reach a service rep 17 Question 3 The overall process of contacting Pierce Software 18 Question 4 How the service rep handled your call 19 20 21 22 37 38 45 46 47 48 49 50. Customer Call Log Call Type by Rep Scores by Date Survey Questions + 1 16 Tech problem 21 Cancellation Pierce Software 2 Call Type Lookup Table 3 Call Code 0 6 11 4 Call Type Bug report Feature request How to 5 6 Customer Survey Scores 7 5 Very satisfied 8 4 Satisfied 9 3 Neutral 10 2 Dissatisfied 11 1 Very dissatisfied 12 13 Customer Survey Questions 14 How satisfied are you with: 15 Question 1 The service rep's product knowledge 16 Question 2 How much time it took to reach a service rep 17 Question 3 The overall process of contacting Pierce Software 18 Question 4 How the service rep handled your call 19 20 21 23 24 25 26