5. Lael is always on the lookout for qualified students who might be interested in running for office in student groups. A student is qualified to be an officer if they have already been elected to office in a student group; and if they have not, they are qualified if they have been certified financially. Populate the Officer Qualified column as follows: a. Enter a formula using nested functions to determine if the first student is qualified to be an officer. If the student has been previously elected (i. e., "Yes" displays in the Elected column), display Elected.
b. Otherwise, if the student is "Finance Certified", display Yes; if not, display No.
c. Fill the formula to the rest of the column, if necessary.
6. Students who work with student organizations are also considered for employment at the Student Activities Office. Students with more than four years of post-secondary education are qualified for more complex Tier 2 jobs. Populate the final column as follows:
a. Enter Tier as the final column heading.
b. Enter a function to determine the work tier of the first student. If the student has completed at least four post-secondary years, display 2; if not, display 1.
c. Fill the function to the rest of the column, if necessary.