Excel 2013

Challenge!

1. Open an existing Excel workbook. If you want, you can use the Lesson 18 Practice Workbook.
2. Sort a worksheet in ascending  or descending order. If you are using the example, sort by Homeroom # (column A).
3. Sort a cell range. If you are using the example, sort the cell range in the cell range G3:H7 from highest to lowest by Orders (column H).
4. Add a level to the sort, and sort it by cell color, font color, or cell icon. If you are using the example, add a second level to sort by cell color in column E.
5. Add another level, and sort it using a custom list. If you are using the example, create a custom list to sort by T-Shirt Size (column D) in the order of Small, Medium, Large, and X-Large.
6. Change the sorting priority. If you are using the example, reorder the list to sort by T-Shirt Size (column D), Homeroom # (column A), and Last Name (column C).