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

SELECT

Answer

ORDER BY

Answer

LABEL

Question 2

In QUERY, which clause sorts the returned results?

Accepted Answer

ORDER BY

Answer

GROUP BY

Answer

PIVOT

Answer

WHERE

Question 3

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

Accepted Answer

By column letters like A, B, C

Answer

By header names in quotes

Answer

By zero-based index numbers

Answer

By named ranges only

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

All columns sorted by C

Answer

Only column C values over 100

Answer

A count of rows over 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

In double quotes inside the string

Answer

In backticks

Answer

No quotes are needed

Question 6

Which keyword after ORDER BY sorts results from highest to lowest?

Accepted Answer

DESC

Answer

ASC

Answer

TOP

Answer

REVERSE

Question 7

What advantage does QUERY have over a basic filter for regularly updated data?

Accepted Answer

It recalculates automatically as source data changes

Answer

It permanently deletes non-matching rows

Answer

It works only on static data

Answer

It disables editing of the source