H I J K L M N O P Q R S T U V 2012 Total Sales by Agent A B C D E F G 2012 Total Sales by Agent January - June January February March April May June Avery $ 3,671 $ 2,973 $ 4,017 $ 5,040 $ 4,963 $ 5,497 Collins $ 1,549 $ 992 $ 2,267 $ 3,201 $ 4,008 $ 3,798 Kinsley $ 2,996 $ 6,948 $ 4,205 $ 5,523 $ 6,597 $ 5,147 McDonnough $ 2,003 $ 4,190 $ 3,496 $ 1,975 $ 2,936 $ 3,498 Ross $ 4,038 $ 2,064 $ 7,015 $ 6,832 $ 5,971 $ 5,497 Shannon $ 1,172 $ 866 $ 2,109 $ 3,385 $ 4,078 $ 3,598 Trends Bonus Bonus $ 600 Task 5 Task 6 Create Line sparklines in column H in the Summary sheet to display six-month trends for each agent. Show the high point in each sparkline. Insert an IF function in column I that displays a $600 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. Use cell reference for Bonus