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.

graphic3

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...

graphic1
graphic2

 

 

 

  .