Filtering Data in a List - Exercise

Contact Us or call 1-877-932-8228
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:
Next