# Filtering Data in a List - Exercise

Welcome to our free Intermediate Microsoft Excel 2013 tutorial. This tutorial is based on Webucator's Intermediate Microsoft Excel 2013 Training course.

Filtering Data in a List - Exercise

# Filtering Data in a List

Duration: 10 to 20 minutes.

In this exercise, you will practice filtering data in a list.

1. Open Filter.xlsx from your Excel2013.2/Exercises folder.
2. On Sheet1, filter the list to show only houses in Fayetteville with 3 bathrooms.
3. On Sheet2, filter the list to show only houses costing less than \$100,000.
4. On Sheet3, filter the list to show only houses in Jamesville that have 4 bathrooms and cost less than \$100,000.

## Solution:

1. On Sheet1, filter the list to show only houses in Fayetteville with 3 bathrooms.
1. Select any cell in the list.
2. On the DATA tab, in the Sort & Filter group, click the Filter command:
3. Click the drop-down arrow next to "Town" and de-select everything except Fayetteville, and click OK:
4. Click the drop-down arrow next to "Bathrooms" and de-select everything except 3, and click OK:
2. On Sheet2, filter the list to show only houses costing less than \$100,000.
1. Select any cell in the list.
2. On the DATA tab, in the Sort & Filter group, click the Filter command:
3. Click the drop-down arrow next to "Listing Price," move your mouse over Number Filters, and select Less Than:
4. Fill in "100000" and click OK:
3. On Sheet3, filter the list to show only houses in Jamesville that have 4 bathrooms and cost less than \$100,000.
1. Select any cell in the list.
2. On the DATA tab, in the Sort & Filter group, click the Filter command:
3. Click the drop-down arrow next to "Listing Price", move your mouse over Number Filters, and select Less Than:
4. Fill in "100000" and click OK:
5. Click the drop-down arrow next to "Town" and de-select everything except Jamesville, and click OK:
6. Click the drop-down arrow next to "Bathrooms" and de-select everything except 4, and click OK:

This tutorial is based on Webucator's Intermediate Microsoft Excel 2013 Training Course. We also offer many other Microsoft Excel Training courses. Sign up today to get help from a live instructor.