Apply the SparkLine Style Accent 1, Darker 50 % style.
If needed, apply the Blue, Accent 1 high point marker color.
20 Insert an IF function in column I that displays a $ 500
5.000 bonus if an agent’ s average sales are greater than the average of all sales for the six months. Use two nested AVERAGE functions in the logical _ test argument of the IF function to make the comparison.
21 Create a clustered column chart of the agents and their
6.000 six-month sales, using the chart type that displays the months on the category axis.
Move the chart to a new chart sheet named Sales Chart.
22 Apply the Layout 1 chart layout. 6.000