EX16.8a-Saved to my Mac Q- Search in ences Mailings Review View Normal years or be college graduate. In cell K2 enter a formula using the IF and OR functions, as wen as structured to determine i# Adam Moriarty can be a group leader IF function should first determine if the staff member's Service Years the College Graduate columns of those criteria. greater than 3 OR if the staff member's college c. The function should return the text No ifa staff member meets neither of 8. To be a Bunk Leader, a staff member must have over 4 service years and have completed leadership training tn cell L2, enter a formula using the IF and AND functions, as well as structured references to determine if Adam Moriarty can be a bunk leader. a. The logical test in the IF function should determine if the staff member's Service Years is greater than 4 AND the staff member's Leadership Training status is "Yes. Remember Service Years and the Leadership Training columns. to use a structured reference to the b. The function should return the text Yes i f a staff member meets both of those criteria. New Perspectives Excel 2016 1 Module 8 SAM Project 1a The function should return the text No a staff member meets none or only one of those criteria. staff teams require leadership training, which is offered to Many of the special staff with more than 1 year of service at Camp Bright Ficewood. Dean wants to identify In cell M2, enter a formula using references to determine first if a leadership training, and if not, 9. the staff members eligible for leadership training in the table. a nested IF function and structured staff member already has completed t a If the value of the Leadrship Training column is equal to the text English (United States) MacBook Du FS 43 #9 F6