1. 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.

The IF function should first determine if the staff members Service Years is greater than 3 OR if the staff members college graduate status is Yes. Remember to use a structured reference to the Service Years and the College Graduate columns.

The function should return the text Yes if a staff member meets one or both of those criteria.

The function should return the text No if a staff member meets neither of those criteria.

Table Topls Fil: Homs r Page Layout Formla tcview Hlp DYMO Labl DTel mewhst you went to dc Share 9- wrup T.at , H Nurmi" 2 2 POOct He.. stude svomsson|ko' mal- E-Autefim..Tp Simitd Neutral Sort & ind & Years since First Ald College Candidate Staff ID Name Age Service Years Base Salary First Ald Certification Year Leadership Training Transportation Group Leader Bunk Leader Leadership Tr 3 Yes 5 Yes 10 Yes 5 Yes 5 Yes 1 Yes 4 Yes 3 Yes 5 Yes 7015 18 3 Yes 4 No 4 Yes 2 Yes 1033 Stephanie lto Documemation Staft L