SELECT clause in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the SELECT clause do in the QUERY function in Google Sheets?

The SELECT clause chooses which columns or data you want to see from your data range. It works like picking specific columns from a table.

beginner

How do you select only the first and third columns from a data range using the SELECT clause?

Use SELECT Col1, Col3 inside the QUERY function to show only the first and third columns.

beginner

Can you use the SELECT clause to rename columns in the output?

No, the SELECT clause only chooses columns. To rename columns, you need to use other functions or manually change headers.

beginner

What happens if you use SELECT * in the QUERY function?

Using SELECT * means you want to select all columns from the data range without filtering any out.

beginner

How do you write a QUERY formula to select columns B and D from data in A1:E10?

Use =QUERY(A1:E10, "SELECT Col2, Col4"). This picks only columns B and D from the range.

In the QUERY function, what does the SELECT clause specify?

A Which columns to show

B Which rows to delete

C How to sort data

D How to format cells

The SELECT clause tells QUERY which columns to display from the data.

What does SELECT * do in a QUERY formula?

A Selects no columns

B Selects only numeric columns

C Selects only the first column

D Selects all columns

SELECT * means select all columns from the data.

How do you select the second column only in a QUERY formula?

A SELECT B

B SELECT 2

C SELECT Col2

D SELECT Column2

You use SELECT Col2 to pick the second column in QUERY.

Can the SELECT clause rename columns in the QUERY output?

A Yes, always

B No, it only selects columns

C Only for text columns

D Only if you use AS keyword

SELECT clause only chooses columns; renaming is not supported in QUERY.

Which of these is a correct SELECT clause to get columns 1 and 3?

A SELECT Col1, Col3

B SELECT 1, 3

C SELECT A, C

D SELECT Column1, Column3

You must use Col1, Col3 to select columns by number.

Explain how the SELECT clause works in the QUERY function in Google Sheets.

Think about picking columns from a table.

Describe how to write a QUERY formula to select specific columns from a data range.

Remember the syntax inside QUERY.

Practice

1. What does the SELECT clause do inside the QUERY function in Google Sheets?

easy

A. It adds new columns to the data.

B. It sorts the data in ascending order.

C. It filters rows based on a condition.

D. It chooses which columns to show from the data.

Solution

1. Step 1: Understand the role of SELECT in QUERY

   The SELECT clause specifies which columns to display from the data range.

2. Step 2: Differentiate from other clauses

   Sorting is done by ORDER BY, filtering by WHERE, and adding columns is not done by SELECT.

3. Final Answer:

   It chooses which columns to show from the data. -> Option D

4. Quick Check:

   SELECT = choose columns [OK]

Hint: SELECT picks columns to show, not rows or sorting [OK]

Common Mistakes:

• Confusing SELECT with WHERE clause
• Thinking SELECT sorts data
• Assuming SELECT adds new columns

2. Which of the following is the correct syntax to select columns A and C using the QUERY function?

easy

A. =QUERY(A1:C10, "SELECT B, D")

B. =QUERY(A1:C10, "SELECT 1, 3")

C. =QUERY(A1:C10, "SELECT A, C")

D. =QUERY(A1:C10, "SELECT A C")

Solution

1. Step 1: Check correct column letters in SELECT

   Columns are referenced by letters like A, B, C. To select columns A and C, use "SELECT A, C" with a comma.

2. Step 2: Verify syntax correctness

   =QUERY(A1:C10, "SELECT A, C") uses correct syntax with comma and column letters. =QUERY(A1:C10, "SELECT 1, 3") uses numbers which is invalid. =QUERY(A1:C10, "SELECT B, D") uses B and D which are wrong columns. =QUERY(A1:C10, "SELECT A C") misses comma between columns.

3. Final Answer:

   =QUERY(A1:C10, "SELECT A, C") -> Option C

4. Quick Check:

   Use column letters with commas in SELECT [OK]

Hint: Use column letters with commas in SELECT clause [OK]

Common Mistakes:

• Using numbers instead of letters for columns
• Omitting commas between columns
• Selecting columns not in the data range

3. Given the data in A1:C4 as:

A | B | C
1 | 2 | 3
4 | 5 | 6
7 | 8 | 9

What will be the output of =QUERY(A1:C4, "SELECT B, C")?

medium

A. 2 3
5 6
8 9

B. B C
2 3
5 6
8 9

C. A B
1 2
4 5
7 8

D. 1 2
4 5
7 8

Solution

1. Step 1: Identify columns B and C data

   Column B values are 2, 5, 8 and column C values are 3, 6, 9 from rows 2 to 4.

2. Step 2: Understand QUERY output format

   QUERY includes headers by default, so output shows header row "B C" followed by data rows.

3. Final Answer:

   B C 2 3 5 6 8 9 -> Option B

4. Quick Check:

   QUERY shows headers and selected columns [OK]

Hint: QUERY outputs headers by default with selected columns [OK]

Common Mistakes:

• Ignoring headers in output
• Selecting wrong columns
• Mixing up row and column data

4. The formula =QUERY(A1:C10, "SELECT A B") returns an error. What is the fix?

medium

A. Add a comma between A and B: "SELECT A, B"

B. Change A and B to numbers: "SELECT 1 2"

C. Remove the SELECT keyword

D. Use lowercase letters: "select a b"

Solution

1. Step 1: Identify syntax error in SELECT clause

   The columns A and B must be separated by a comma in the SELECT clause.

2. Step 2: Correct the syntax

   Adding a comma between A and B fixes the syntax: "SELECT A, B".

3. Final Answer:

   Add a comma between A and B: "SELECT A, B" -> Option A

4. Quick Check:

   Columns must be comma-separated in SELECT [OK]

Hint: Separate columns with commas in SELECT clause [OK]

Common Mistakes:

• Omitting commas between columns
• Using numbers instead of letters
• Removing SELECT keyword

5. You have a table with columns Date (A), Product (B), and Sales (C). You want to use QUERY to show only the Product and Sales columns but sorted by Sales descending. Which formula correctly uses SELECT and ORDER BY?

hard

A. =QUERY(A1:C100, "SELECT B, C ORDER BY C DESC")

B. =QUERY(A1:C100, "SELECT A, B ORDER BY C DESC")

C. =QUERY(A1:C100, "SELECT B, C ORDER BY B DESC")

D. =QUERY(A1:C100, "SELECT B, C ORDER BY A DESC")

Solution

1. Step 1: Identify columns to select

   You want to show Product (B) and Sales (C), so SELECT B, C is correct.

2. Step 2: Sort by Sales descending

   ORDER BY C DESC sorts by Sales column descending.

3. Step 3: Verify full formula correctness

   =QUERY(A1:C100, "SELECT B, C ORDER BY C DESC") correctly combines SELECT and ORDER BY clauses. Other options select wrong columns or order by wrong columns.

4. Final Answer:

   =QUERY(A1:C100, "SELECT B, C ORDER BY C DESC") -> Option A

5. Quick Check:

   SELECT columns + ORDER BY sales DESC = correct [OK]

Hint: Use SELECT for columns, ORDER BY for sorting in QUERY [OK]

Common Mistakes:

• Ordering by wrong column
• Selecting wrong columns
• Missing ORDER BY clause