INLS161-001 Fall 2021

Tools for Information Literacy




Filtering practice


According to Microsoft

Use filters to temporarily hide some of the data in a table, so you can focus on the data you want to see.

Demonstrate facility with a number filter

  1. Filter the data on the 15-Filter Disabled Workers worksheet to find the bottom three Congressional Districts in terms of Disabled Workers
  2. Do not sort the results. Simply show the results of filtering out all but the bottom three districts.

Filter the Disabled workers column to show the bottom three Congressional Districts

relative number filter multi-level filter another multi-level filter

back to top

Filter number and text values

Demonstrate facility with a number filter, after having used an exclusion filter to show only one subset of data

  1. Use a multilevel filter on the 16-Filter Language Preferences worksheet to find out which of the Spoken Languages whose names start with the letter A only
  2. had Receipt Count (excluding 53rd week) between 1000 and 4000

The first step above is a text filter, in which one uses the begins with ... function in the dialog box.

Having filtered that column, we use a second filter on a second column. This will be a number filter, in which one uses the between ... function in the dialog box.

relative number filter multi-level filter another multi-level filter

back to top

another combined filter

Again, demonstrate facility with a number filter, after having used an exclusion filter to show only one subset of data.

  1. Use a multilevel filter on the 17-Filter Year&ResidentialCust worksheet to find out which of the Month of PeriodEndDate only in March
  2. had an above average ResidentialCustomerCount

The first step above is a simple select filter, in which one selects the value one desires from a list of possibilities.

Having filtered that column, we use a second filter on a second column. This will be a number filter, in which one uses the above average ... function in the dialog box.

relative number filter multi-level filter another multi-level filter

back to top

Copyright © R.E. Bergquist 2014- | Last Updated on | Powered by w3.css