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

graphic2
graphic1

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