10. In cell R8, enter a formula using the AVERAGEIF function and structured references to determine the average number of post-secondary years for students who have been elected. X Create a formula using a function. In the Student Representatives worksheet, the formula in cell R8 should use a structured reference to the Elected column in the Student Representatives table in the range argument of the AVERAGEIF function. 0/ R8 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 33 34 Name B 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 = AVERAGEIF(M2: M31,"elected",D2:D31) 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 E Base Rate 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 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 Finance Certified 2022 Yes 2023 Yes 2022 Yes 2023 Yes 2024 No 2025 Yes 2022 Yes Class 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 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 P Elected Students All Students Postsecondary Years Base Rate Q G62918 Kay Colbert Total Students Average Post-Secondary Years 11 30 R 0 15 4 3.8 1 15.25 S 2 15.75 T 5 16.5 U 8 17.5 V 10. In cell R8, enter a formula using the AVERAGEIF function and structured references to determine the average number of post-secondary years for students who have been elected. X Create a formula using a function. In the Student Representatives worksheet, the formula in cell R8 should use a structured reference to the Elected column in the Student Representatives table in the range argument of the AVERAGEIF function. 0/ R8 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 33 34 Name B 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 = AVERAGEIF(M2: M31,"elected",D2:D31) 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 E Base Rate 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 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 Finance Certified 2022 Yes 2023 Yes 2022 Yes 2023 Yes 2024 No 2025 Yes 2022 Yes Class 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 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 P Elected Students All Students Postsecondary Years Base Rate Q G62918 Kay Colbert Total Students Average Post-Secondary Years 11 30 R 0 15 4 3.8 1 15.25 S 2 15.75 T 5 16.5 U 8 17.5 V