Sort & Filter: A to Z

So, here is a list of clients that bought products from Charlotte's Website. The fields in the Header Row include the name, date, product and amount for the sales.

4. Try This: Sort & Filter the Data
Select the entire spreadsheet.
Go to Home -> Editing->Sort & Filter.

Select: Sort A-Z.

What Do You See? The data is sorted by the first Column. By default, the data is sorted alphabetically. So, the names of the months go from April (A) through September (S)....that's not what most people have in mind.

 

Try Again: Undo the last step and keep going...

Home -> Editing->Sort & Filter->Sort A to Z

graphic1
graphic2

 

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

 

graphic2