$1.$ In cell N$2,$ 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 value in the Post$-$Secondary Years column 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 N$3$:N$31,$ if necessary.

a$.$ The IF function should determine if the value in the Age column is greater than or equal to $21$ AND the value in the student's Post$-$Secondary Years column is greater than or equal to $3,$ and should return the text Yes if a student meets both of those criteria or the text No if a student meets none or only one of those criteria.

b$.$ Fill the formula into the range L$3$:L$31,$ if necessary.