a$.$ In cell B$18,$ enter a formula to calculate the average commission earned for the sales associate last name entered in cell A$16.($Hint: Use a database function. Use the named range SalesData as the Database argument and the column label Commission Earned as the Field argument. The criteria range should be A$15$:B$16.)$

b$.$ In cell B$19,$ 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 $7$a$.)$

c$.$ If necessary, apply the Accounting Number Format to cells B$18$:B$19.$

d$.$ In cell B$20,$ enter a formula to calculate the number of clients the sales associate had with annual sales reaching the target set in cell B$16.($Hint: This time, use the column label Client as the Field argument. The criteria range should be A$15$:B$16.)$ Remember, the values in the Client field are text values. Use the appropriate function.

e$.$ If necessary, apply the General number format to cell B$20.$