Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
3.    To be eligible to work with the swim team, an employee must have at least two years of experience or have completed CPR training. In cell K3 enter a formula using the IF and OR functions as follows to determine if Tiffany Adams can work with the swim team: a. The IF function should determine if the employee's Years of Experience is greater than or equal to 2 OR if the employee's CPR trained status is "Yes", returning the text Yes if an employee meets one or both of those criteria or the text No if an employee meets neither of those crite

3.    To be eligible to work with the swim team, an employee must have at least two years of experience or have completed CPR training. In cell K3 enter a formula using the IF and OR functions as follows to determine if Tiffany Adams can work with the swim team: a. The IF function should determine if the employee's Years of Experience is greater than or equal to 2 OR if the employee's CPR trained status is "Yes", returning the text Yes if an employee meets one or both of those criteria or the text No if an employee meets neither of those crite

Fundamentals of Information Systems
Fundamentals of Information Systems
8th Edition
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter7: Knowledge Management And Specialized Information Systems
Section: Chapter Questions
Problem 1.1DQ
See similar textbooks
icon
Related questions
Question
100%

3.    To be eligible to work with the swim team, an employee must have at least two years of experience or have completed CPR training. In cell K3 enter a formula using the IF and OR functions as follows to determine if Tiffany Adams can work with the swim team:

a. The IF function should determine if the employee's Years of Experience is greater than or equal to 2 OR if the employee's CPR trained status is "Yes", returning the text Yes if an employee meets one or both of those criteria or the text No if an employee meets neither of those criteria.

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
Transcribed Image Text: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

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Problems on Dynamic Programming
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS