If 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?

  • Sort by the data in Column E.
  • Format the data in Column D.
  • Sort by the data in Column D.
  • Format the data in Column E.

The correct answer is:

  • Sort by the data in Column D.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers