Google Sheets Data Sorting and Filtering Flashcards
7 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Google Sheets Data Sorting and Filtering flashcards as text
When using 'Filter by condition', which option keeps only rows whose cell contains a specific substring?
Answer: Text contains
'Text contains' matches any cell that includes the given substring anywhere in its text.
In the filter menu, 'Filter by values' primarily lets you do what?
Answer: Check or uncheck individual unique values to show or hide
'Filter by values' shows a checklist of the unique entries so you can toggle which ones appear.
Which sort option is available directly from the filter dropdown menu?
Answer: Sort A → Z
The filter dropdown includes Sort A → Z and Z → A for the column directly.
You want to filter using a formula like =G2>AVERAGE(G:G). Where do you enter it?
Answer: Filter by condition > Custom formula is
'Custom formula is' under Filter by condition lets you supply a formula that returns TRUE for rows to keep.
What does the green funnel/filter icon on a column header indicate?
Answer: A filter condition is currently applied to that column
A filled funnel icon signals that an active filter is limiting the rows shown for that column.
After applying a basic filter, how do you return to seeing all rows?
Answer: Data > Remove filter, or clear the column conditions
Choosing Data > Remove filter (or clearing each condition) restores the full, unfiltered view.
Which condition would you use to show only rows where a date column is after 1/1/2026?
Answer: Date is after
'Date is after' filters to rows whose date value falls later than the specified date.
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy