4. Experienced students may serve as mentors if they are at least age 21 and have at least 3 years of post-secondary education. In cell L2, enter a formula using the IF and AND functions and structured references as follows to determine if Kay Colbert is eligible to serve as a mentor: a. The IF function should determine if the student's age is greater than or equal to 21 AND the student's post-secondary years are greater than or equal to 3, and should return the text Yes if a student meets both of those criteria or the text No if a student meets none or only one of those criteria. b. Fill the formula into the range L3:L31, if necessary. X Create a formula using a function. In the Student Representatives worksheet, the formula in cell L2 should use a structured reference to the Age value in the logical1 argument of the AND function. X Copy a formula into a range. In the Student Representatives worksheet, cell L2 contains an incorrect formula. L2 A 1 Student ID 2 G62918 3 P49234 4 W99035 5 V42056 6 T59828 7 F72412 8 W20999 9 018870 10 W75774 11 N25220 12 094361 13 G87578 14 B68170 15 M89375 16 S63900 17 Y96036 18 C82505 19 Y75358 20 J60811 21 Q56783 22 Q75281 23 V73596 24 L86947 25 W90960 26 P40886 27 U88627 28 Y88831 29 P83373 30 B53454 31 A60088 32 33 X B Ida Smith Betty Garza Leroy Pirkle Name Kay Colbert Michael Crozier Brandon Miles Michael Alvarez fx =IF(AND(C2>=21,D2>=3),"Yes","No") Warren Stewart Stacy Wiggins Billy Herald Margaret Cruz Chester Keese Claudette Littell Florence Miller Kimberly Gerace Roman Goble Jocelyn Allen Ron Morse Roberta Ervin James Rusnak Suzanne Lawrence ShannonGarner Emory Little Laura Li Floretta Cauthen Beverly Berry Stephanie Papa Wallace Rivera Larry Russell Aaron Sifford C Age Post-Secondary Years 24 25 21 22 19 24 28 18 24 21 23 18 19 21 26 22 22 20 21 19 24 18 25 24 18 23 19 29 D 19 25 6 7 3 4 2 6 10 0 6 E Base Rate 5 0 1 3 8 4 4 2 3 1 2 0 5 6 0 5 1 9 1 7 16.50 16.50 15.75 15.75 15.75 16.50 17.50 15.00 16.50 15.75 16.50 15.00 15.25 15.75 17.50 15.75 15.75 15.75 15.75 15.25 15.75 15.00 16.50 16.50 15.00 16.50 15.25 17.50 15.25 16.50 F G Class Finance Certified 2022 Yes 2023 Yes 2022 Yes 2023 Yes 2024 No 2025 Yes 2022 Yes 2026 No 2025 Yes 2022 No 2023 Yes 2024 No 2026 Yes 2023 Yes 2023 Yes 2025 Yes 2022 Yes 2022 Yes 2026 No 2022 Yes 2025 Yes 2024 No 2023 Yes 2022 Yes 2025 No 2023 Yes 2023 Yes 2023 Yes 2022 No 2023 Yes H Grad Student Yes Yes No No No Yes Yes No Yes No No No No No Yes No No No No No No No Yes Yes No No No Yes No Yes Elected No Yes Yes No Yes No No No Yes No No No No No No No Yes No No Yes Yes No Yes Yes No No Yes No No Yes Qualified Driver YES YES NO NO NO YES YES NO YES NO NO NO NO NO YES NO NO NO NO NO YES NO YES YES NO NO NO YES NO YES K Leadership Training yes yes yes yes yes yes yes no yes yes yes no yes yes yes yes yes yes yes yes yes no yes yes no yes yes yes no yes Mentor Yes Yes Yes Yes No Yes Yes No Yes Yes Yes No No Yes Yes Yes Yes No Yes No No No Yes Yes No Yes No Yes No Yes Formula Bar Officer Qualified Lyes Elected Elected Yes Elected Yes Yes No Elected No Yes No Yes Yes Yes Yes Elected Yes No Elected Elected No Elected Elected No Yes Elected Yes No Elected N Tier 2 2 1 2 1 2 2 1 2 1 2 1 1 1 2 2 2 1 1 1 1 1 2 2 1 2 1 2 1 2 O Student ID Student Name P Elected Students All Students Postsecondary Years Base Rate Q G62918 Kay Colbert Total Students 11 30 0 15 R Average Post-Secondary Years 4 3.8 1 15.25 S 2 15.75 T 5 16.5 U 8 17.5 V 4. Experienced students may serve as mentors if they are at least age 21 and have at least 3 years of post-secondary education. In cell L2, enter a formula using the IF and AND functions and structured references as follows to determine if Kay Colbert is eligible to serve as a mentor: a. The IF function should determine if the student's age is greater than or equal to 21 AND the student's post-secondary years are greater than or equal to 3, and should return the text Yes if a student meets both of those criteria or the text No if a student meets none or only one of those criteria. b. Fill the formula into the range L3:L31, if necessary. X Create a formula using a function. In the Student Representatives worksheet, the formula in cell L2 should use a structured reference to the Age value in the logical1 argument of the AND function. X Copy a formula into a range. In the Student Representatives worksheet, cell L2 contains an incorrect formula. L2 A 1 Student ID 2 G62918 3 P49234 4 W99035 5 V42056 6 T59828 7 F72412 8 W20999 9 018870 10 W75774 11 N25220 12 094361 13 G87578 14 B68170 15 M89375 16 S63900 17 Y96036 18 C82505 19 Y75358 20 J60811 21 Q56783 22 Q75281 23 V73596 24 L86947 25 W90960 26 P40886 27 U88627 28 Y88831 29 P83373 30 B53454 31 A60088 32 33 X B Ida Smith Betty Garza Leroy Pirkle Name Kay Colbert Michael Crozier Brandon Miles Michael Alvarez fx =IF(AND(C2>=21,D2>=3),"Yes","No") Warren Stewart Stacy Wiggins Billy Herald Margaret Cruz Chester Keese Claudette Littell Florence Miller Kimberly Gerace Roman Goble Jocelyn Allen Ron Morse Roberta Ervin James Rusnak Suzanne Lawrence ShannonGarner Emory Little Laura Li Floretta Cauthen Beverly Berry Stephanie Papa Wallace Rivera Larry Russell Aaron Sifford C Age Post-Secondary Years 24 25 21 22 19 24 28 18 24 21 23 18 19 21 26 22 22 20 21 19 24 18 25 24 18 23 19 29 D 19 25 6 7 3 4 2 6 10 0 6 E Base Rate 5 0 1 3 8 4 4 2 3 1 2 0 5 6 0 5 1 9 1 7 16.50 16.50 15.75 15.75 15.75 16.50 17.50 15.00 16.50 15.75 16.50 15.00 15.25 15.75 17.50 15.75 15.75 15.75 15.75 15.25 15.75 15.00 16.50 16.50 15.00 16.50 15.25 17.50 15.25 16.50 F G Class Finance Certified 2022 Yes 2023 Yes 2022 Yes 2023 Yes 2024 No 2025 Yes 2022 Yes 2026 No 2025 Yes 2022 No 2023 Yes 2024 No 2026 Yes 2023 Yes 2023 Yes 2025 Yes 2022 Yes 2022 Yes 2026 No 2022 Yes 2025 Yes 2024 No 2023 Yes 2022 Yes 2025 No 2023 Yes 2023 Yes 2023 Yes 2022 No 2023 Yes H Grad Student Yes Yes No No No Yes Yes No Yes No No No No No Yes No No No No No No No Yes Yes No No No Yes No Yes Elected No Yes Yes No Yes No No No Yes No No No No No No No Yes No No Yes Yes No Yes Yes No No Yes No No Yes Qualified Driver YES YES NO NO NO YES YES NO YES NO NO NO NO NO YES NO NO NO NO NO YES NO YES YES NO NO NO YES NO YES K Leadership Training yes yes yes yes yes yes yes no yes yes yes no yes yes yes yes yes yes yes yes yes no yes yes no yes yes yes no yes Mentor Yes Yes Yes Yes No Yes Yes No Yes Yes Yes No No Yes Yes Yes Yes No Yes No No No Yes Yes No Yes No Yes No Yes Formula Bar Officer Qualified Lyes Elected Elected Yes Elected Yes Yes No Elected No Yes No Yes Yes Yes Yes Elected Yes No Elected Elected No Elected Elected No Yes Elected Yes No Elected N Tier 2 2 1 2 1 2 2 1 2 1 2 1 1 1 2 2 2 1 1 1 1 1 2 2 1 2 1 2 1 2 O Student ID Student Name P Elected Students All Students Postsecondary Years Base Rate Q G62918 Kay Colbert Total Students 11 30 0 15 R Average Post-Secondary Years 4 3.8 1 15.25 S 2 15.75 T 5 16.5 U 8 17.5 V