Please show the steps with formulas. I appreciated!!

The table below shows the scores in three different sections of a class. Given the data below, answer the following questions. A- Sort the data by score in descending order and assign each student an overall rank so that the student with the highest score in the class is ranked 1 and the student with the second highest score is ranked 2, etc. Students with the same score should get the same rank and students with a score below should be ranked 1 below. For instance, if you had the scores 90, 87, 87, 85, the ranks should be 1, 2, 2, 3, not 1, 2, 2,4. (Hint: With the data sorted, you can do this using an IF function) B-Assign everyone a grade based on their score using the scoring rules listed in the "Grade Rules" table. C-You decide you don't like the grade distribution, so instead you decide to give everyone a grade based on their rank. You decide to give students ranked in the top 3 an A, students not in the top 3 but in the top 83 a B, students not in the top 83 but in the top 156 a C, students not in the top 156 but in the top 179 a D, and everyone else an F. D- In the "Counts" table, count the number of students who fall into each section and "Grade from Rank" combination. Section Student Score Overall Rank Grade from Grade from Score Rank Grade Rules Counts Section Grade Count O to 59.99 F 60 to 69.99 D 70 to 79.99 C 80 to 89.99 B 90 to 100 A 1 A 1 B 1 C 1 D 1 F 2A 2B 3 David Simmons 2 Joan Lopez 3 Lawrence Gonzales 2 Carl Bryant 2 Marie Bell 2 Alexander Lowe 1 Angela Henderson 2 Henry Gonzales 1 Andrea Thomas 2 Tina Green 1 John King 2 Bari Beaty 1 Patrick Roberts 2 Luke Stone 2 Lori Bailey 1 Elbert Medina 2 Lori Roberson 2 Diane Grant 1 Rose Rodriguez 3 Erma Warner 3 Taylor Hunter 3 Marguerite Luna 3 Cheyenne Estep 2 Ruby Patterson 3 Guadalupe Baker 3 Jason Johnson 2 Daniel Miller 3 Candice Moody 1 Leonard Rodriquez 76.2 95.4 100 81.8 100 100 89.7 64.7 67.7 66.9 61.5 82.4 61.9 74.2 66.4 69.1 93.8 80.8 100 64 67.2 65.9 62.8 76.4 83.9 59.2 76.9 76 72.8 2C 2D 2 F 3 A 3 B 3 3D 3 F