[Answer] 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?a. Sort by the data in column Eb. Format the data in column Dc. Sort by the data in column Dd. Format the data in column E