Excel Chapter 3 Use salary Summary file to complete this assignment Add the system's date to cell A3 using a function we discussed in class, and format the cell as shown in the picture below Format the titles as shown in the picture below. To calculate Commission multiple the Sales by the Commission Rate and use absolute cell referencing when appropriate . To determine the Bonus, create an IF function If Sales figures are greater than 21 500 then Bonus should equal to 500, otherwise it should equal to 0. Total Compensation is the sum of Commission and Bonus. - Format all the values as shown in the picture. Calculate and format the functions at the top of the table. Add sparklines to column F as shown in the picture. 1 2 Laurales Herbs and Spices Sales and Compensation Thursday, February 14, 2019 H 3 4 5 6 7 8 9 Total Average Median Highest Lowest Sales Compensation $ 394.193.00 $ 4.658.95 23.199.59 1,303.47 22,924.00 3.938.60 33.903.00 1,648.00 12,320.00 1.840.00 10 11 12 Commission Rate 13 15% 14 Nam Comission Bonus Tel Competition 500 1.18 3,345 1.578 1.NO 5,086 4,583 1.202 8.307 4,696 3,5 1.17 1.500 3.580 500 500 15 Anderson 16 Antonetti 17 Belitti 18 Caprio 9 chi 20 Cloutier 21 Fernandez 22 Hernandez 23 Hutchins 24 Jackson 25 Johnson 20 Lee 21 Lin 28 May * Nguyn 20 Ochoa 31 Patel 32 12,320 22.299 12,523 12,932 23.09 10,550 21,345 22,045 31,309 29,505 25,340 13.500 32.950 23,950 22,924 25,900 21.092 500 500 500 500 4436 3,101 2,025 3.202 1.802 3,16 49 4101 2,035 5.643 403) 2.99 2,593 149 300 500 500 500 3,104 2,154 34 in the graph D E G H Laurales Herbs and Spices 2 January Sales and Compensation 3 Compensation Bonus Total Compensation Sales 5 Total 6 Average 7 Median 8 Highest 9 Lowest 10 11 Commission Rate 0.15 12 13 Name Sales Commission 14 Anderson 12,320 15 Antonetti 22,299 16 Belitti 12,523 17 Caprio 12,932 18 Chu 33,909 19 Cloutier 30,550 20 Fernandez 21,345 21 Hernandez 22,045 22 Hutchins 31,309 23 Jackson 29,505 24 Johnson 25,340 25 Lee 13,500 26 Lin 32,950 27 Maya 23,950 28 Nguyen 22,924 29 Ochoa 25,900 30 Patel 21,092 31 32 33