Question

1. To be a Supervisor, the staff member must either have more than 5 service years or be a college graduate. In cell K2 enter a formula using the IF and OR functions, as well as structured references to determine if Alison Simoneau can be a supervisor. a. The IF function should first determine if the staff member’s Service Years is greater than 5 OR if the staff member’s college graduate status is "Yes". Remember to use a structured reference to the Service Years and the College Graduate columns. b. The function should return the text Yes if a staff member meets one or both of those criteria. c. The function should return the text No if a staff member meets neither of those criteria.

Answer 1

See explaination

Step-by-step explanation:

First convert the above data into a table in excel from Insert tab, selecting the entire table and clicking on insert table

Then add the following formulas

Column K: IF(OR([at[Service Years]]>5,[at[College Graduate]]="Yes"),"Yes","No")

Column L: IF(AND([atSupervisor]="Yes",[at[Academic Technology Training]]="Yes"),"Yes","No")

See attachment for the result of the inputted formula.

Note: replace all the "at" with yhe at symbol.