1. To be a Supervisor for online tutoring, a staff member must be a supervisor and have completed Academic Technology training. In cell L2, enter a formula using the IF and AND functions, as well as structured references to determine if Alison Simoneau 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.