Google Sheets Test Google Sheets Data Sorting and Filtering 3

Question 1

Which QUERY clause is used to filter rows based on a condition?

Accepted Answer

WHERE

Answer

In the Google Visualization query language, WHERE restricts which rows are returned.

Question 2

In QUERY, which clause sorts the returned results?

Accepted Answer

ORDER BY

Answer

ORDER BY defines the sort column and direction (ASC or DESC) for QUERY output.

Question 3

How does QUERY refer to spreadsheet columns in its query string?

Accepted Answer

By column letters like A, B, C

Answer

QUERY uses the spreadsheet column letters (Col1 only when the range is an array without letters).

Question 4

What does QUERY(A:C, "SELECT A, B WHERE C > 100") return?

Accepted Answer

Columns A and B for rows where C exceeds 100

Answer

SELECT A, B picks those two columns and WHERE C > 100 keeps only rows whose column C is greater than 100.

Question 5

In a QUERY WHERE clause, how should a text value be enclosed?

Accepted Answer

In single quotes, e.g. WHERE B = 'Active'

Answer

Text literals inside the query string are wrapped in single quotes so they don't clash with the outer double quotes.

Google Sheets Test Practice Test