Exam 77-420 Microsoft Excel 2013 2. Create Cells and Ranges 2.3 Order and Group Cells and Ranges: Sort Order

Data -> Sort & Filter ->Sort Data: Sort Order There is another kind of Sort that can be found on the Data Ribbon. This Sort lets you use one or several criteria. The criteria comes from the names in the Header Row.   5. Try it: Data Sort Select the whole spreadsheet. Go to Data -> Sort & Filter ->Sort. What Do You See? The options include: Add Level Delete Level Copy Level Options There should be a check mark for: My data has headers. Try This, Too: Edit the Sort Options Sort by: Month Sort On: Values Order: Custom List (Remember, A to Z didn't work for Months.) Keep going...