subject

1. 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 first 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.

ansver
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 06:50, phillipfruge3
Match the personality traits with their description
Answers: 1
image
Computers and Technology, 23.06.2019 23:30, issacurlyheadka
A. in packet tracer, only the server-pt device can act as a server. desktop or laptop pcs cannot act as a server. based on your studies so far, explain the client-server model.
Answers: 2
image
Computers and Technology, 24.06.2019 14:00, youcandoit13
In simple terms, how would you define a protocol?
Answers: 2
image
Computers and Technology, 24.06.2019 17:30, mjmckay03
What is the main difference between cloud computing and saas? cloud computing is a platform, and saas is software. cloud computing is software, and saas is a platform. cloud computing is a service, and saas is software. cloud computing is a service, and saas is a platform.
Answers: 1
You know the right answer?
1. To be a Supervisor, the staff member must either have more than 5 service years or be a college g...

Questions in other subjects: