Why QUERY is Google Sheets' most powerful function - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all columns from the data range A1:C10 using QUERY.

Google Sheets

=QUERY(A1:C10, [1])

Drag options to blanks, or click blank then click option'

A"SELECT *"

B"SELECT A"

C"SELECT A, B"

D"SELECT C"

Attempts:

3 left

💡 Hint

Common Mistakes

Using column letters without quotes

Forgetting the quotes around the query string

Selecting only one column when all are needed

The query string "SELECT *" selects all columns from the range.

2fill in blank

medium

Complete the code to select rows where column B is greater than 50.

Google Sheets

=QUERY(A1:C10, [1])

Drag options to blanks, or click blank then click option'

A"SELECT * WHERE B > 50"

B"SELECT * WHERE B < 50"

C"SELECT * WHERE A > 50"

D"SELECT B WHERE B > 50"

Attempts:

3 left

💡 Hint

Common Mistakes

Using < instead of >

Filtering on the wrong column

Selecting only column B instead of all columns

The query "SELECT * WHERE B > 50" selects all columns but only rows where column B is greater than 50.

3fill in blank

hard

Fix the error in the QUERY formula to correctly select column A and column C.

Google Sheets

=QUERY(A1:C10, [1])

Drag options to blanks, or click blank then click option'

A"SELECT A; C"

B"SELECT A C"

C"SELECT A, C"

D"SELECT A AND C"

Attempts:

3 left

💡 Hint

Common Mistakes

Using spaces instead of commas

Using semicolons or AND keyword

Missing commas between columns

The correct syntax to select multiple columns is to separate them with a comma, like "SELECT A, C".

4fill in blank

hard

Fill both blanks to select column B and order the results by column B descending.

Google Sheets

=QUERY(A1:C10, [1] & " ORDER BY B [2]")

Drag options to blanks, or click blank then click option'

A"SELECT B"

B"ASC"

C"DESC"

D"WHERE B > 0"

Attempts:

3 left

💡 Hint

Common Mistakes

Using ASC instead of DESC for descending order

Forgetting to select the correct column

Adding unnecessary WHERE clauses

The query selects column B with "SELECT B" and orders it descending with "DESC".

5fill in blank

hard

Fill all three blanks to select column A, column C, and filter rows where column C is less than 100.

Google Sheets

=QUERY(A1:C10, "SELECT [1], [2] WHERE [3] < 100")

Drag options to blanks, or click blank then click option'

AA

BB

CC

DD

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting wrong columns

Filtering on the wrong column

Using incorrect comparison operators

The query selects columns A and C, and filters rows where column C is less than 100.