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, 24.06.2019 18:30, trevorhenyan51
Dereck works for long hours on his computer.  he frequently experiences physical strain by the end of the day because he does not follow an important rule of ergonomics with respect to the use of keyboards.  which of the following actions of dereck could lead to physical strain? a.  placing the keyboard exactly in front of him while typingb.  keeping hands and wrists straight while typingc.  using wrist pads throughout the dayd.  pounding at the keys on the keyboard while typinge.  resting his hands on the keyboard when he is not typing
Answers: 1
image
Computers and Technology, 25.06.2019 00:00, Ryan02717
Into which of these files would you paste copied information to create an integrated document? a. mailing list b. destination c. source d. data source
Answers: 1
image
Computers and Technology, 25.06.2019 17:20, ritasolomon85
In a display device, response rate is the time it takes for one pixel to change from black to white then back to black. a. true b. false
Answers: 1
image
Computers and Technology, 26.06.2019 01:00, july00
Which of these refer to information about the variables in mail merges? a. template b. email c. data source d. letter e. folder
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
English, 17.10.2021 23:30
Konu
Mathematics, 17.10.2021 23:30
Konu
Computers and Technology, 17.10.2021 23:30