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
Which QUERY clause is used to filter rows based on a condition?
Answer: WHERE
In the Google Visualization query language, WHERE restricts which rows are returned.
In QUERY, which clause sorts the returned results?
Answer: ORDER BY
ORDER BY defines the sort column and direction (ASC or DESC) for QUERY output.
How does QUERY refer to spreadsheet columns in its query string?
Answer: By column letters like A, B, C
QUERY uses the spreadsheet column letters (Col1 only when the range is an array without letters).
What does QUERY(A:C, "SELECT A, B WHERE C > 100") return?
Answer: Columns A and B for rows where C exceeds 100
SELECT A, B picks those two columns and WHERE C > 100 keeps only rows whose column C is greater than 100.
In a QUERY WHERE clause, how should a text value be enclosed?
Answer: In single quotes, e.g. WHERE B = 'Active'
Text literals inside the query string are wrapped in single quotes so they don't clash with the outer double quotes.
Which keyword after ORDER BY sorts results from highest to lowest?
Answer: DESC
DESC produces a descending sort; ASC (the default) produces ascending.
What advantage does QUERY have over a basic filter for regularly updated data?
Answer: It recalculates automatically as source data changes
QUERY is a live formula, so its output updates automatically whenever the referenced source data changes.
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