QA only plz with all steps and formula

AB D H MN 0 Q1 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) . 1 2 3 4 5 B - Assign everyone a grade based on their score using the scoring rules listed in the "Grade Rules" table. 6 17 18 19 20 21 22 23 C- You decide you don't like the grade distribution, so instead you decide to give everyone a grady based on their rank. You decide to give students ranked in the top 18 an A, students not in the top 18 but in the top 52 a B, students not in the top 52 but in the top 176 a C, students not in the top 176 but in the top 190 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. based on their rank. You decide to give students ranked in the top 18 an A, students not in the top 18 but in the top 52 a B, students not in the top 52 but in the top 176 a C, students not in the top 176 but in the top 190 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. Grade from Grade from Score Rank Grade Rules Counts 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 + 5 6 7 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 Section Student 3 Gary Wood 1 Michelle Miller 3 Molly Washington 1 Elias Lucas 2 Gloria Wright 2 Jami Mclemore 1 Elizabeth Ward 3 Rosamaria Covert 2 Aaron Spencer 3 Wilma Porter 2 Angelica Craig 3 Julia Roberts 3 Ellan Bedard 2 Casey Murray 3 Cheyenne Estep 3 Paul Peterson 3 Shawn Robinson 1 Gerardo Valdez 3 Gloria Sanchez 1 Anna Williams 1ean Wilson Directions Q1 02 Overall Score Rank 92.8 73.5 74.8 67.1 65.9 82.3 72.9 71.1 70.4 64.1 85.7 65.9 49 83.6 78.3 74.8 75.1 80.2 51.2 60.2 69.2 Q3 04 05 Section Grade 1 A 1B 1 c 1 D 1 F 2 A 2 B 2 C 2D 2 F 3 A 3 B +31C 3D 3F