Need help with some of the formulas for this assignment. Specifically step 7. Added an image of the table to help.

7. In cell N2, enter a formula using the IF function and structured references as follows to determine which work tier Kay Colbert is qualified for: a. The IF function should determine if the student's Post-Secondary Years is greater than or equal to 4 , and return the value 2 if true or the value 1 if false. b. Fill the formula into the range N3:N31, if necessary. 8. Lael wants a quick way to look up students by their Student ID. In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text Invalid Student ID should display. 9. Lael wants to determine several totals and averages for active students. In cell Q8, enter a formula using the COUNTIF function and structured references to count the number of students who have been elected to offices in student organizations. 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. 11. In cell R9, enter a formula using the AVERAGE function and structured references to determine the average number of years of post-secondary education of all students as shown in the Post-Secondary Years column. (1) 7. In cell N2, enter a formula using the IF function and structured references as follows to determine which work tier Kay Colbert is qualified for: a. The IF function should determine if the student's Post-Secondary Years is greater than or equal to 4 , and return the value 2 if true or the value 1 if false. b. Fill the formula into the range N3:N31, if necessary. 8. Lael wants a quick way to look up students by their Student ID. In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text Invalid Student ID should display. 9. Lael wants to determine several totals and averages for active students. In cell Q8, enter a formula using the COUNTIF function and structured references to count the number of students who have been elected to offices in student organizations. 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. 11. In cell R9, enter a formula using the AVERAGE function and structured references to determine the average number of years of post-secondary education of all students as shown in the Post-Secondary Years column. (1)