Data -> Sort & Filter-> Sort

Exam 77-882: Microsoft Excel 2010 Core

8. Analyzing and Organizing Data

8.2. Sort data

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