Sort the Data

Microsoft Excel has data tools to analyze data. What does our product inventory look like? How many movies are new?

 

5. Try it: Sort the Data

Select the entire spreadsheet.

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

 

 

What Do You See? You will be prompted to select the Sort criteria.

Sort by: Year

Sort on: Values

Order: Largest to Smallest

 

Click OK. Keep going...

Exam 77-882: Microsoft Excel 2010 Core

8. Analyzing and Organizing Data

8.2. Sort data

Data ->Sort & Filter->Sort