Excel tests for job applications
Lots of jobs now come with an Excel test: a short, timed task you take online or at the interview. These practice tests use the same kinds of tasks. You type formulas into a real grid, and you get your score when you hand in.
Tests by test platform
Has the employer sent you a link to a testing platform? Take the practice test that matches it. Each one follows the format and pace that platform is known for.
Indeed Excel assessment practice test
Employers who hire through Indeed often ask candidates to take an Excel skills assessment before the interview. This mock test gives you 20 real spreadsheet tasks against the clock: you type each formula into a live grid, and every answer is checked the way Excel would calculate it. Pass 14 of the 20 and you are ready for the real thing.
20 questions · 30 minutes · passing score 70%Take the test
Kenexa Excel test practice
Recruitment agencies and employers often send candidates a Kenexa Prove It! Excel test before an interview. This practice test gives you 20 hands-on spreadsheet tasks in 30 minutes: you type each formula into a live grid and every answer is checked the way Excel would calculate it, so you find out what you still need to practice before the real one.
20 questions · 30 minutes · passing score 70%Take the test
SHL Excel test practice
SHL's catalog of skills tests includes Microsoft Excel, and employers often add it to an online assessment next to numerical or verbal reasoning. This practice test gives you 20 spreadsheet tasks in 25 minutes, typed as real formulas in a live grid, so you can find out how quick and accurate you are before the real assessment.
20 questions · 25 minutes · passing score 70%Take the test
iMocha Excel test practice
iMocha is a skills assessment platform that employers use to test candidates before an interview, and Excel is one of the skills it covers. This practice test gives you 20 spreadsheet tasks in 25 minutes, with a strong dose of the text and data clean-up that office and operations roles ask for, typed as real formulas in a live grid.
20 questions · 25 minutes · passing score 70%Take the test
TestGorilla Excel test practice
TestGorilla is a screening platform where employers combine several short, timed skills tests into one assessment, and Microsoft Excel is among them. This practice test gives you 20 tasks in 20 minutes, typed as real formulas in a live grid, to get you used to working fast and accurately when every minute counts.
20 questions · 20 minutes · passing score 70%Take the test
Tests by job
Practice the tasks of the job you are applying for. Each role test mixes the everyday formulas every employer checks with tasks from that line of work.
Excel test for job interviews
Many employers test Excel before they hire for finance, admin, sales and analyst roles, usually with a short timed task at the interview or online beforehand. This practice test gives you 20 tasks of the kind those tests use, from conditional sums and text formulas to INDEX and MATCH, in a live grid with a 30-minute clock.
20 questions · 30 minutes · passing score 70%Take the test
Excel test for finance jobs
Financial analysts, controllers and finance assistants are often given an Excel task before the interview. This practice test has 20 tasks from finance work, from gross margin, debtor days and year-to-date totals to a loan payment, NPV, IRR and lookups in a report, in a live grid with a 30-minute clock.
20 questions · 30 minutes · passing score 70%Take the test
Excel test for accounting and bookkeeping
Bookkeepers, accounts assistants and accountants are often tested on the spreadsheet work behind the ledger. This practice test has 20 tasks from that work, from VAT and depreciation to due dates, account balances, overdue invoices and a bank reconciliation, in a live grid with a 30-minute clock.
20 questions · 30 minutes · passing score 70%Take the test
Excel test for budgeting and planning
Budget analysts, FP&A analysts and anyone who follows up on a budget work in Excel every day, and many employers test it before they hire. This practice test has 20 budgeting tasks, from variances and remaining budget to an inflation uplift, a salary budget from FTEs and a full-year forecast, in a live grid with a 30-minute clock.
20 questions · 30 minutes · passing score 70%Take the test
Excel test for admin jobs
Administrative assistants, office coordinators, HR assistants and secretaries keep lists of people, dates and bookings in Excel, and the Excel test for those jobs reflects that. This practice test has 20 office tasks, from tidying names and phone numbers to deadlines in working days, absence, mileage and notice periods, in a live grid with a 30-minute clock.
20 questions · 30 minutes · passing score 70%Take the test
Excel test for data analysts
Data analysts, business analysts and reporting specialists are usually tested on more than totals: they have to summarize, compare and rank data in one formula. This practice test has 20 analysis tasks, from medians, ranks and correlation to distinct counts, conversion rates, the latest order and month-on-month change, in a live grid with a 30-minute clock.
20 questions · 30 minutes · passing score 70%Take the test
Good to know
Why practice with a timed test
Knowing what SUMIF does isn't the same as writing it correctly with the clock running. Most candidates who fail an Excel test know the functions. They lose time on small things: a missing quote around a criterion, a VLOOKUP without FALSE at the end, a range that's one row short. A timed mock test shows you those mistakes before the real one does.
Each question here is a small sheet with a task, and the answer is a formula in one cell. Answers are checked the way Excel calculates them, and a typed number doesn't count: the formula has to keep working when the data changes. That's how most employer tests are marked too.
How the tests work
Every test has 20 questions and a clock of 20 to 30 minutes. You can move between questions, skip and come back, and nothing is marked until you hand in, just like the real thing. When the time runs out, your answers are handed in automatically. The questions are written for the tests only, so you can't have practiced the exact sheet in a lesson.
The first 10 questions of every test are free as a timed preview. The full test, your score history and a certificate when you pass come with premium.
Which test to take
Start with the Indeed practice test if you are applying through Indeed or want to check the basics: SUM, AVERAGE, COUNT, IF, COUNTIF, SUMIF and VLOOKUP. If you know the job but not the test, take the role test for your line of work: finance, accounting and bookkeeping, budgeting, admin or data analysis. The Excel test for job interviews is the all-round option, with SUMIFS, COUNTIFS, nested IF, INDEX and MATCH and XLOOKUP.
Has the employer named the test platform? Take the matching practice test. The Kenexa test leans on percentages, rounding and lookups, the SHL test on shares, conditional averages and sums at a brisk pace, the iMocha test on text clean-up and wildcards, and the TestGorilla test packs 20 questions into 20 minutes.
After each attempt you see which questions you missed and where to practice each one. Work through those lessons, then take the test again a few days later.
How to prepare in a week
If your test is a week away, take one practice test today without preparing, just to see where you stand. Spend the next few days on the lessons for the questions you missed, 20 to 30 minutes at a time. Take a different test midweek and a final one the day before, at the same time of day as the real test if you can.
On the day, read each task twice before you type, check whether the answer needs to be rounded, and skip any question that takes more than two minutes. Coming back to it at the end is better than running out of time with easy questions left.
A certificate employers can check
Pass a full test and you get a certificate with your name, your score and a public link anyone can open to check it. Add it to your résumé or your LinkedIn profile, so the hiring manager can see your Excel level before the interview.