7.5 Filtering

Filtering is a process of working with lists. Filtering can be used to display specific rows of information from a list; for example, top 10 sales, members with the same name, or specific records.

Spreadsheets exercise 6

Filtering

Skills practised
  • Opening a file
  • Applying a filter
  • Renaming a filter
  1. Open the Inventory workbook file available in exercise 3.
  2. Click on any cell in the list.
  3. Click on the FILTER button on the DATA tab. The filter buttons appear at the top of each column in the list.
    TS0730b
  4. Click on the filter button at the right of the NAME cell.
  5. Click on SELECT ALL to clear the tick – for Google Sheets, click on CLEAR – then click on MP3 RADIO and OK. Only those rows with this in the NAME column will be displayed. Notice that the filter button now has a small filter symbol on it to indicate that it is this column where the filter is applied.
    P0731
  6. Click on the FILTER button for NAME again and click on SELECT ALL at the top of the list to display all records, then OK.
  7. Click on the filter button for SUPPLIER.
  8. Click on SELECT ALL to clear the tick.
    For Google Sheets, click on CLEAR, then click on PANASONIC and OK.
  9. Click on the filter button again and repeat the process with another supplier.
  10. Repeat to click on each of the suppliers. Which supplier supplies the greatest variety of items?
  11. Click on the FILTER button in the ribbon to turn the filters off.
    For Google Sheets, click on DATA then TURN OFF FILTER.
  12. Save and close the file.