QUERY Practice Sheet: Ten Exercises With Answers
Learn the Google Sheets QUERY function with ten graded exercises on your own kind of data, an answer key and a 1 to 5 self-score.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Teach me the Google Sheets QUERY function by practice. The sort of data I work with is [DATA_TYPE], with columns like [COLUMN_LIST]. My comfort level with formulas is [SKILL_LEVEL]. I want to use QUERY for [REAL_GOAL]. Create a practice pack in three parts: 1. A small invented sample table of 12 rows matching my kind of data, which I can paste into a sheet. 2. Ten exercises ordered from easy to hard (select columns, where with text, where with numbers, where with dates, order by, limit, group by with sum and count, label and format, pivot, combining two ranges), each with a task sentence I answer before looking. 3. An answer key with the formula for each exercise and one sentence on the trick it teaches, hidden below a line that says "Answers below". After the key, add a self-scoring grid with columns Exercise, I got it first time, I needed a hint, I need to revisit (1 to 5 confidence), and a short rule of thumb on what to practise next for each score range. Use only the sample table columns in all exercises. Keep sentences short and avoid jargon. Mark anything that depends on regional date settings [VERIFY]. Do not skip the answer key or add exercises that need other tools.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.