To be a group leader, the staff member must either have more than 3 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 Adam Moriarty can be a group leader.

A. The IF function should first determine if the staff member's Service Years is greater than 3 OR if the staff member's college graduate status is "Yes". Remember to use structured reference to the Service Years ([Service Years]) and the College Graduate columns ([College Graduate]).

B. If a staff member meets one or both of those criteria, the function should return the text Yes (using "Yes" for the value_if_true argument).

C. If a staff member meets neither of those criteria, the function should return the text No (using "No" for the value_if_false argument).