Excel & Sheets practice: Google Sheets QUERY — Core Syntax

Chapter 18 · 3 questions · included in full access

Question 1 · medium
QUERY: West orders
In K1, use QUERY on A1:I21 to list the OrderID, Rep and Revenue of West orders, highest revenue first, with headers.
Solve it in your browser
Question 2 · hard
QUERY: top 3 reps, labelled
In K1, return the top 3 reps by total Revenue, with the total column headed Q1 Revenue.
Solve it in your browser
Question 3 · medium
Quotes inside QUERY
Why should the filter value in =QUERY(A1:I21, "select A where C = 'West'") be written in single quotes?
Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

QUERY: West orders