subject

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: 1

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 19:30
2. fluorine and chlorine molecules are blamed fora trapping the sun's energyob forming acid rainoc producing smogod destroying ozone molecules
Answers: 2
question
Computers and Technology, 24.06.2019 11:20
William travels a lot on business purpose. he needs to regularly communicate with his business partner. he also needs to send out weekly reports to his boss while he is traveling. which web-based application best suits william’s needs? (social media, webmail, wiki) is the best web-based application for william. he can access this application via the internet using a (digital cable, fax machine, web browser).
Answers: 1
question
Computers and Technology, 24.06.2019 22:00
Ican’t open these when it’s just a comment. someone pls explain why this is happening
Answers: 1
question
Computers and Technology, 24.06.2019 22:30
To include a watermark or page border on a word document, you will first need to navigate to the tab. file home insert design
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
Physics, 31.03.2021 04:10
question
English, 31.03.2021 04:10
question
Mathematics, 31.03.2021 04:10
Questions on the website: 13722360