Question: In the worksheet below, you want to use Data > Subtotal to show a subtotal value per sport. What must you do BEFORE applying the Subtotal function?

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

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