instructions NP.EX16.8a Insert Design Layout References Mailings Review View dShare BodyCopy 8. To be a Bunk Leader, a staff member must have over 4 service and have In cell L2, enter a formula using the IF and AND as well as structured references to determine if Adam Morlarty 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 use a structured reference to the Service Years and the Leadership Training New Pespectives Excel 20161 Modile R SAM Project la 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 these criteria of the special staff teams require leadership training, which is offered to staff with more than 1 year of service at Camp Brighe Firewood. Dean wants to identify the staff members eligible for leadership training in the table In cell M2, enter a formula using a nested IF function and structured references to has completed member is eligible for leadership training. a. If the value of the Leadership Training column is equal to determine first if a staff member already leadership training, and if not, whether that staff r the text "Yes", the formula should return the text Completed. Remember to use a structurd reference to the dership Training column. b. If the value of the Leadership Training column is not equal to the formula should determine if the value in the Service Years column is greater than 1 MacBoo instructions NP.EX16.8a Insert Design Layout References Mailings Review View dShare BodyCopy 8. To be a Bunk Leader, a staff member must have over 4 service and have In cell L2, enter a formula using the IF and AND as well as structured references to determine if Adam Morlarty 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 use a structured reference to the Service Years and the Leadership Training New Pespectives Excel 20161 Modile R SAM Project la 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 these criteria of the special staff teams require leadership training, which is offered to staff with more than 1 year of service at Camp Brighe Firewood. Dean wants to identify the staff members eligible for leadership training in the table In cell M2, enter a formula using a nested IF function and structured references to has completed member is eligible for leadership training. a. If the value of the Leadership Training column is equal to determine first if a staff member already leadership training, and if not, whether that staff r the text "Yes", the formula should return the text Completed. Remember to use a structurd reference to the dership Training column. b. If the value of the Leadership Training column is not equal to the formula should determine if the value in the Service Years column is greater than 1 MacBoo