PROJECT STEPS 1. Lael Masterson works in the Student Activities Ofce at Valerian State College in Illinois. Lael has started compiling information on students who are interested in helping run student organizations at Valerian State, and she needs your help completing the workbook. Switch to the Student Representatives worksheet. Determine the base rate for the rst student (which is based on the student's number of years of postsecondary education} using a function as follows: a. Use a structured reference to look up the value in the PostSecondary Years column. Retrieve the base rate in the table showing the base rate by post secondary years. The formula should always use the exact range and nd an approximate match. b. Fill the function to the rest of the column, if necessary. Student organizations sometimes require transportation for offcampus activities, and school policy requires students to be over 23 years old to serve as transport. Lael wants to determine how many of the active students will be eligible to transport other group members. Populate the Qualified Driver column as follows: a. Enter a function and structured references to determine if the first student is a qualied driver. Display Yes if the student is older than 23; if not, display No. b. Fill the function to the rest of the column, if necessary. To be eligible for the leadership training program offered by the Student Activities Office, a student must have at least two years of postsecondary education or have gone through the organization nance training. Populate the Leadership Training column as follows: a. Enter a formula using nested functions and structured references to detem1ine if the first student is eligible for the leadership training program. Display Yes if one or both of the criteria are met. Display No if a student meets neither of the criteria. b. Fill the formula to the rest of the columnI if necessary. B E G U C D F H M N R S T v W Student ID Name Age * Post-Secondary Years Base Rate Y Class * Finance Certified | Grad Student Y E Elected * Qualified Driver |Leadership Training |Mentor |Officer Qualified * Colu G62918 Kay Colbert 24 2022 Yes Yes No Student ID G62918 P49234 Michael Crozier 25 2023 Yes Yes Yes Student Name Kay Colbert W9903 Brandon Miles 21 2022 Yes No Yes V42056 Michael Alvarez 22 2023 Yes No No 159828 Ida Smith 19 2024 No No Yes F72412 Betty Garza 24 2025 Yes Yes No Total Students Average Post-Secondary Years 8 W20999 Leroy Pirkle 28 2022 Yes Yes No Elected Students Q18870 Warren Stewart 18 2026 No No No All Students 30 0 W75774 Stacy Wiggins 24 2025 Yes Yes Yes 11 N25220 Billy Herald 21 2022 No No No 12 094361 Margaret Cruz 23 2023 Yes No No G87578 Chester Keese 18 2024 No No No Postsecondary Years 0 1 2 5 8 B68170 Claudette Littell 19 2026 Yes No No Base Rate 15 15.25 15.75 16.5 17.5 15 M89375 Florence Miller 21 2023 Yes No No 6 563900 Kimberly Gerace 26 2023 Yes Yes No Y96036 Roman Goble 22 2025 Yes No No 18 C82505 Jocelyn Allen 22 2022 Yes No Yes Y75358 Ron Morse 20 2022 Yes No No 20 J60811 Roberta Ervin 21 2026 No No No Q56783 James Rusnak 19 2022 Yes No Yes Q75281 Suzanne Lawrence 24 2025 Yes No Yes 3 V7359 ShannonGarner 18 2024 No No No 24 L86947 Emory Little 25 2023 Yes Yes Yes W90960 Laura Li 24 2022 Yes Yes Yes 6 P40886 Floretta Cauthen 18 2025 No No No 27 U88627 Beverly Berry 23 2023 Yes No No 8 Y88831 Stephanie Papa 19 2023 Yes No Yes 19 P83373 Wallace Rivera 2023 Yes Yes No B53454 Larry Russell 2022 No No No A60088 Aaron Sifford 2023 Yes Yes Yes