Exam 77-420 Microsoft Excel 2013
3. Create Tables
3.3 Filter and Sort a Table: Sort Records

graphic1

Data -> Sort & Filter-> Sort

graphic2

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

.graphic3