How do I use Excel to solve this $5.($max point deduction: $10)$ Compare the average salary by Rank $($in a separate sheet$)$

a$.$ Copy the raw data in an empty sheet $($HINT: copy raw data from first sheet and paste into second sheet$).$

b$.$ Sort data by rank.

c$.$ Compute average salary by rank using subtotals.

d$.$ Name the sheet as $$Salary by Rank$.$