# Free Excel skills test

> Six real tasks in a live spreadsheet, graded the moment you submit. Get your level and what to practice next. No signup.

Source: https://spreadsheetpractice.com/excel-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 [Excel skills test](https://spreadsheetpractice.com/excel-skills-test).

## What the test covers

1. Totals with SUM, practiced in [SUM, AVERAGE, MIN, MAX & COUNT](https://spreadsheetpractice.com/learn/sum-average-min-max-count)
2. Counting with COUNTIF, practiced in [COUNTIF & SUMIF](https://spreadsheetpractice.com/learn/countif-sumif)
3. Multi-condition totals, practiced in [COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs)
4. Lookups with XLOOKUP, practiced in [XLOOKUP](https://spreadsheetpractice.com/learn/xlookup)
5. Two-way lookups, practiced in [INDEX & MATCH](https://spreadsheetpractice.com/learn/index-match)
6. Dynamic arrays, practiced in [FILTER](https://spreadsheetpractice.com/learn/filter-function)

## Levels

| Score | Level | What it means |
|---|---|---|
| 0–1 of 6 | Getting started | Start at lesson 1. The free path covers what you missed. |
| 2–3 of 6 | Working knowledge | You have the basics. Focus on conditional totals and lookups next. |
| 4–5 of 6 | Proficient | Solid. Close the gaps below, then try the interview capstone. |
| 6 of 6 | Advanced | Top marks. Go straight to dynamic arrays, finance and the capstones. |

## Preparing for a job test?

- [Financial analyst Excel test](https://spreadsheetpractice.com/excel-test/financial-analyst)
- [Accountant Excel test](https://spreadsheetpractice.com/excel-test/accountant)
- [Administrative assistant Excel test](https://spreadsheetpractice.com/excel-test/administrative-assistant)
- [Data analyst Excel test](https://spreadsheetpractice.com/excel-test/data-analyst)
- [Operations analyst Excel test](https://spreadsheetpractice.com/excel-test/operations-analyst)
- [Marketing analyst Excel test](https://spreadsheetpractice.com/excel-test/marketing-analyst)
- [HR analyst Excel test](https://spreadsheetpractice.com/excel-test/hr-analyst)
- [Sales analyst Excel test](https://spreadsheetpractice.com/excel-test/sales-analyst)
- [Project manager Excel test](https://spreadsheetpractice.com/excel-test/project-manager)

---

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