Excel assessment test practice

Applying for a job that asks you to pass an Excel assessment test? Practice the tasks those tests are built from, in a real spreadsheet in your browser, with every answer checked the moment you finish.

Try it now, freeIn your browser, checked in a second. 3 exercises free, no sign-up.

An Excel assessment is a short test of how well you use a spreadsheet. Employers use them for jobs where spreadsheets are part of the daily work: accounting and bookkeeping, finance, operations, administration and analysis. Some buy a ready-made test from a testing company; others write their own. Either way, the test is trying to answer one practical question: can this person do the spreadsheet work the job needs, accurately, without help?

Reading about functions only gets you so far. What gets you through a test is having done the tasks with your own hands, often enough that you don't have to think about the steps. This page explains what Excel assessments usually look like, which skills they lean on, and how to practice each one. Every skill links to a full guide and hands-on exercises.

What an Excel assessment test looks like

No two employers use exactly the same test, but most fall into one of four formats. Knowing which one you face changes how you prepare.

Multiple-choice questions about Excel. You read a question ("Which formula returns the total of column B for the West region?") and pick an answer. You don't touch a spreadsheet, but you do need to recognize correct formulas and spot broken ones.
An interactive simulation. The test shows a spreadsheet that behaves like Excel and asks you to perform a task: enter a formula, sort a list, format a range, insert a chart. It checks the result, and sometimes the way you got there.
A file to complete. You get a workbook with data and instructions, either timed in an office or as a take-home task. You build formulas, summaries and sometimes a chart, then send it back. A reviewer opens your file and looks at both the answers and the formulas behind them.
A live exercise in the interview. You share your screen and work through a task while someone watches. Speed matters less than working calmly and explaining what you're doing.

If the job posting or the recruiter doesn't say which format to expect, ask. It is a normal question, and the answer tells you whether to practice recognizing formulas or building them. For the last three formats, which are the most common for jobs that use spreadsheets every day, practicing in a real spreadsheet is the only preparation that transfers.

The skills most tests lean on

Tests are usually pitched at a level: basic, intermediate or advanced. The skills build on each other, so a test at any level assumes the ones below it.

Basic: entering formulas, SUM, AVERAGE, COUNT, MIN and MAX, relative and absolute references, number formats, sorting and filtering a list.
Intermediate: IF and its partners AND and OR, conditional totals and counts (SUMIFS and COUNTIFS), lookups (XLOOKUP, VLOOKUP or INDEX and MATCH), cleaning text, finding duplicates, conditional formatting.
Advanced: PivotTables, nested logic, dynamic array functions such as FILTER and SORT, and finding and fixing errors in someone else's formulas.

The exercises here use accounting data, such as ledgers, invoices and bank lines, because that is what this site teaches. The functions and the habits are the same ones any Excel test checks. If you are applying for a finance or accounting role, the data will also look like the work itself; for that case, see accounting Excel test practice, which adds reconciliations, schedules and ratios.

How to prepare in a week

Find your level. Try the free exercise above. If the lookup feels comfortable, start at the intermediate skills; if not, start with references and totals.
Learn the core five. References, totals, IF, SUMIFS and a lookup. Most test tasks are some mix of these five, and they come up inside every harder task too.
Add the cleanup skills. Real data is messy, and tests often hand you a messy list on purpose: extra spaces, duplicates, numbers stored as text.
Then the summaries. PivotTables and conditional formatting turn a long list into an answer someone can read.
Practice with new numbers, against the clock. A test gives you data you haven't seen. Working the same task with fresh numbers, a little faster each time, is the closest thing to test day.

The tasks worth practicing

Relative and absolute references

Almost every test includes a formula that must be filled down or across, and almost every wrong answer in that task comes from a reference that moved when it shouldn't have. A dollar sign locks a column, a row or both: $B$2 stays put, B2 moves with the formula. Get this right and a whole column of answers is right; get it wrong and only the first cell is.

Guide and exercises: absolute cell references in Excel.

Totals: SUM, AVERAGE and COUNT

The basics, but tests use them to check precision: summing the right range, not including the header or the total row twice, and knowing that COUNT counts numbers while COUNTA counts anything that isn't empty. A quick sanity check, such as whether the average sits between the smallest and largest value, catches most slips.

Guide and exercises: SUM, AVERAGE and COUNT in Excel.

Conditional totals with SUMIFS

"Total the sales for the West region in March" is one of the most common test tasks there is. SUMIFS adds the values in one range where other ranges meet your conditions. The usual mistakes are putting the sum range in the wrong place (it comes first in SUMIFS), mixing ranges of different sizes, and typing the condition into the formula instead of pointing at a cell, which makes the formula impossible to reuse.

Guide and exercises: SUMIFS in Excel.

Lookups: XLOOKUP, VLOOKUP and INDEX MATCH

Bringing a value from one table into another, such as a name for each code or a price for each product, is the other classic. XLOOKUP is the simplest, but older versions of Excel don't have it, so a test may expect VLOOKUP or INDEX with MATCH instead. The trap in all of them is the match type: ask for an exact match unless you have a sorted list and really want the nearest value, or the formula returns an answer that looks right and isn't.

Guide and exercises: XLOOKUP and INDEX MATCH in Excel.

Decisions with IF

IF returns one result when a condition is true and another when it's false, and AND, OR and IFS extend it to several conditions. Tests use it for labels ("Over budget"), flags and simple rules. Read the condition carefully: "at least" means greater than or equal to, and a test that says "more than 100" expects 100 itself to fail.

Guide and exercises: IF, OR and IFS in Excel.

Cleaning text

Imported data arrives with extra spaces, odd capitals and numbers stored as text, and a lookup against a name with a trailing space quietly fails. TRIM removes the extra spaces, PROPER fixes capitals, and VALUE turns text that looks like a number into one. Splitting a code from a name is a related task with LEFT, FIND and their partners.

Guides and exercises: TRIM, PROPER and TEXT in Excel and splitting a code from a name.

Finding duplicates

"Which rows appear twice?" is a favorite because it tests whether you think about what makes two rows the same. COUNTIF flags a repeated value; COUNTIFS flags a repeated combination, such as the same date, amount and reference. Decide which columns define a duplicate before you write the formula.

Guide and exercises: find duplicates in Excel.

Filtering and sorting

Sorting a list by two levels, such as by region and then by date, and pulling out only the rows that meet a condition are everyday tasks. The FILTER and SORT functions do it with a formula, so the result updates when the data changes.

Guides and exercises: the FILTER function in Excel and sorting by two levels.

Conditional formatting

Highlighting values above a limit, dates that are overdue or cells that break a rule shows a reviewer the problems at a glance. Tests check that the rule refers to the right cell, which again comes down to references.

Guide and exercises: conditional formatting in Excel.

PivotTables

A PivotTable summarizes a long list by category in a few steps: totals by region, counts by month, averages by product. Advanced tests often ask for one, sometimes with a filter or a second level of grouping. Know where each field goes: rows for the categories, values for the numbers, and filters for the condition.

Guide and exercises: pivot tables in Excel.

Finding and fixing formula errors

Some tests hand you a broken workbook and ask what's wrong. Learn what each error means: #N/A is a lookup that found nothing, #VALUE! is the wrong kind of input, #DIV/0! is a division by zero or an empty cell, and #REF! is a reference to something deleted. The harder cases show no error at all, just a wrong number, and that is where checking a total against a quick estimate pays off.

Guide and exercises: find and fix formula errors in Excel.

On the day

Read the whole task first. Instructions often say exactly which cell is checked and how the answer should be formatted.
Use formulas, not typed answers. A reviewer, or the test itself, often looks at the formula. A typed number scores nothing even when it's right.
Point at cells instead of typing values into formulas. It is faster to check, and it keeps working when the data changes.
Check each result against a rough estimate. If a regional total is bigger than the grand total, something has gone wrong.
Don't stall on one question. Timed tests reward getting most things right over getting one thing perfect.

How practice works here

Each exercise opens a spreadsheet in your browser with a task and its data. You write the formulas, and when you check, your sheet is calculated and compared with the correct result. Wrong cells are marked, with a hint about the likely mistake. New numbers gives you the same task again with different data, so you practice the method rather than memorizing an answer. Hints go from a gentle nudge to the full solution when you need them.

You can try 3 exercises free with no sign-up. Premium opens every lesson in both tracks, along with timed tests; plans are on the pricing page.

Frequently asked questions

Will these be the same questions as my employer's test?

No. Every employer and testing company writes its own questions, and we don't copy anyone's. These exercises practice the skills those tests are built from, so the work feels familiar whatever your test looks like.

Is this only for accounting jobs?

No. The data in the exercises comes from accounting, but the functions and habits are the ones any Excel assessment checks. If your role is in accounting or finance, that is a bonus: the practice data looks like the job.

Which functions should I know best?

For most tests: SUM and its relatives, IF, SUMIFS and COUNTIFS, one lookup (XLOOKUP, VLOOKUP or INDEX and MATCH), TRIM and the text functions, and how to build a PivotTable. Absolute references matter in all of them.

Do I need my own copy of Microsoft® Excel® software?

Not for practicing here. Every exercise runs in a spreadsheet in your browser with nothing to install. For the test itself, use whatever the employer provides.

How long should I practice?

A few sessions over a week is enough for most people to feel at ease with the core skills. Short, regular practice with new numbers works better than one long session.