Question $3$: Conditional Formatting and the IF Function

Directions:

Use an $$F function to display a $$5000$ bonus if the salesperson sold over $500$ units $($use a cell reference for the bonus amount of $5000,$ located in cell A$11)$ Display a $0$ if sales are $500$ or under.

Conditionally format the sales amounts to highlight all of the values in the range tha are less than the value in cell A$12$ in a light red fill with dark red text. $($be sure to use a cell reference when setting up the formatting$)$ Avl. Points: Your Points:

$6$

$2$

Total:

$8$