Author Question: Your management team is deciding on a new allocation of computers. If there are more than 15 ... (Read 43 times)

Mimi · **on:** Aug 28, 2018

Your management team is deciding on a new allocation of computers. If there are more than 15 employees in an office, you will allocate 10 computers. If there are between 10 and 14 employees, you will allocate 8 computers. If there are fewer than 10 employees, you will allocate 5 computers. You have a table that contains each location's employment numbers. What is the best Access function to use for this allocation?

A) IIF function B) Payment function
C) Future Value function D) Nested IIF function

Question 2

The ________ tab on the Ribbon only displays in the Excel desktop application.

A) DATA B) REVIEW C) FORMULAS D) VIEW