Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

To be a Supervisor, the staff member must either have more than 5 service years or be a college graduate. In cell K2 enter a

image text in transcribed
To be a Supervisor, the staff member must either have more than 5 service years or be a college graduate. In cell K2 enter a formula using the IF and OR functions, as well as structured references to determine if Alison Simoneau can be a supervisor. a. The IF function should rst determine if the staff member's Service Years is greater than 5 OR if the staff member's college graduate status is \"Yes". Remember to use a structured reference to the Service Years and the College Graduate columns. b. The function should return the text Yes if a staff member meets one or both of those criteria. c. The function should return the text No if a staff member meets neither of those criteria

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

Law And Society

Authors: Matthew Lippman

3rd Edition

1544392583, 978-1544392585

More Books

Students also viewed these Law questions

Question

=+a. Is it relevant to the audience?

Answered: 1 week ago

Question

=+c. Would it generate press attention?

Answered: 1 week ago

Question

=+d. Would it create talk value or buzz?

Answered: 1 week ago