Exam 77-882: Microsoft Excel 2010 Core

8. Analyzing and Organizing Data

8.2. Sort data

Data -> Sort & Filter-> Sort

Data: Sort then Subtotal

The key to making the Subtotal function work is to match, match, match. You need to Sort and Subtotal by the same field. Before you create a Subtotal you need to Sort the data.

 

1. Try it: Sort the Data

Select the entire spreadsheet.

Go to Data -> Sort & Filter-> Sort.

Sort by: City.

Sort On: Values.

Order: A to Z.

Click OK.

 

Keep going...