Exam 77-882: Microsoft Excel 2010 Core

8. Analyzing and Organizing Data

8.1. Filter data: Filter Lists with AutoFilter

Data: Text Filters

What Do You See? Look at the first row of this spreadsheet.  Each of the labels in the Header Row should have little drop-down arrows. These are the filters.

 

3. Try This: Use an AutoFilter

Click on the City Filter.

Select one city: MyTown.

Click OK to apply the filter.

 

Keep going, please...

Data -> Sort & Filter-> Filter