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.

08 O P 0 N Tier - 2 Student ID Student Name G62918 Invalid Staff ID 2 1 2 1 2 Total Students Avera 2 Elected Students All Students 1 30 2 1 E F G H 1 Base Rate Class - Finance Certified Grad Student 2 16.50 2022 Yes Yes 3 16.50 2023 Yes Yes 4 15.75 2022 Yes No 5 15.75 2023 Yes No 6 15.75 2024 No No 7 16.50 2025 Yes Yes 8 17.50 2022 Yes Yes 9 15.00 2026 No No 10 16.50 2025 Yes Yes 11 15.75 2022 No No 12 16.50 2023 Yes No 13 15.00 2024 No No 14 15.25 2026 Yes No 15 15.75 2023 Yes No 16 17.50 2023 Yes Yes 17 15.75 2025 Yes No 18 15.75 2022 Yes No 19 15.75 2022 Yes No 20 15.75 2026 No No 21 15.25 2022 Yes No 22 15.75 2025 Yes No 16.0 202 NA Documentation Student Representatives K M Elected Qualified Driver Leadership Training Mentor Officer Qualified No Yes Yes Yes Yes Yes Yes Yes Yes Elected Yes No Yes Yes Elected No No Yes Yes Yes Yes No Yes No Elected No Yes Yes Yes Yes No Yes Yes Yes Yes No No No No No Yes Yes Yes Yes Elected No No Yes Yes No No No Yes Yes Yes No No No No No No No Yes No Yes No No Yes Yes Yes No Yes Yes Yes Yes No No Yes Yes Yes Yes No Yes Yes Elected No No Yes No Yes No No Yes Yes No Yes No Yes No Elected Yes Yes Yes No Elected Ala No Academic Groups Academic Pivot Table All Groups ... 2 1 0 Postsecondary Years Base Rate 1 15 1 2 2 2 1 1 1 1 Mla NA NA