Sorting Data

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

Challenge!

  1. Open an existing Excel 2010 workbook. If you want, you can use this example.
  2. Sort a column in ascending sort ascending or descending sort descending order. If you are using the example, sort by Homeroom #.
  3. Add a second level, and sort it according to cell color, font color, or cell icon. If you are using the example, add a second and third level to sort by the red and grey fonts used in T-Shirt Color.
  4. Add another level, and sort it using a Custom List. If you are using the example, sort by T-Shirt Size in the order of Small, Medium, Large, and X-Large.
  5. Change the sorting priority. If you are using the example, reorder the list to sort by T-Shirt Color (red), then by T-Shirt Color (grey), then by T-Shirt Size, then by Homeroom #.