Question: You want to apply subtotals per sport in the data below. What should you do before applying subtotals?

1. Format the data in column E.
2. Format the data in column D.
3. Sort the data in column D.
4. Sort the data in column E.

Answer: The correct answer of the above question is Option C:Sort the data in column D.