6. Apply Light Yellow, Pivot Style Medium 12 to the PivotTable to coordinate with the table on the Customer Call Log worksheet. Center the data in the range B4:K10 to make it easier to read. 7. Tiana notices that Service Rep Bruno has no calls in the How to category, which she knows is incorrect. Return to the Customer Call Log worksheet, and then change the Call Code in cell D10 to 12, which assigns a call to Bruno in the How to category. Go to the Call Type by Rep worksheet and refresh the data in the PivotTable. 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. P52 x v fx B A D E F G ) KL M N O Pierce Software 2 Customer Call Log: January-March 3 Quest 1 Customer Survey Scores Questi Quest Quest 2 31 41 1 Call Cod 7 1 17 16 21 1 5 5 4 5 3 5 5 4 4 Rep Barry Bruno Calder Dareg Shanahan Thanh Volmann Wagner Zimmerman Total Calls Average Score 20 3.65 20 3.35 15 3.60 13 3.71 12 3.25 26 3.41 9 3.89 7 3.04 12 3.46 2 3 5 3 4 3 3 3 1 2 3 3 3 4 4 2 1 2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 5 3 5 5 2 1 18 7 1 1 2 8 25 9 3 2 12 21 20 22 16 19 3 17 18 16 4 4 15 5 22 3 3 4 5 3 20191 20154 21170 21145 22103 22246 22137 22234 23228 23215 24117 24140 25224 23126 25210 20189 20126 26157 25201 26149 23223 24241 24152 24196 26242 27143 20155 21171 22227 20177 27196 22213 25200 28144 28147 29215 26128 29136 29182 24126 27147 28117 21178 26242 30119 30194 21223 24132 25 26 4 2 5 4 4 4 3 2 3 4 5 3 4 5 3 1 3 2 4 5 5 4 5 4 4 4 5 2 1 1 3 4 5 4 5 4 3 4 4 3 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Dal Service Rel 1/4/21 Wagner 1/4/21 Thanh 1/4/21 Darego 1/5/21 Calder 1/5/21 Shanahan 1/6/21 Bruno 17/21 Thanh 1/7/21 Shanahan 1/7/21 Wagner 1/8/21 Calder 1/9/21 Darego 1/9/21 Bruno 1/11/21 Thanh 1/12/21 Volmann 1/12/21 Barry 1/14/21 Wagner 1/14/21 Shanahan 1/15/21 Bruno 1/16/21 Thanh 1/16/21 Calder 1/16/21 Calder 1/16/21 Bruno 1/10/21 The h 1/17/21 Volmann 1/17/21 Darego 1/17/21 Volmann 1/18/21 Barry 1/18/21 Thenh 1/18/21 Shanahan 1/20/21 Bruno 1/20/21 Zimmerman 1/20/21 Volmann 1/21/21 Barry 1/22/21 Calder 1/22/21 Zimmerman 1/3/21 Thanh 1/23/21 Bruno 1/24/21 Darego 1/25/21 Ammerman 1/26/21 Bruno 1/27/21 Barry 1/28/21 Volmann 1/28/21 Thanh 1/29/21 Calder 1/29/21 Thanh 1/29/21 Barry 1/30/21 Zmmerman 1/30/21 Shanahan 1/31/21 Barry 1/31/21 Thanh . 2/4/21 Barry 2/1/21 Calder 2/4/21 Zmmerman 2/5/21 Thanh 2/5/21 Bruno 2/6/21 Darego 2/7/21 Zmmerman 2/7/21 Bruno 2/7/21 Barry 2/8/21 Calder 2/9/21 Darego 2/9/21 Bruno 22/21 The 4 3 2 3 5 3 2 3 4 Call Typ Feature request Bug report Tech problem Tech problem Cancellation Tech problem Feature request Bug report Bug report Feature request Cancellation Feature request Bug report Bug report How to Cancellation Tech problem Cancellation Tech problem Tech problem Bug report Tech problem Tech problem Tech problem Bug report Bug report How to Bug report Cancellation Tech problem How to Cancellation Tech problem Feature request Bug report Tech problem Bug report Tech problem Tech problem Tech problem Feature request How to Tech problem Bug report Cancellation Cancellation How to Feature request How to Tech problem Feature request Bug report Bug report Feature request Cancellation Feature request Bug report Bug report How to Cancellation Tech problem Cancellation Tech problem 3 1 1 2 2 5 2 4 5 1 1 2 2 4 5 5 2 5 5 4 3 5 2 1 3 4 4 5 4 5 4 5 4 3 4 2 3 5 5 3 4 3 2 3 3 3 2 3 3 3 4 5 2 Averag 3.75 1.75 5.00 4.25 4,00 4.00 3.00 1.25 2.00 3.00 4.50 2.75 4.25 4.75 2.00 1.00 3.25 2.25 3.50 4.75 5.00 3.00 4.50 3.75 3.00 3.25 4.50 2.50 1.50 3.00 3.75 4,50 4.50 3.50 4.50 3.75 4.75 4.00 2.50 2.00 4.75 4.50 3.25 2.50 1.00 4.25 4.50 4.50 4.00 3.50 2.75 3.28 2.75 4.50 4.50 3.75 3.50 3.50 3.25 3.00 3.00 3.25 4.50 5 4 3 4 4 4 2 5 4 5 4 2 3 5 5 3 2 2 5 44 -45 46 -17 18 1 4 4 3 4 4 3 2 1 1 15 23 16 6 3 17 5 16 17 20 10 11 16 5 25 21 13 8 14 20 7 1 2 8 25 9 3 2 12 21 20 22 16 4 50 31 1 5 5 3 4 4 1 3 S 5 4 53 30171 3 2. 4 2 5 5 3 3 1 5 5 5 4 4 4 3 3 1 5 5 3 4 4 1 3 4 23161 23162 23163 23170 24165 24166 24167 24168 55 56 57 58 59 60 61 62 63 5 3 5 4 3 3 4 3 1 5 5 4 4 4 4 5 4 5 4 3 4 4 4 3 24169 2 3 5 3 24170 24171 24172 24173 24174 2 3 65 66 67 3 2 2 3 5 4. P 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 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 23 24 25 26 27 B C D F G H I J Parce software 1 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 6. Apply Light Yellow, Pivot Style Medium 12 to the PivotTable to coordinate with the table on the Customer Call Log worksheet. Center the data in the range B4:K10 to make it easier to read. 7. Tiana notices that Service Rep Bruno has no calls in the How to category, which she knows is incorrect. Return to the Customer Call Log worksheet, and then change the Call Code in cell D10 to 12, which assigns a call to Bruno in the How to category. Go to the Call Type by Rep worksheet and refresh the data in the PivotTable. 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. P52 x v fx B A D E F G ) KL M N O Pierce Software 2 Customer Call Log: January-March 3 Quest 1 Customer Survey Scores Questi Quest Quest 2 31 41 1 Call Cod 7 1 17 16 21 1 5 5 4 5 3 5 5 4 4 Rep Barry Bruno Calder Dareg Shanahan Thanh Volmann Wagner Zimmerman Total Calls Average Score 20 3.65 20 3.35 15 3.60 13 3.71 12 3.25 26 3.41 9 3.89 7 3.04 12 3.46 2 3 5 3 4 3 3 3 1 2 3 3 3 4 4 2 1 2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 5 3 5 5 2 1 18 7 1 1 2 8 25 9 3 2 12 21 20 22 16 19 3 17 18 16 4 4 15 5 22 3 3 4 5 3 20191 20154 21170 21145 22103 22246 22137 22234 23228 23215 24117 24140 25224 23126 25210 20189 20126 26157 25201 26149 23223 24241 24152 24196 26242 27143 20155 21171 22227 20177 27196 22213 25200 28144 28147 29215 26128 29136 29182 24126 27147 28117 21178 26242 30119 30194 21223 24132 25 26 4 2 5 4 4 4 3 2 3 4 5 3 4 5 3 1 3 2 4 5 5 4 5 4 4 4 5 2 1 1 3 4 5 4 5 4 3 4 4 3 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Dal Service Rel 1/4/21 Wagner 1/4/21 Thanh 1/4/21 Darego 1/5/21 Calder 1/5/21 Shanahan 1/6/21 Bruno 17/21 Thanh 1/7/21 Shanahan 1/7/21 Wagner 1/8/21 Calder 1/9/21 Darego 1/9/21 Bruno 1/11/21 Thanh 1/12/21 Volmann 1/12/21 Barry 1/14/21 Wagner 1/14/21 Shanahan 1/15/21 Bruno 1/16/21 Thanh 1/16/21 Calder 1/16/21 Calder 1/16/21 Bruno 1/10/21 The h 1/17/21 Volmann 1/17/21 Darego 1/17/21 Volmann 1/18/21 Barry 1/18/21 Thenh 1/18/21 Shanahan 1/20/21 Bruno 1/20/21 Zimmerman 1/20/21 Volmann 1/21/21 Barry 1/22/21 Calder 1/22/21 Zimmerman 1/3/21 Thanh 1/23/21 Bruno 1/24/21 Darego 1/25/21 Ammerman 1/26/21 Bruno 1/27/21 Barry 1/28/21 Volmann 1/28/21 Thanh 1/29/21 Calder 1/29/21 Thanh 1/29/21 Barry 1/30/21 Zmmerman 1/30/21 Shanahan 1/31/21 Barry 1/31/21 Thanh . 2/4/21 Barry 2/1/21 Calder 2/4/21 Zmmerman 2/5/21 Thanh 2/5/21 Bruno 2/6/21 Darego 2/7/21 Zmmerman 2/7/21 Bruno 2/7/21 Barry 2/8/21 Calder 2/9/21 Darego 2/9/21 Bruno 22/21 The 4 3 2 3 5 3 2 3 4 Call Typ Feature request Bug report Tech problem Tech problem Cancellation Tech problem Feature request Bug report Bug report Feature request Cancellation Feature request Bug report Bug report How to Cancellation Tech problem Cancellation Tech problem Tech problem Bug report Tech problem Tech problem Tech problem Bug report Bug report How to Bug report Cancellation Tech problem How to Cancellation Tech problem Feature request Bug report Tech problem Bug report Tech problem Tech problem Tech problem Feature request How to Tech problem Bug report Cancellation Cancellation How to Feature request How to Tech problem Feature request Bug report Bug report Feature request Cancellation Feature request Bug report Bug report How to Cancellation Tech problem Cancellation Tech problem 3 1 1 2 2 5 2 4 5 1 1 2 2 4 5 5 2 5 5 4 3 5 2 1 3 4 4 5 4 5 4 5 4 3 4 2 3 5 5 3 4 3 2 3 3 3 2 3 3 3 4 5 2 Averag 3.75 1.75 5.00 4.25 4,00 4.00 3.00 1.25 2.00 3.00 4.50 2.75 4.25 4.75 2.00 1.00 3.25 2.25 3.50 4.75 5.00 3.00 4.50 3.75 3.00 3.25 4.50 2.50 1.50 3.00 3.75 4,50 4.50 3.50 4.50 3.75 4.75 4.00 2.50 2.00 4.75 4.50 3.25 2.50 1.00 4.25 4.50 4.50 4.00 3.50 2.75 3.28 2.75 4.50 4.50 3.75 3.50 3.50 3.25 3.00 3.00 3.25 4.50 5 4 3 4 4 4 2 5 4 5 4 2 3 5 5 3 2 2 5 44 -45 46 -17 18 1 4 4 3 4 4 3 2 1 1 15 23 16 6 3 17 5 16 17 20 10 11 16 5 25 21 13 8 14 20 7 1 2 8 25 9 3 2 12 21 20 22 16 4 50 31 1 5 5 3 4 4 1 3 S 5 4 53 30171 3 2. 4 2 5 5 3 3 1 5 5 5 4 4 4 3 3 1 5 5 3 4 4 1 3 4 23161 23162 23163 23170 24165 24166 24167 24168 55 56 57 58 59 60 61 62 63 5 3 5 4 3 3 4 3 1 5 5 4 4 4 4 5 4 5 4 3 4 4 4 3 24169 2 3 5 3 24170 24171 24172 24173 24174 2 3 65 66 67 3 2 2 3 5 4. P 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 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 23 24 25 26 27 B C D F G H I J Parce software 1 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