subject
Computers and Technology, 29.03.2021 21:50 kolin89

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 and structured references 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: a. If the value in the CPR Trained column is equal to the text "Yes", the formula should display Trained as the text.

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

c. Fill the formula into the range M4:M32] if necessary.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 23:30
Define a function printfeetinchshort, with int parameters numfeet and numinches, that prints using ' and " shorthand. ex: printfeetinchshort(5, 8) prints: 5' 8"
Answers: 1
question
Computers and Technology, 23.06.2019 01:30
Which tab is used to change the theme of a photo album slide show? a. design b. view c. transitions d. home
Answers: 1
question
Computers and Technology, 23.06.2019 02:00
Which software would you use to create a print design? a. illustrator b. audacity c. reaper d. dreamweaver
Answers: 2
question
Computers and Technology, 23.06.2019 17:00
The camera still is bad even with the new iphone xr and especially in low light it is even worst because you can see the pixels more if its in low light. if all you apple customers want apple to fix this then lets fill there feedback with complaints about the can apple do to fix this issue?
Answers: 1
You know the right answer?
Brittany wants to identify employees who are eligible to take a CPR course at the clubs expense. Emp...
Questions
question
Mathematics, 08.06.2020 13:57
question
Mathematics, 08.06.2020 13:57
question
Mathematics, 08.06.2020 13:57
question
History, 08.06.2020 13:57
question
Mathematics, 08.06.2020 13:57
question
History, 08.06.2020 13:57
question
English, 08.06.2020 13:57
question
World Languages, 08.06.2020 13:57