Brittany wants to identify employees who are eligible to take a CPR course at the clubs' expense. Employees who can work as camp counselors are eligible for the course. In cell M3, enter a formula using a nested IF function as follows to determine first if an employee has already been trained in CPR, and if not, whether that employee meets the qualifications to take the course:If the value in the CPR Trained column is equal to the text "Yes", the formula should display Trained as the text.Otherwise, the formula should determine if the value in the Camp Counselor column is equal to the text "Yes" and return the text Yes if true and No if false. A.CDEFGHIKLMN1EligibilityEmployee ID -3 A213Pay Rate16.00LifeguardAgeCert. Year-CPR Trained -InstructorTeam Coach -CPR CourseLevel2NameYears of ExperienceCamp CounselorSwim Team2018Tiffany AdamsHassan Bachim224YesYesYesYESNO24 B53419115.752022NoNoNoNONO1Megan BeckmanCatherine Coleman5 B68119115.752022YesNoNoNONO16 C8267 F724YES22416.002017YesNoYesNO2.Carrie Faulkner24616.502015YesYesNoYESYES8 G629Paul Gomez24616.502018YesYesNoYESYES2.9 G87510 160811 L86912 M893Bryant GrossburgMarilyn JesbergerJonathan Lampert1815.502022NoNoNoNONO121316.002019NoNoNoNONO12516.502019YesYesYesYESYESGina Milota21316.002020YesNoNoNONO113 N252Jeff Newman21316.002020NoNoNoNONO114 094315 P40816 P49217 P83318 0567Crystal OlneckYolanda Padilla23516.502018YesNoNoYESYES2.NOYESNOYES1815.502022NoNoNo1Michael Pienkowski2516.502017YesYesYes2.Keith Pienkowski24616.502018YesYesNoYESYES2James QuinlanRyan QuinlanAndrea Shelby2416.002020YesNoYesYESYES2.19 Q75220 S63921 T59822 U882016.002020YesNoYesNONO126817.502017YesYesNoYESYES2.Anna Tran19216.002021NoNoYesNONOTracy UphoffJavier VazquezJose Vazquez2316.502017YesYesNoYESYES2.23 V1881815.502022NoNoNoNONO124 V42022416.002018YesNoNoYESNO25 V735Alexa Vanderson1815.502022NoNoNoNONOYES126 W209Dale Wong28416.002018YesYesNoYES2.27 W757Julie WeissMary WinslowBrandon Waddell24616.502017YesYesYesYESYES228 W90924616.502018YesYesYesYESYES2.16.0016.0029 W990212019YesNoYesNONO130 Y753Aaron Yee202.2019YesNoNoNONO1Kay YamashitaRichard Young31 Y88819115,752021YesNoYesNONO132 Y96022416.002018YesYesNoYESNO222

If Statement takes three arguments, 1. Condition 2. Return value in true case 3. Return value in…

Answered: If the value in the CPR Trained column…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Brittany wants to identify employees who are eligible to take a CPR course at the clubs' expense. Employees who can work as camp counselors are eligible for the course. In cell M3, enter a formula using a nested IF function as follows to determine first if an employee has already been trained in CPR, and if not, whether that employee meets the qualifications to take the course:

1. If the value in the CPR Trained column is equal to the text "Yes", the formula should display Trained as the text.
2. Otherwise, the formula should determine if the value in the Camp Counselor column is equal to the text "Yes" and return the text Yes if true and No if false.

A.
C
D
E
F
G
H
I
K
L
M
N
1
Eligibility
Employee ID -
3 A213
Pay Rate
16.00
Lifeguard
Age
Cert. Year-
CPR Trained -
Instructor
Team Coach -
CPR Course
Level
2
Name
Years of Experience
Camp Counselor
Swim Team
2018
Tiffany Adams
Hassan Bachim
22
4
Yes
Yes
Yes
YES
NO
2
4 B534
19
1
15.75
2022
No
No
No
NO
NO
1
Megan Beckman
Catherine Coleman
5 B681
19
1
15.75
2022
Yes
No
No
NO
NO
1
6 C826
7 F724
YES
22
4
16.00
2017
Yes
No
Yes
NO
2.
Carrie Faulkner
24
6
16.50
2015
Yes
Yes
No
YES
YES
8 G629
Paul Gomez
24
6
16.50
2018
Yes
Yes
No
YES
YES
2.
9 G875
10 1608
11 L869
12 M893
Bryant Grossburg
Marilyn Jesberger
Jonathan Lampert
18
15.50
2022
No
No
No
NO
NO
1
21
3
16.00
2019
No
No
No
NO
NO
1
25
16.50
2019
Yes
Yes
Yes
YES
YES
Gina Milota
21
3
16.00
2020
Yes
No
No
NO
NO
1
13 N252
Jeff Newman
21
3
16.00
2020
No
No
No
NO
NO
1
14 0943
15 P408
16 P492
17 P833
18 0567
Crystal Olneck
Yolanda Padilla
23
5
16.50
2018
Yes
No
No
YES
YES
2.
NO
YES
NO
YES
18
15.50
2022
No
No
No
1
Michael Pienkowski
25
16.50
2017
Yes
Yes
Yes
2.
Keith Pienkowski
24
6
16.50
2018
Yes
Yes
No
YES
YES
2
James Quinlan
Ryan Quinlan
Andrea Shelby
24
16.00
2020
Yes
No
Yes
YES
YES
2.
19 Q752
20 S639
21 T598
22 U88
20
16.00
2020
Yes
No
Yes
NO
NO
1
26
8
17.50
2017
Yes
Yes
No
YES
YES
2.
Anna Tran
19
2
16.00
2021
No
No
Yes
NO
NO
Tracy Uphoff
Javier Vazquez
Jose Vazquez
23
16.50
2017
Yes
Yes
No
YES
YES
2.
23 V188
18
15.50
2022
No
No
No
NO
NO
1
24 V420
22
4
16.00
2018
Yes
No
No
YES
NO
25 V735
Alexa Vanderson
18
15.50
2022
No
No
No
NO
NO
YES
1
26 W209
Dale Wong
28
4
16.00
2018
Yes
Yes
No
YES
2.
27 W757
Julie Weiss
Mary Winslow
Brandon Waddell
24
6
16.50
2017
Yes
Yes
Yes
YES
YES
2
28 W909
24
6
16.50
2018
Yes
Yes
Yes
YES
YES
2.
16.00
16.00
29 W990
21
2019
Yes
No
Yes
NO
NO
1
30 Y753
Aaron Yee
20
2.
2019
Yes
No
No
NO
NO
1
Kay Yamashita
Richard Young
31 Y888
19
1
15,75
2021
Yes
No
Yes
NO
NO
1
32 Y960
22
4
16.00
2018
Yes
Yes
No
YES
NO
2
22

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions