Go to $$Best Buy Sales Report$$ Worksheet:

In column G$,$ calculate the salespeople's commission based off their Sales Totals using the commission rate found in cell K$12.$ Commission $=$ Sales$*$ Rate.

In column J$,$ use the IF function to calculate the salespeople$$s bonus. If their Sales Total is greater than or equal to the threshold in K$14,$ then they get the bonus in K$16,$ otherwise, they get the bonus in K$15.$ Ensure you use relative and absolute references.

In column I, use the IF Function to show "Long" if the salespeople's years of experience is more than $10$ and "Short" if it is under than $10$

Resize the columns to show all cell contents.

Use conditional formatting to highlight in green fill and dark green text the top five Sales Totals.

Use conditional formatting to highlight in light red fill and dark red text the bottom five Sales Totals. Best Buy SALES REPORT

Apply a blue data bar $($conditional formatting$)$ to the values under Base Salary.