Sort the AccountReps table first in ascending order by the name of the account rep and then in descending order by total sales so Bao can quickly identify the top sellers for each rep.

Each account rep is assigned to a tier, which determines whether they receive a salary bonus. Bao wants to list the tier for each account rep according to the Bonus Tiers data in the range $K5$:$L9.$

In cell $H11,$ enter a formula using the VLOOKUP function. Use a structured reference to the Eval Score $($cell G$11)$ as the lookup value. Use absolute cell references to the Bonus Tiers data $($range K$6$:L$9)$ as the table arrax. Use the Tier column $($column $2)$ as the col index num. Do not enter a value for the optional range lookup argument. If Excel does not copy the formula automatically, fill the range $H12$:$H29$ with the formula in cell H$11.($Hint: To avoid an #SPILL error, enable implicit intersection by placing the This Row specifier $($@ character$)$ in front of field names.$)$

Murray Medical awards a bonus of $5\%(\mathrm{.}05)$ to account reps who earn Platinum$-$tier ratings from their clients. In cell I$11,$ enter a formula using the IF function and structured references that tests whether the value in the Tier field is equal to "Platinum". If it is$,$ multiply the value in the Total Sales field by $0\mathrm{.}05.$ Otherwise, enter $0($zero$)$ in the cell. If Excel does not copy the fermula automatically, fill the range I$12$:I$29$ with the formula in cell I$11.($Hint: To avoid an #SPILL error, enable implicit intersection by