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

Exam 77-882: Microsoft Excel 2010 Core

8. Analyzing and Organizing Data

8.2. Sort data: Sort & Filter