please exaplain how you got answers in data table

Item Exam 1 Exam 2 Exam 3 Hypothetical Exam 4 HW 1 HW 2 HW 3 HW 4 Excel 1 Excel 2 Coronavirus Paper Class Participation Sheets WSJ #1 5 WSJ #2 6 WSJ #3 7 WSJ #4 8 WSJ #5 9 WSJ #6 0 1 Not Rounded Final Score 22 Rounded Final Score 23 Letter Grade 24 Weight Score 0.16 0.16 0.16 0.16 0.03 0.03 0.03 0.03 0.03 0.03 0.08 0.05 0.01 0.01 0.01 0.01 0.01 0.01 B 75 70 68 81.1875 90 88 85 90 95 93 90 90 100 100 100 100 100 80.0000 80.00 For your project submission, please use the grades given for a hypothetical student, not your own grade. Exam 4 Score 70 85 90 95 . 80 0 0 0 B 85 0 9 90 10 95 11 100 0 0 0 Instructions: Calculate grade, dropping lowest WSJ grade Use the Round function to round the final grade to 2 decimal placces Use if statements to label final grade as A, B, C, D, or F Use Solver to find to find what grade is the lowest score on Exam 4 needed to earn at least an 80.0% final grade Create a data table showing how the final grade in the class will be based on various exam 4 and HW 4 scores 12 13 14 15 16 17 18 19 20 21 HW 4 Score 0 oooooo 0 0 SOOOOO 75 0 0 0 0 0 80 0 OOO OO OOO 000 OO 0 0 0 0 0 0 0 OOOOO 0 0 0 100 0 OOOO 0 Item Exam 1 Exam 2 Exam 3 Hypothetical Exam 4 HW 1 HW 2 HW 3 HW 4 Excel 1 Excel 2 Coronavirus Paper Class Participation Sheets WSJ #1 5 WSJ #2 6 WSJ #3 7 WSJ #4 8 WSJ #5 9 WSJ #6 0 1 Not Rounded Final Score 22 Rounded Final Score 23 Letter Grade 24 Weight Score 0.16 0.16 0.16 0.16 0.03 0.03 0.03 0.03 0.03 0.03 0.08 0.05 0.01 0.01 0.01 0.01 0.01 0.01 B 75 70 68 81.1875 90 88 85 90 95 93 90 90 100 100 100 100 100 80.0000 80.00 For your project submission, please use the grades given for a hypothetical student, not your own grade. Exam 4 Score 70 85 90 95 . 80 0 0 0 B 85 0 9 90 10 95 11 100 0 0 0 Instructions: Calculate grade, dropping lowest WSJ grade Use the Round function to round the final grade to 2 decimal placces Use if statements to label final grade as A, B, C, D, or F Use Solver to find to find what grade is the lowest score on Exam 4 needed to earn at least an 80.0% final grade Create a data table showing how the final grade in the class will be based on various exam 4 and HW 4 scores 12 13 14 15 16 17 18 19 20 21 HW 4 Score 0 oooooo 0 0 SOOOOO 75 0 0 0 0 0 80 0 OOO OO OOO 000 OO 0 0 0 0 0 0 0 OOOOO 0 0 0 100 0 OOOO 0