Google Sheets Fundamentals - Filtering Data

This video tutorial explains how to sort and filter data in a spreadsheet. It covers setting up filters, filtering by specific values, and applying conditions to filter data. The tutorial also explores advanced filtering options, such as filtering by text conditions and using custom formulas. By the end, viewers will understand how to effectively use filters to manage and analyze data in spreadsheets.

What is the primary purpose of filtering data in a spreadsheet?

• To permanently delete unwanted data

• To sort data in ascending order

• To highlight all data in the spreadsheet

• To display only data that meets specific criteria

Which of the following steps is necessary to create a filter in a spreadsheet?

• Delete all existing data

• Change the font style of the headers

• Go to the data menu and choose create a filter

• Select the entire spreadsheet

How can you reset the data view after applying a filter?

• By changing the spreadsheet theme

• By clearing the filter and selecting all

• By selecting all data and copying it

• By closing the spreadsheet

Which filtering condition would you use to find rows with missing data?

• Text starts with

• Is empty

• Text contains

• Greater than

What happens when you apply a 'text does not contain' filter?

• It sorts the data alphabetically

• It highlights the text that matches the condition

• It shows only the rows that contain the specified text

• It filters out rows containing the specified text