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

graphic3
graphic1

Data -> Sort & Filter-> Sort

Data: Sort Then Subtotal

This Subtotal will calculate the sum of the amount each Sales Rep sold. So, Sort by Sales Rep and Subtotal by Sales Rep.

 

2. Try it: Sort the Data

Select the entire spreadsheet.

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

Sort by: Sales Rep.

Sort on: Values

Order: A-Z.

Click OK.

 

What Do You See? The data will be sorted by the four Sales Reps: Alex, Connie, Elizabeth and Niki.

 

Keep going...

graphic2