Only Need TASK 6, please explain thesteps, thanks.

K19 ® fx A B С D F H 1 K L M N 0 P Q 2012 Total Sales by Agent 1 January - June 2 January February March April May June Trends Bonus 3 Avery $ 3,671 $ 2,973 $ 4,017 $ 5,040 $ 4,963 $ 5,497 $ 500 4. Collins $ 1,549 $ 992 $ 2,267 $ 3,201 $ 4,008 $ 3,798 5 Kinsley $ 2,996 $ 6,948 $ 4,205 $ 5,523 $ 6,597 $ 5,147 5 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 3 Shannon $ 1,172 $ 866 $ 2,109 $ 3,385 $ 4,078 $ 3,598 3 0 Bonus $ 600 1 2 3 Task 5 Task 6 4 Create Line sparklines in column H Insert an IF function in column I that displays 5 in the Summary sheet to display a $600 bonus if an agent's average sales are six-month trends for each agent. greater than the average of all sales for the Show the high point in each six months. Use two nested AVERAGE -8 functions in the logical_test argument of 9 the IF function to make the comparison. Use 20 cell reference for Bonus. 2 +3 Task 7 -4 Create a footer with your full 15 name on the left side, the file 26 name in the center, and the 28 Date on the right side of each 9 0 1 2 Task 8 =3 -4 5 6 Now Save the workbook. Rename the Lab Excel file as LastnameFirstname_Lab_1. For example, John Smith's project file name is: SmithJohn_lab_1.