need help with question 5 and 7
5. a. Brittany wants to identify employees who are eligible to take a CPR course at the clubs expense. Employees who can work as camp counselors are eligible for the course. In cell M3, enter a formula using a nested IF function and structured references as follows to determine first if an employee has already been trained in CPR, and if not, whether that employee meets the qualifications to take the course: If the value in the CPR Trained column is equal to the text "Yes", the formula should display Trained as the text. b. Otherwise, the formula should determine if the value in the Camp Counselor column is equal to the text "Yes" and return the text Yes if true and No if false. Fill the formula into the range M4:M32] if necessary. Employees who work at the swim clubs are also considered for employment at the Breve County Parks and Recreation Department. Employees with more than four years of experience are qualified for more complex Level 2 jobs. In cell N2, enter the text Level as the column heading. In cell N3, enter a formula using the IF function and structured references as follows to determine which employment level Tiffany Adams is qualified for: The IF function should determine if the employee's Years of experience is greater than or equal to 4, and return the value 2 if true or the value 1 if false. CR 7. a OR X Year of Experience Cert. Year 2018 2023 2023 2012 2015 Camp Counselor yen no na 3018 1 2 Employee ID Name 31913 Tiffany Adams 4B534 Hassan Bachim 5 B60 Megan Beckman 6 Cae Catherine Coleman 7 F734 Carrie Tuliner CORO Paul Gomes 0 0875 Buyant Grossburg 10 808 Marilyn Jesberger 11 1869 Jonathan Lampert 12 MB Gina Milota 13 Nasa Jet News 14 0943 Crystal Olneck 15 P400 Yolanda Padilla 10 1492 Michael Pankowski Keith Pienkowiki 18 0567 James Quinlan 19 0752 Ryan Duinian 20 5630 Andse Shelby 21 7598 Anna Tran 22 USB Tracy tlphod 33 V188 Javier Vanques tal Documentation An Employees Age 23 19 19 22 24 24 16 21 35 21 21 83 18 35 yes yos no yes yes Pay Rate 15 30 15.75 15.75 16.00 16.30 10.50 15.50 16.00 10.50 1600 18.00 16 50 15.30 16.30 16.50 18.00 16.00 17.50 18.00 16.30 19.50 0 3 5 3 3 3 0 7 0 4 2 2003 3019 2013 2030 20:30 2018 CPR Trained - Elfeguard Instructor Yes Yes INo Yes No No Yen No You Yes No Yes Yes No Na No No No No No Yes Yes Yos Yes No NO No No No Yos No No No No No Yos Yos Yes Yes Yes No Yos No Yes Yes No Yes Yes Yes No No No Yes Yes No No No No ye ho yes 24 20 20 19 23 18 2017 2018 2000 1000 2017 soal 2017 maa no Yes no B 2 3 0 mo Met Team Mb T - Team Coach no CPR Course id Columul Employee ID Employee Name VIBU Javier Vaque gibility Swim Team yes no yes yes yes yes no yes yos RD DD no yos 2 3 4 5 6 7 B 9 10 11 12 13 14 15 16 17 18 Total Employees Average Years of operience Lifewards All Employees es yos no yos no yes no yos yos yes no Years of Experience Pay Rate SIS 0 $15.78 $16.00 518 30 512.50 TO yos yos 20 al you yes yos yes no no yes no Documentation All employees Melbourne Melbourne
