5. Lael is always on the lookout for students who might be interested in running for office in student groups. In cell M2, enter a formula using a nested IF function and structured references as follows to determine first if a student has already been elected to office in a student group, and if not, whether that student meets the qualifications to run in the future: a. If the value in the Elected column is equal to the text "Yes", the formula should display Elected as the text. b. Otherwise, the formula should determine if the value in the Finance Certified column is equal to the text "Yes" and return the text Yes if true And No if false. X Create a formula using a function. In the Student Representatives worksheet, the formula in cell M2 should use a structured reference to the Finance Certified value in the logical test argument of the inner IF function. X Copy a formula into a range. In the Student Representatives worksheet, cell M2 contains an incorrect formula. M2 A 1 Student ID 2 G62918 3 P49234 4 W99035 5 V42056 6 T59828 7 F72412 8 W20999 9 Q18870 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 B Name Kay Colbert Michael Crozier Brandon Miles Michael Alvarez Ida Smith Betty Garza Leroy Pirkle 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 fx =IF(12="Yes","Elected",IF(G2="Yes","Yes","No")) Age 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 19 25 D Post-Secondary Years 6 7 3 4 2 6 10 0 6 3 5 0 1 3 8 4 4 2 3 1 2 0 5 6 0 5 1 9 1 7 E Base Rate Class 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 G 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 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 J 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 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 M Officer Qualified Yes 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 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 W 5. Lael is always on the lookout for students who might be interested in running for office in student groups. In cell M2, enter a formula using a nested IF function and structured references as follows to determine first if a student has already been elected to office in a student group, and if not, whether that student meets the qualifications to run in the future: a. If the value in the Elected column is equal to the text "Yes", the formula should display Elected as the text. b. Otherwise, the formula should determine if the value in the Finance Certified column is equal to the text "Yes" and return the text Yes if true And No if false. X Create a formula using a function. In the Student Representatives worksheet, the formula in cell M2 should use a structured reference to the Finance Certified value in the logical test argument of the inner IF function. X Copy a formula into a range. In the Student Representatives worksheet, cell M2 contains an incorrect formula. M2 A 1 Student ID 2 G62918 3 P49234 4 W99035 5 V42056 6 T59828 7 F72412 8 W20999 9 Q18870 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 B Name Kay Colbert Michael Crozier Brandon Miles Michael Alvarez Ida Smith Betty Garza Leroy Pirkle 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 fx =IF(12="Yes","Elected",IF(G2="Yes","Yes","No")) Age 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 19 25 D Post-Secondary Years 6 7 3 4 2 6 10 0 6 3 5 0 1 3 8 4 4 2 3 1 2 0 5 6 0 5 1 9 1 7 E Base Rate Class 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 G 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 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 J 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 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 M Officer Qualified Yes 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 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 W