Excel assessment test: free practice for job applications
Twelve hands-on tasks in 20 minutes, covering the topics that employers tend to check in an Excel test. No sign-up, and you get a breakdown by topic at the end.
This is a practice test made by LearnThisNext. It is not the official test of any employer, recruiter or testing company. It covers the kind of tasks that typically appear in Excel tests for office jobs.
How the practice test works
- 12 tasks, each in a spreadsheet that works like Excel. You type real formulas, sort and filter a list, build a PivotTable or a chart.
- 20 minutes on the clock, shown at the top of the test.
- No hints and no solutions, just like the real thing. If a formula is missing the = sign or the function the task asks for, you can fix it without penalty.
- At the end you see your score, which topics you handled well and which need work, each linked to the matching lesson.
- No account needed. Your result is not stored or shared.
Every run draws new tasks with different data, so taking it again measures your skills rather than your memory of the last attempt.
What an Excel test for a job usually covers
There is no single standard Excel assessment. Some employers send a workbook to complete at home, some hand you a laptop during the interview, and others use an online test with a timer. The skills they look for overlap a lot, because they come from everyday office work. These are the areas in this practice test:
| Skill | Typical task |
|---|---|
| SUM and basic arithmetic | total the sales, multiply price by quantity |
| Absolute references | fill a formula down that points to one fixed cell |
| Percentages | share of the total, change versus last year |
| IF | flag each rep as "on target" or "below target" |
| COUNTIF and SUMIF | count orders for one region, sum costs per department |
| VLOOKUP and XLOOKUP | pull the price for a product code from a second table |
| Sort and filter | rank a list by revenue, show only one city |
| PivotTable or chart | summarize revenue by region or plot it as a column chart |
| Dates | due dates, months, working days |
| Text | join first and last names, extract part of an ID |
XLOOKUP is available in Excel 2021, Excel 2024 and Microsoft 365. If the company still runs an older version, VLOOKUP is the safe choice. In this test either one counts unless a task names a specific function.
What employers are really checking
Excel assessments rarely test obscure functions. The person reviewing your work wants to know whether you can be trusted with real data:
- Formulas, not typed numbers. A hard-coded result breaks as soon as the data changes. Our checker also runs your formula on hidden, changed data, so a typed answer will not pass.
- References that survive fill-down. A missing dollar sign is one of the most common reasons a formula works in the first row and fails in the rest.
- The right tool for the job. SUMIF instead of adding cells one by one, a lookup instead of searching by eye.
- Working under time pressure. A timer quickly shows which skills are solid and which you still have to think about.
English or German Excel
The test accepts formulas in both languages, with commas or semicolons, so =SUMIF(A2:A9,"North",C2:C9) works just as well as the German version. That helps if you are applying to an international team. If you are unsure which version the employer uses, it is worth asking before the test day.
How to prepare in a week
Take the test once without preparing. Use the breakdown to pick the two or three weakest topics and work through those lessons until you can solve their exercises without hints. Then take a fresh run of the test and compare. If you want a quick overall picture first, the shorter Excel skills test estimates your level and suggests where to start.
Frequently asked questions
Is this Excel assessment test free?
Yes. No account, no payment, and you can take it as often as you like. Each run has new tasks.
Are these the questions from a real company's test?
No. We do not copy questions from any employer or testing provider. The tasks are our own, written in the style of everyday office work, and cover the topics that often come up in Excel tests.
Is my score saved?
No. Only you see the result, right after the test. Even when you are logged in, the test does not change your course progress.
Do I get a certificate?
Not for this practice test. A certificate with a verification link comes with the final test at the end of the learning path. It is issued by LearnThisNext, not by Microsoft.
How good does my Excel need to be for an office job?
The job ad usually tells you. For many office roles, the topics in this test are the core: formulas, percentages, IF, counting and summing by criteria, lookups, sorting and filtering. Finance and data roles add PivotTables and dynamic arrays.