subject

The second part of the Summary sheet contains a sales associate lookup form, but the appropriate formulas have not been entered yet. a) In cell B18, enter a formula to calculate the average commission earned for the sales associate last name entered in cell A16. (Hint: Use a database function. Use the named range Earnings as the Database argument and the column label Commission Earned as the Field argument. The criteria range should be A15:B16.)
b) In cell B19, enter a formula to calculate the total commission earned for that same sales associate. (Hint: Use a different database function. The function arguments are the same as those you used in Step 6a.)
c) If necessary, apply the Accounting Number Format to cells B18:B19.
d) In cell B20, enter a formula to calculate the number of clients the sales associate had with annual sales reaching the target set in cell B16. (Hint: This time, use the column label Client as the Field argument. The criteria range should be A15:B16.) Remember, the values in the Client field are text values. Ủse the appropriate function
e) If necessary, apply the General number format to cell B20
f) Test your formulas by entering Schmidt as the sales associate's last name (cell A16) and >175000 as the sales target (cell B16
g) Add an IFERROR function to the formula in cell B18 to display the error text Associat h) If you receive errors, use Evaluate Formula to troubleshoot your formulas

ansver
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 01:00, tyneshiajones124
Duplicating objects creates copies that a. move differently than the original object b. erase the original object c. look and act like the original object d. add events to a game
Answers: 1
image
Computers and Technology, 23.06.2019 06:00, tchloe448
What makes myhexadecimalnumber a child of mynumber? which methods does myhexadecimalnumber inherit directly from the mynumber class? what can an instance of the mynumber class do? what can an instance of the myhexadecimalnumber class do? which methods are overridden? why are they overridden? how many examples of overloading are there? why was this done? where is the super keyword used? what is it doing? why isn’t the incoming value set immediately in the second myhexadecimalnumber constructor? how many examples can you find of an inherited method being called?
Answers: 1
image
Computers and Technology, 23.06.2019 15:00, abelxoconda
1. which of the following statements are true about routers and routing on the internet. choose two answers. a. protocols ensure that a single path between two computers is established before sending packets over it. b. routers are hierarchical and the "root" router is responsible for communicating to sub-routers the best paths for them to route internet traffic. c. a packet traveling between two computers on the internet may be rerouted many times along the way or even lost or "dropped". d. routers act independently and route packets as they see fit.
Answers: 2
image
Computers and Technology, 24.06.2019 03:00, paguy12
What is one potential problem associated with an organization purchasing new technology early in its lifecycle
Answers: 1
You know the right answer?
The second part of the Summary sheet contains a sales associate lookup form, but the appropriate for...

Questions in other subjects:

Konu
Mathematics, 08.03.2021 08:10