A $-$ Sort the data by section then by score in descending order and assign each student a section

rank so that the student with the highest score in each section 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 two nested IF functions$)(7\mathrm{.}5$ points$)$