Sorting Data

The Excel sort function is useful for rearranging data. When working in Excel sorting data can quickly reorganize content too.


  1. Open our practice workbook.
  2. Click the Challenge tab in the bottom-left of the workbook.
  3. For the main table, create a custom sort that sorts by Grade from Smallest to Largest and then by Camper Name from A to Z.
  4. Create a sort for the Additional Information section. Sort by Counselor (Column H) from A to Z.
  5. When you're finished, your workbook should look like this:

    Sorting Challenge