$7)$ Analysis: No changes should be made to the table and how it is organized to get the results required. Use the most efficient$/$effective commands to complete the required work.

Review the worksheet labeled $7-$Analysis which provides some information about a real estate agency. Calculate the YTD Commission $($commission rate$*$YTD sales$),$ Over$/$Under Quota $($YTD Sales$/$ Yearly Sales Quota$)$ status, and Standing for each agent. The Standing should be determined by the information provided below on quotas:

Over$/$Under Quota Standing Over$/$Under Quota Standing Over$/$Under Quota Standing

$0-59\%$ Tin $60-79\%$ Bronze $80-99\%$ Silver

$100-124\%$ Gold $>=125\%$ Platinum

Apply an appropriate conditional formatting $($e$.$g$.$ Icon Sets$>>$ Ratings$>>5$ Ratings i$.$e$.$ the $5$ bar graphs$)$ for the results in Over$/$Under Quota.

In addition, perform calculations for the items specified in cells M$20$ through M$26.$ Your results should be in the corresponding cells in column O$.$ Note that while a name has been provided in cell O$25,$ the YTD Commission should calculate correctly for any agent$$s name.