PLEASE SEE BELOW

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 Tbe 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. tsor and have conlelea Academic Technology training. In cell L2, enter a formula using the IF and AND functions, as well as structured references to determine if Alison Simoneay can be an online tutor A. The logical test in the IF function should determine if the staff member's Supervisor status is "Yes" AND the staff member's Academic Technology Training status is "Yes". Remember to use a structured reference to the Supervisor and the Academic Technology Training columns B. The function should return the text Yes if a staff member meets both of those criteria. C. The function should return the text No if a staff member meets none or only one of those criteria