Need help asap thank you so much! I need help espeically with the structured reference for question 1. If you can help with all three formulas that would be awesome.

from the SAM website. 10 PROJECT STEPS 1. Tiana Morales is the director of the customer call center for Pierce Software. For the past three months, she has been keeping track of the support calls the center receives, and asks for your help in analyzing the data. Go to the Customer Call Log worksheet, which contains the Calls table where Tiana has been entering support call data. In the Call Type column, she needs to list the type of call corresponding to the code in the Call Code column. In cell E5, enter a formula using the HLOOKUP function to look up the call type according to the call code. Use a structured reference to look up the value in the Call Code column of the Calls table. Retrieve the value in row 2 of the CallTypes table (range A3:F4 in the Survey Questions worksheet) using a structured reference to the entire CallTypes table. Because each call type covers a range of values, find an approximate match. Fill the formula into the range E6:E143, if necessary. Customers can rate their service representative by completing a four-question survey at the end of each call. Tiana entered the scores in columns Question 1, Question 2, Question 3, and Question 4 of the Calls table. She wants to calculate the average rating for each call in the Average column. In cell 35, enter a formula using the AVERAGE function and structured references to average the values in the Question 1 to Question 4 columns of the Calls table. Fill the formula into the range J6:J143, if necessary. In the range L4:N13, Tiana set up an area to summarize some data about the service representatives handling the customer support calls. First, she wants to count the number of calls each service representative handled. In cell M5, enter a formula using the COUNTIF function and a structured reference to the Service Rep column in the Calls table to count the number of calls Barry (cell L5) handled. Fill the formula into the range M6:M13 without formatting. 2. 3. T:... -I- LL. ----Lied C...---L -- Icf 100 word M 'T' Gocur AA ana/ File Home Insert Draw Page Layo Formulas Data Review View Help Design O Search . % 5 Conditional Formatting Format as Table Cell Styles Clipboard Font Alignment Number Cells Editing Ideas Sensiti > V Styles Ideas Sensiti E4 fx Call Type V A B D F H 1 j 1 K M N 0 1 Pierce Software 2 Customer Call Log: January-March 3 Customer Survey Scores Ques Ques Ques Ques Averad Call Tyi #N/A Total Calls Average Score 2 3 5 3 4 3 3 4 1 5 5 Rep Barry Bruno Cakler Darego Shanahan Thanh Vomann Wagner Zimmerman SPILLI ASPILL! #SPILL! ! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILLI ASPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! SPILL! #SPILLI #SPILL! #SPILL! 4 3 1 1 2 5 2 1 2 3 3 3 4 4 2. 1 4 2 2 5 1 1 " 5 5 3 4 #SPILL! 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 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 2 4 5 5 2 5 5 4 3 5 2 Call 1 Da Service Re Call Cod 20191 1/4/2021 Wagner 7 20154 1/4/2021 TMarch 1 21170 1/4/2021 Darego 17 21145 1/5/2021 Calder 16 221031/5/2021 Shanahan 21 22246 1/6/2021 Bruno 18 2137 1/7/2021 Thanh 7 7. 22234 1/7/2021 Shanahan 1 23228 1/7/2021 Wagner 2 23215 1/8/2021 Calder 8 24117 1/9/2021 Darego 25 24140 1/9/2021 Bruno 9 9 25224 1/11/2021 Thanh 3 23126 1/12/2021 Volmann 2 25210 1/12/2021 Barry 12 20189 1/14/2021 Wagner 21 20126 1/14/2021 Shanahan 20 26157 1/15/2021 Bruno 22 25201 1/16/2021 Tharihi. 16 261-19 1/16/2021 Caller 19 23223 1/16/2021 Calder 3 3 24241 1/16/2021 Bruno 17 24152 1/17/2021 Tranh 18 24196 1/17/2021 Volmann 16 26242 1/17/2021 Darego 4 27143 1/17/2021 Volmann 4 20155 1/18/2021 Barry 15 21171 1/18/2021 Tarofi 5 5 22227 1/18/2021 Shanahan 22 20177 1/20/2021 Bruno 18 27196 1/20/2021 Zimmerman 15 22213 1/20/2021 Volmann 23 25200 1/21/2021 Barry 16 28144 1/22/2021 Cakler 6. 28147 1/22/2021 Zimmerman 3 29215 1/23/2021 Tharit 17 26128 1/23/2021 Bruno 5 29136 1/24/2021 Darego 16 29182 1/25/2021 Zimmerman 17 24126 1/26/2021 Bruno 20 27147 1/27/2021 Barry 10 28117 1/28/2021 Volmann 11 2118 1/28/2021 Thanh 16 26242 1/29/2021 Calder 5 5 30119 1/29/2021 Thanh 25 30194 1/29/2021 Barry 21 21223 1/30/2021 Zimmerman 13 24132 1/30/2021 Shanahan 8 30171 1/31/2021 Barry 14 23161 1/31/2021 Thanh 20 23162 2/4/2021 Barry 7 23163 2/4/2021 Cakler 1 23170 2/1/2021 Zimmerman 2 24165 2/5/2021 Thanh 8 24166 2/5/2021 Bruno 25 24167 2/6/2021 Darego 9 24168 2/7/2021 Zimmerman 3 24169 2/7/2021 Bruno 2 Documentation 4 2 5 4 4 4 3 3. 2 3 4 5 3 4 5 3 1 3 2 4 5 5 5 4 5 4 4 4 5 2 1 3 3 4 5 4 5 4 3 1 4 3 2 5 4 4 3 1 5 5 3 4 4 1 3 2 1 1 5 4 5 4 5 1 5 5 4 5 5 3 1 2. 3 5 3 5 5 2. 1 4 3 3 4 5 3 4 3 2 2 5 3 2 3 4 5 4 3 4 4 5 4 2. 1 4 4 3 2 1 3 5 5 5 4 3 2. 4 5 3 2. 3 3 3 2 3 3 2 " 3 3 4 4 4 4 #SPILL! #SPILL! #SPILL! #SPILL! ASPILLI 4 SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILLI ASPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILLI ASPILLI #SPILL! #SPILL! ! #SPILL! #SPILL! #SPILL! #SPILL! #SPILLI 4 SPILLI #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL 1 4 4 5 4 2 3 5 5 3 4 5 4 3 2 5 5 " Z F 1 5 5 5 F 1 4 3 5 4 3 4 3 3 1 5 5 4 4 4 4 4 3 3 1 F 3 3 2 Customer Call Log Call 1... + + 50% File Home Insert Draw Page Layout Formulas Data Review View Help Search A % 5 Conditional Formatting Format as Table Cell Styles Clipboard Font Alignment Number Cells Editing Ideas Sensiti Styles Ideas Sensiti G1 3 X fx V B D E F G H 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 25 Scores by Date Survey Questions + from the SAM website. 10 PROJECT STEPS 1. Tiana Morales is the director of the customer call center for Pierce Software. For the past three months, she has been keeping track of the support calls the center receives, and asks for your help in analyzing the data. Go to the Customer Call Log worksheet, which contains the Calls table where Tiana has been entering support call data. In the Call Type column, she needs to list the type of call corresponding to the code in the Call Code column. In cell E5, enter a formula using the HLOOKUP function to look up the call type according to the call code. Use a structured reference to look up the value in the Call Code column of the Calls table. Retrieve the value in row 2 of the CallTypes table (range A3:F4 in the Survey Questions worksheet) using a structured reference to the entire CallTypes table. Because each call type covers a range of values, find an approximate match. Fill the formula into the range E6:E143, if necessary. Customers can rate their service representative by completing a four-question survey at the end of each call. Tiana entered the scores in columns Question 1, Question 2, Question 3, and Question 4 of the Calls table. She wants to calculate the average rating for each call in the Average column. In cell 35, enter a formula using the AVERAGE function and structured references to average the values in the Question 1 to Question 4 columns of the Calls table. Fill the formula into the range J6:J143, if necessary. In the range L4:N13, Tiana set up an area to summarize some data about the service representatives handling the customer support calls. First, she wants to count the number of calls each service representative handled. In cell M5, enter a formula using the COUNTIF function and a structured reference to the Service Rep column in the Calls table to count the number of calls Barry (cell L5) handled. Fill the formula into the range M6:M13 without formatting. 2. 3. T:... -I- LL. ----Lied C...---L -- Icf 100 word M 'T' Gocur AA ana/ File Home Insert Draw Page Layo Formulas Data Review View Help Design O Search . % 5 Conditional Formatting Format as Table Cell Styles Clipboard Font Alignment Number Cells Editing Ideas Sensiti > V Styles Ideas Sensiti E4 fx Call Type V A B D F H 1 j 1 K M N 0 1 Pierce Software 2 Customer Call Log: January-March 3 Customer Survey Scores Ques Ques Ques Ques Averad Call Tyi #N/A Total Calls Average Score 2 3 5 3 4 3 3 4 1 5 5 Rep Barry Bruno Cakler Darego Shanahan Thanh Vomann Wagner Zimmerman SPILLI ASPILL! #SPILL! ! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILLI ASPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! SPILL! #SPILLI #SPILL! #SPILL! 4 3 1 1 2 5 2 1 2 3 3 3 4 4 2. 1 4 2 2 5 1 1 " 5 5 3 4 #SPILL! 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 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 2 4 5 5 2 5 5 4 3 5 2 Call 1 Da Service Re Call Cod 20191 1/4/2021 Wagner 7 20154 1/4/2021 TMarch 1 21170 1/4/2021 Darego 17 21145 1/5/2021 Calder 16 221031/5/2021 Shanahan 21 22246 1/6/2021 Bruno 18 2137 1/7/2021 Thanh 7 7. 22234 1/7/2021 Shanahan 1 23228 1/7/2021 Wagner 2 23215 1/8/2021 Calder 8 24117 1/9/2021 Darego 25 24140 1/9/2021 Bruno 9 9 25224 1/11/2021 Thanh 3 23126 1/12/2021 Volmann 2 25210 1/12/2021 Barry 12 20189 1/14/2021 Wagner 21 20126 1/14/2021 Shanahan 20 26157 1/15/2021 Bruno 22 25201 1/16/2021 Tharihi. 16 261-19 1/16/2021 Caller 19 23223 1/16/2021 Calder 3 3 24241 1/16/2021 Bruno 17 24152 1/17/2021 Tranh 18 24196 1/17/2021 Volmann 16 26242 1/17/2021 Darego 4 27143 1/17/2021 Volmann 4 20155 1/18/2021 Barry 15 21171 1/18/2021 Tarofi 5 5 22227 1/18/2021 Shanahan 22 20177 1/20/2021 Bruno 18 27196 1/20/2021 Zimmerman 15 22213 1/20/2021 Volmann 23 25200 1/21/2021 Barry 16 28144 1/22/2021 Cakler 6. 28147 1/22/2021 Zimmerman 3 29215 1/23/2021 Tharit 17 26128 1/23/2021 Bruno 5 29136 1/24/2021 Darego 16 29182 1/25/2021 Zimmerman 17 24126 1/26/2021 Bruno 20 27147 1/27/2021 Barry 10 28117 1/28/2021 Volmann 11 2118 1/28/2021 Thanh 16 26242 1/29/2021 Calder 5 5 30119 1/29/2021 Thanh 25 30194 1/29/2021 Barry 21 21223 1/30/2021 Zimmerman 13 24132 1/30/2021 Shanahan 8 30171 1/31/2021 Barry 14 23161 1/31/2021 Thanh 20 23162 2/4/2021 Barry 7 23163 2/4/2021 Cakler 1 23170 2/1/2021 Zimmerman 2 24165 2/5/2021 Thanh 8 24166 2/5/2021 Bruno 25 24167 2/6/2021 Darego 9 24168 2/7/2021 Zimmerman 3 24169 2/7/2021 Bruno 2 Documentation 4 2 5 4 4 4 3 3. 2 3 4 5 3 4 5 3 1 3 2 4 5 5 5 4 5 4 4 4 5 2 1 3 3 4 5 4 5 4 3 1 4 3 2 5 4 4 3 1 5 5 3 4 4 1 3 2 1 1 5 4 5 4 5 1 5 5 4 5 5 3 1 2. 3 5 3 5 5 2. 1 4 3 3 4 5 3 4 3 2 2 5 3 2 3 4 5 4 3 4 4 5 4 2. 1 4 4 3 2 1 3 5 5 5 4 3 2. 4 5 3 2. 3 3 3 2 3 3 2 " 3 3 4 4 4 4 #SPILL! #SPILL! #SPILL! #SPILL! ASPILLI 4 SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILLI ASPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILLI ASPILLI #SPILL! #SPILL! ! #SPILL! #SPILL! #SPILL! #SPILL! #SPILLI 4 SPILLI #SPILL! #SPILL! #SPILL! #SPILL! #SPILL! #SPILL 1 4 4 5 4 2 3 5 5 3 4 5 4 3 2 5 5 " Z F 1 5 5 5 F 1 4 3 5 4 3 4 3 3 1 5 5 4 4 4 4 4 3 3 1 F 3 3 2 Customer Call Log Call 1... + + 50% File Home Insert Draw Page Layout Formulas Data Review View Help Search A % 5 Conditional Formatting Format as Table Cell Styles Clipboard Font Alignment Number Cells Editing Ideas Sensiti Styles Ideas Sensiti G1 3 X fx V B D E F G H 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 25 Scores by Date Survey Questions +