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.