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