help please asap

Name Q1 Q2 Q3 Q4 Total Due Date Annual Bonus 10,000 12/17/20 2,357 2.807 2,551 153 1.211 109 283 1,344 2.757 2.221 2,092 672 3,737 958 1,669 387 3,978 1,144 2,897 678 3.174 953 440 987 2,258 1,649 465 395 128 839 732 2,335 1.634 1,129 1.789 3,614 1,018 2,679 3,638 956 845 1,916 2,475 TT- 594 Longenecker, Sean Desai, Christopher Matthews, Rachel Dodds, Westley Wadsworth, Lydia Rosene, Jacob Walton, Erin Wadsworth, Jeffrey Matthews, Aaron Barmer, Qian Dodds, Lindsey Goldberg, William Yang, Kaleng Blum, Elizabeth Kelly, Kali Goldfarb, Benjamin knizner, Michael Walton, Jazmine Weddington, Eric Badgett, Joseph Barksdale, Brian Falsy, Rigsbee Goldberg, Benjamin Folk, Christopher Dodds, Ashley Zhao, Zachary Williams, Jace Zhao, Shane Barclay. Alicia Lloyd, Christopher Davis, Chad Folk, Paul Badgett, Max Khader, Maile 6,210 9,375 7,131 5,929 7,462 7,064 6,191 7,631 7.777 6,621 8,137 5.137 8,921 7,312 6,429 5.344 10.16 8.245 3,006 8,963 7,967 5.527 6,949 8,311 6,440 9,820 9,683 10,167 3.226 2.734 255 1.802 1.750 3,784 167 3.937 3.168 395 1,186 3,551 2,084 2,314 3,112 3,480 1.470 3,047 6431 379 645 1.909 543 2,817 3,153 1,767 3,152 2.875 3.790 1.420 2,577 2.524 2.189 2.358 3.503 441 54 3,082 2.929 Date Report Quarter Turned In Bonus 12/17/20 3.000 12/21/20 12/4/20 12/2/20 12/29/20 12/25/20 12/13/20 12/2/20 12/2/20 12/12/20 12/15/20 12/30/20 12/31/20 12/31/20 12/5/20 12/27/20 12/26/20 12/29/20 12/31/20 12/15/20 12/2/20 12/1320 12/30/20 12/8/20 12/27/20 12/1/20 12/20/20 12/21/20 12/9/20 12/13/20 12/1/20 12/24/20 12/17/20 12/12/20 833 3,062 190 2,034 1,201 291 756 3.278 2,008 173 3,345 1,435 1,803 1,093 2,896 959 3,059 3.558 9N4 3.206 1,611 1.450 2,672 1,426 1,523 1,929 237 654 3,924 3,112 3,861 1,302 967 3,447 1,486 3,761 1.279 3.612 3.411 3,170 1,447 1.643 2.011 2.571 351 1,081 2.511 2,357 992 1,666 2,146 3.409 7.056 7,194 9,859 8,300 11.124 11.749 Problem 5.2 Conditional Formatting Step 1: In worksheet "Part2" there is a list of salespersons and their quarterly output. It is your job to assess the data for anyone who receives a bonus. Employees get a 10% bonus of their total sales if they have total annual sales above $10,000. Employees also get a quarterly bonus of 3% if a single quarters sale is above $3,000. You are to use conditional formatting to: i) If an employee gets a quarterly bonus, the quarter in which they received the bonus, should be highlighted light yellow. ii) If an employee gets an annual bonus the Total column should be highlighted light green ii) The top 10% of total earning employees should be marked with a greed dot icon in their total column. You must use conditional formatting to complete these tasks. Step 2: There is also a column for when each person turned in their sales report. You are to use conditional formatting such that if the user turned in their report after 12/17/2020 a red icon with an X is placed in the cell, and if they turned it in on or before 12/17/2020 a green icon with a check is placed in that cell. (10 points) Name Q1 Q2 Q3 Q4 Total Due Date Annual Bonus 10,000 12/17/20 2,357 2.807 2,551 153 1.211 109 283 1,344 2.757 2.221 2,092 672 3,737 958 1,669 387 3,978 1,144 2,897 678 3.174 953 440 987 2,258 1,649 465 395 128 839 732 2,335 1.634 1,129 1.789 3,614 1,018 2,679 3,638 956 845 1,916 2,475 TT- 594 Longenecker, Sean Desai, Christopher Matthews, Rachel Dodds, Westley Wadsworth, Lydia Rosene, Jacob Walton, Erin Wadsworth, Jeffrey Matthews, Aaron Barmer, Qian Dodds, Lindsey Goldberg, William Yang, Kaleng Blum, Elizabeth Kelly, Kali Goldfarb, Benjamin knizner, Michael Walton, Jazmine Weddington, Eric Badgett, Joseph Barksdale, Brian Falsy, Rigsbee Goldberg, Benjamin Folk, Christopher Dodds, Ashley Zhao, Zachary Williams, Jace Zhao, Shane Barclay. Alicia Lloyd, Christopher Davis, Chad Folk, Paul Badgett, Max Khader, Maile 6,210 9,375 7,131 5,929 7,462 7,064 6,191 7,631 7.777 6,621 8,137 5.137 8,921 7,312 6,429 5.344 10.16 8.245 3,006 8,963 7,967 5.527 6,949 8,311 6,440 9,820 9,683 10,167 3.226 2.734 255 1.802 1.750 3,784 167 3.937 3.168 395 1,186 3,551 2,084 2,314 3,112 3,480 1.470 3,047 6431 379 645 1.909 543 2,817 3,153 1,767 3,152 2.875 3.790 1.420 2,577 2.524 2.189 2.358 3.503 441 54 3,082 2.929 Date Report Quarter Turned In Bonus 12/17/20 3.000 12/21/20 12/4/20 12/2/20 12/29/20 12/25/20 12/13/20 12/2/20 12/2/20 12/12/20 12/15/20 12/30/20 12/31/20 12/31/20 12/5/20 12/27/20 12/26/20 12/29/20 12/31/20 12/15/20 12/2/20 12/1320 12/30/20 12/8/20 12/27/20 12/1/20 12/20/20 12/21/20 12/9/20 12/13/20 12/1/20 12/24/20 12/17/20 12/12/20 833 3,062 190 2,034 1,201 291 756 3.278 2,008 173 3,345 1,435 1,803 1,093 2,896 959 3,059 3.558 9N4 3.206 1,611 1.450 2,672 1,426 1,523 1,929 237 654 3,924 3,112 3,861 1,302 967 3,447 1,486 3,761 1.279 3.612 3.411 3,170 1,447 1.643 2.011 2.571 351 1,081 2.511 2,357 992 1,666 2,146 3.409 7.056 7,194 9,859 8,300 11.124 11.749 Problem 5.2 Conditional Formatting Step 1: In worksheet "Part2" there is a list of salespersons and their quarterly output. It is your job to assess the data for anyone who receives a bonus. Employees get a 10% bonus of their total sales if they have total annual sales above $10,000. Employees also get a quarterly bonus of 3% if a single quarters sale is above $3,000. You are to use conditional formatting to: i) If an employee gets a quarterly bonus, the quarter in which they received the bonus, should be highlighted light yellow. ii) If an employee gets an annual bonus the Total column should be highlighted light green ii) The top 10% of total earning employees should be marked with a greed dot icon in their total column. You must use conditional formatting to complete these tasks. Step 2: There is also a column for when each person turned in their sales report. You are to use conditional formatting such that if the user turned in their report after 12/17/2020 a red icon with an X is placed in the cell, and if they turned it in on or before 12/17/2020 a green icon with a check is placed in that cell. (10 points)