D E F GH 1 Question 3: Conditional Formatting and the IF Function 2 Directions: Avl. Points: Your Points: 3 1) Use an IF function to display a $5000 bonus if the salesperson sold over 4 500 units (use a cell reference for the bonus amount of 5000, located in cell A11) 5 Display a 0 if sales are 500 or under. 6 12) Conditionally format the sales amounts to highlight all of the values in the range that are less than the value in cel A12 in a light red fill with dark red text. (be sure to use a cell reference when setting up the formatting) Total: 7 5,000