# Free Google Sheets skills test

> Six real tasks in a live sheet that works like Google Sheets, graded the moment you submit. Get your level and what to practice next. No signup.

Source: https://spreadsheetpractice.com/google-sheets/skills-test · Updated October 29, 2026

## How it works

- 6 tasks, easiest first, about 10 minutes
- You type real formulas into a live grid; each answer is graded instantly and re-checked on changed data
- Skip anything you don't know
- At the end: your level, and the lesson to start with for each task you missed

Take it at [Google Sheets skills test](https://spreadsheetpractice.com/google-sheets/skills-test).

## What the test covers

1. Totals that grow with the data, practiced in [Formulas in Google Sheets](https://spreadsheetpractice.com/google-sheets/learn/formulas-in-google-sheets)
2. Multi-condition totals, practiced in [COUNTIF, SUMIF and the IFS versions](https://spreadsheetpractice.com/google-sheets/learn/countif-sumif)
3. Lookups with XLOOKUP, practiced in [VLOOKUP and XLOOKUP in Google Sheets](https://spreadsheetpractice.com/google-sheets/learn/vlookup-xlookup)
4. FILTER with two conditions, practiced in [FILTER and SORT, the Sheets way](https://spreadsheetpractice.com/google-sheets/learn/filter-and-sort)
5. ARRAYFORMULA, practiced in [ARRAYFORMULA: one formula for the whole column](https://spreadsheetpractice.com/google-sheets/learn/arrayformula)
6. QUERY with group by, practiced in [QUERY: group by, totals and labels](https://spreadsheetpractice.com/google-sheets/learn/query-group-by)

## Levels

| Score | Level | What it means |
|---|---|---|
| 0–1 of 6 | Getting started | Start with the free Sheets essentials track. It covers what you missed. |
| 2–3 of 6 | Working knowledge | You have the basics. Conditional totals, lookups and FILTER come next. |
| 4–5 of 6 | Proficient | Solid. Close the gaps below, then learn ARRAYFORMULA and QUERY properly. |
| 6 of 6 | Advanced | Top marks. Go straight to the QUERY lessons and the capstone. |

Also: [Google Sheets interview questions](https://spreadsheetpractice.com/google-sheets/interview-questions) · [Excel skills test](https://spreadsheetpractice.com/excel-skills-test)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
