subject
Business, 15.04.2020 22:18 aurikmah2005

To be a Bunk Leader, a staff member must have over 4 service years and have completed leadership training. In cell L2, enter a formula using the IF and AND functions, as well as structured references to determine if Adam Moriarty can be a bunk leader. a. The logical test in the IF function should determine if the staff member’s Service Years is greater than 4 AND the staff member’s Leadership Training status is "Yes". Remember to use a structured reference to the Service Years and the Leadership Training columns. b. The function should return the text Yes if a staff member meets both of those criteria. c. The function should return the text No if a staff member meets none or only one of those criteria.

ansver
Answers: 1

Another question on Business

question
Business, 21.06.2019 18:20
Amathematical approximation called the rule of 70 tells us that the number of years that it will take something that is growing to double in size is approximately equal to the number 70 divided by its percentage rate of growth. thus, if mexico's real gdp per person is growing at 7 percent per year, it will take about 10 years(=70/7) to double. apply the rule of 70 to solve the following problem. real gdp per person in mexico in 2005 was about $11,000 per person, while it was about $44,000 per person in the u.s. if real gdp per person in mexico grows at the rate of 5 percent per year: how long will it take mexico's real gdp per person to reach the level that the united states was at in 2005? (hint: how many times would mexico's 2005 real gdp per person have to double to reach the u.s.'s 2005 real gdp per person?
Answers: 3
question
Business, 22.06.2019 10:10
An investment offers a total return of 18 percent over the coming year. janice yellen thinks the total real return on this investment will be only 14 percent. what does janice believe the inflation rate will be over the next year?
Answers: 3
question
Business, 22.06.2019 14:30
In our daily interactions we can find ourselves listening to other people solely for the purpose of finding weakness in their positions so that we can formulate a convincing response. select one: true false
Answers: 1
question
Business, 22.06.2019 15:30
The school cafeteria can make pizza for approximately $0.30 a slice. the cost of kitchen use and cafeteria staff runs about $200 per day. the pizza den nearby will deliver whole pizzas for $9.00 each. the cafeteria staff cuts the pizza into eight slices and serves them in the usual cafeteria line. with no cooking duties, the staff can be reduced by half, for a fixed cost of $75 per day. should the school cafeteria make or buy its pizzas?
Answers: 3
You know the right answer?
To be a Bunk Leader, a staff member must have over 4 service years and have completed leadership tra...
Questions
question
Mathematics, 30.05.2020 11:58
question
Computers and Technology, 30.05.2020 11:58
question
Mathematics, 30.05.2020 11:58
question
Mathematics, 30.05.2020 11:58
Questions on the website: 13722361