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.