Excel 2010

Sorting Data

5 of 5

Challenge!

  1. Open an existing Excel 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, re-order the list to sort by T-Shirt Color (red), then by T-Shirt Color (grey), then by T-Shirt Size, then by Homeroom #.