SELECT clause in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all columns from the range A1:C5.

Google Sheets

=QUERY(A1:C5, "SELECT [1]")

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

A*

BA

C1

DALL

Attempts:

3 left

💡 Hint

Common Mistakes

Using column letters like 'A' instead of '*' to select all columns.

Using numbers or words like 'ALL' which are not valid in QUERY SELECT.

The asterisk (*) in the SELECT clause means to select all columns.

2fill in blank

medium

Complete the code to select only column B from the range A1:C10.

Google Sheets

=QUERY(A1:C10, "SELECT [1]")

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

AB

BA

CC

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using '*' which selects all columns instead of just column B.

Using column numbers or letters other than B.

To select only column B, use 'B' in the SELECT clause.

3fill in blank

hard

Fix the error in the SELECT clause to select columns A and C from A1:C10.

Google Sheets

=QUERY(A1:C10, "SELECT [1]")

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

AA&C

BA C

CA, C

DA;C

Attempts:

3 left

💡 Hint

Common Mistakes

Using spaces, semicolons, or ampersands instead of commas to separate columns.

Columns must be separated by a comma in the SELECT clause.

4fill in blank

hard

Fill both blanks to select columns A and B from range A1:D10 and order by column B.

Google Sheets

=QUERY(A1:D10, "SELECT [1] ORDER BY [2]")

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

AA, B

BB

CC

DD

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong column letters in SELECT or ORDER BY.

Not separating columns with commas.

Select columns A and B separated by a comma, then order by column B.

5fill in blank

hard

Fill all three blanks to select columns A and C, filter where B > 10, and order by C.

Google Sheets

=QUERY(A1:D20, "SELECT [1] WHERE [2] > 10 ORDER BY [3]")

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

AA, C

BB

CC

DD

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong columns in SELECT, WHERE, or ORDER BY.

Forgetting commas between selected columns.

Select columns A and C, filter rows where column B is greater than 10, then order by column C.