1. Brittany Lambert is a volunteer for the Brevard County Swim Clubs in Melbourne, Florida, and has offered to compile data on the swim club employees and teams. She needs your help completing the workbook and analyzing the data. Switch to the All Employees worksheet. In cell E3, enter a formula using the HLOOKUP function as follows to determine an employee's potential pay rate, which is based on their years of experience: a. b. Use a structured reference to look up the value in the Years of Experience column. Retrieve the value in row 2 of the table in the range P14:U15, using an absolute reference. Because hourly pay rate is tiered based on the number of years of experience, find an approximate match. Fill the formula into the range E4:E32, if necessary. 33 Employee ID 3 A313 4 8534 5 8681 6 CB36 7 1724 8 0629 9 G875 10 1608 11 1869 12 M893 23 N352) 14 0943 15 P408 6 P492 17 P633 8 0967 0752 20 $639 17598 12 188 13 V188 24V420 5 V735 E W209 Function be Name Tiffany Adams Hassan Bachim Megan Beckman Catherine Coleman Carrie Faulkner Paul Gomez Bryant Grossburg Marilyn Jesberger Jonathan Lampert Gina Milota Jeff Newman Crystal Olneck Yolanda Padilla Michael Pienkowski Keith Pienkowski James Quinlan Ryan Quinlan Andrea Shelby Anna Tran Tracy Uphoff Javier Vazquez Jose Vasques Alexa Vanderson Dale Wong Documentation Ap C Age 22 19 19 28 24 124 18 21 25 21 31 33 18 25 34 24 20 36 19 inction Manage from Stedine Amateur window Watch Can Ca Optiem Des 23 18 22 18 28 Mebauhe Swen Teame D Years of Experience Pay Rate Cert. Tear CPR Trained 2018 Yes 2022 No 2033 2017 2015 4 16 6 0 3 5 3 3 5 0 7 6 4 2 18 3 15 0 4 0 4 Hebaume PyotTible 2018 2033 2019 2019 2030 2020 2018 2033 2017 2018 2000 3000 2017 G 2021 2017 2003 2018 2023 2018 Al Tea Table Yoo Yes Yes Yes No No Yes Yes No Yes No H Lifeguard You No No No Yes Yes No No Yes No No No No You HE Yes Yes BEAT Yes Yes No Yes Yes No Yes No Yes No Yes No Yes No Yes No No No Yes Instructor Yes No No Yes No No No No Yes No No No No Yos No Yes Yes No Yes No 2222 No Camp Counselor