QUERY function basics in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the QUERY function do in Google Sheets?

The QUERY function lets you ask questions about your data, like filtering or sorting, using a simple language similar to SQL.

beginner

What is the basic syntax of the QUERY function?

QUERY(data, query, [headers]) where:<br>- data: the range of cells to query<br>- query: the text string with your question<br>- headers: optional number of header rows in data

beginner

In QUERY, how do you select only columns A and C from a data range?

Use SELECT A, C in the query string to pick only columns A and C.

beginner

How do you filter rows where column B is greater than 100 using QUERY?

Use WHERE B > 100 in the query string to show only rows where column B has values over 100.

beginner

What does the optional third argument in QUERY do?

It tells QUERY how many header rows your data has, so it knows which rows to treat as labels and not data.

What is the correct way to start a QUERY function in Google Sheets?

A =QUERY(data, "SELECT *")

B =QUERY(data, SELECT *)

C =QUERY(data, 'SELECT *')

D =QUERY(data, SELECT "*")

The query string must be inside double quotes within the formula, so =QUERY(data, "SELECT *") is correct.

Which part of QUERY specifies the data to analyze?

A The query string

B The data range

C The headers argument

D The output format

The first argument is the data range where QUERY looks for information.

How do you tell QUERY to only show rows where column C equals 'Apple'?

A "WHERE C = Apple"

B "WHERE C == 'Apple'"

C "WHERE C = 'Apple'"

D "WHERE C = \"Apple\""

Text values in QUERY must be inside single quotes inside the double-quoted query string.

What does SELECT * mean in a QUERY?

A Select all columns

B Select no columns

C Select only the first column

D Select only numeric columns

The asterisk (*) means select all columns from the data.

If your data has 1 header row, what should the third argument in QUERY be?

A 0

B It is not needed

C 2

D 1

The third argument tells QUERY how many header rows to skip; 1 means one header row.

Explain how to use the QUERY function to filter data by a condition.

Think about how to ask a question like 'show me rows where...'

Describe the role of the third argument in the QUERY function and why it matters.

Consider how QUERY treats the first rows of your data.