Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

To be a Bunk Leader, a staff member must have over 4 service years and have completed leadership training. In cell L2, enter a formula

image text in transcribed"To be a Bunk Leader, a staff member must have over 4 service years and have completed leadership training. In 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 to use a structured reference to the Service Years and the Leadership 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."

Candidate for Leadership Training Years since First Ald College Graduate First Aid Certification Year Staff ID Name Age Service Years Base Salary Leadership Training Transportation Group Leader Bunk Leader Staff Level Certification 1103 Adam Moriarty 201 15.50 No No No No unor Yes ANA INA Completed 1055 Artie Jimenez 28 9 2015 Yes ve: Ye senio ves 1056 Bo Peterson 26 2013 ve: senior Ye Ye Yes ve cleted 1094 Eileen Randal 18 INA 2013 No No No No no. 1066 Flossie Frampton 23 #N/A 2016 2 Yes No Ye unicr ves rds leted 1054 Hayiey Jin 26 2013 Yes Yes renia Ver Yes 23 #N/A 2013 Completed 1070 Hiro Marumi Ve ves enia na icsteila Thorne #N/A Comelatod 25 1013 AN/A 1073 James Gutierrea 2 2014 Yes Nr Yo Yas unin no Yar Completed 2013 AN/A AN/A 1043 Kina Weston 4 2015 No No Ye Yes senio ves 18 2016 Completed senio 1034 Liam SABnson Yer ve re 1078 Melinda Masterson AN/A AN/A 2017 No Yes No Completed Junio nc 1036 Oscar Aberts 33 16 2015 3 Yes Yes ve: fe Completed senior ves 1076 Bichard Tepoer Yes cenio 21 IN/A 2014 No Ve Completed ne 1009 Robert Mller 44 25 NA 2014 4 Yes Ye Ye Completed seric ver yes 1012 Sierra Shapino 1033 Stentanie to NNA .. 16 2016 Ver Ve Crmpleted Completed Vor 17! #NA 2016 2 Yes Yes renia ... 106s Stephen McAlister #NA 2017 Completed No Yes ves vces scnio Comeintad 2013 an ... AN/A Completad Completed 1053 Tristen Rernolt 25 2014 Ye Yes conio ves ves 1064 Walter Kaminsky #N/A 2013 ve: 23 Yes Yos conlo yes Candidate for Leadership Training Years since First Ald College Graduate First Aid Certification Year Staff ID Name Age Service Years Base Salary Leadership Training Transportation Group Leader Bunk Leader Staff Level Certification 1103 Adam Moriarty 201 15.50 No No No No unor Yes ANA INA Completed 1055 Artie Jimenez 28 9 2015 Yes ve: Ye senio ves 1056 Bo Peterson 26 2013 ve: senior Ye Ye Yes ve cleted 1094 Eileen Randal 18 INA 2013 No No No No no. 1066 Flossie Frampton 23 #N/A 2016 2 Yes No Ye unicr ves rds leted 1054 Hayiey Jin 26 2013 Yes Yes renia Ver Yes 23 #N/A 2013 Completed 1070 Hiro Marumi Ve ves enia na icsteila Thorne #N/A Comelatod 25 1013 AN/A 1073 James Gutierrea 2 2014 Yes Nr Yo Yas unin no Yar Completed 2013 AN/A AN/A 1043 Kina Weston 4 2015 No No Ye Yes senio ves 18 2016 Completed senio 1034 Liam SABnson Yer ve re 1078 Melinda Masterson AN/A AN/A 2017 No Yes No Completed Junio nc 1036 Oscar Aberts 33 16 2015 3 Yes Yes ve: fe Completed senior ves 1076 Bichard Tepoer Yes cenio 21 IN/A 2014 No Ve Completed ne 1009 Robert Mller 44 25 NA 2014 4 Yes Ye Ye Completed seric ver yes 1012 Sierra Shapino 1033 Stentanie to NNA .. 16 2016 Ver Ve Crmpleted Completed Vor 17! #NA 2016 2 Yes Yes renia ... 106s Stephen McAlister #NA 2017 Completed No Yes ves vces scnio Comeintad 2013 an ... AN/A Completad Completed 1053 Tristen Rernolt 25 2014 Ye Yes conio ves ves 1064 Walter Kaminsky #N/A 2013 ve: 23 Yes Yos conlo yes

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Marketing Audit Translating Marketing Theory Into Practice The Marketing Series

Authors: Malcolm McDonald

1st Edition

0750600896, 978-0750600897

More Books

Students also viewed these Accounting questions