Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

6. The second part of the lawman: sheet contains a sales assoc1ate lookup form, but the appropriate formulas have not been entered yet. 21. In

image text in transcribed
6. The second part of the lawman: sheet contains a sales assoc1ate lookup form, but the appropriate formulas have not been entered yet. 21. In cell BIS, enter a formula to calculate the average commission earned for the sales associate last name entered in cell A16. (Him? Use a database function. Use the named range Earnings as the Dafabme argument and the column label Commission Earned as the Field argument. The criteria range should be A15:1316.) 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.) If necessary, apply the Accounting Number Format to cells BIS:B19

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Applications for the Management Life and Social Sciences

Authors: Ronald J. Harshbarger, James J. Reynolds

11th edition

9781337032247, 9781305465183, 1305108043, 1337032247, 1305465180, 978-1305108042

More Books

Students also viewed these Mathematics questions