Excel Skills Assessment: Know Your Level Before the Employer Tests It

Excel skills assessment at a glance:

• Length: 10 to 35 minutes for most employer tests.
• Pass mark: set by the employer; about 80 percent is a common bar for finance roles.
• Formats: multiple choice, a simulated Excel window, or a file you finish and upload.

An Excel skills assessment is a timed test of how well you use Excel for everyday office work. Most employers buy one from a testing company, send you a link, and compare your score with other applicants. Nearly all of them check the same five areas: entering and formatting data, moving around a workbook, writing formulas, sorting and summarizing data, and building charts. Microsoft's own Excel Associate certification covers almost the same list, down to tables and ranges.

People also search for an excel aptitude test, and the two names get used as if they mean the same thing. They don't quite. An excel proficiency test checks your current skill: build this pivot table, fix this broken formula. An aptitude test checks how quickly you would pick something up, usually with number and logic puzzles and no spreadsheet in sight. If the invite says Excel and shows you a grid of cells, it's a skills test, and you can study for it.

What kind of Excel test do employers give?

Employers give one of three kinds. The first is multiple choice: you read a question about a formula or a menu and pick an answer. The second is a simulation, a copy of the Excel window where you click through tasks, often with some shortcuts switched off. The third is a live file: you download a workbook, do the task in your own Excel, and upload it for scoring. Many employers mix the first two. Ask the recruiter which one you'll get. It's a normal question, and the answer changes how you prepare.

Is there an Excel proficiency test?

There are several. Employers use tests from vendors such as SHL, TestDome, eSkill, and Indeed. If you want proof you can carry from job to job, the Microsoft Office Specialist exam is the formal one. It's proctored and runs 50 minutes. A vendor test result usually stays with the employer who sent it. A certification stays with you.

What topics are included in Excel tests for interviews?

Expect SUM, AVERAGE, COUNT, and IF at every level. Mid-level tests add lookups (VLOOKUP, XLOOKUP, or INDEX with MATCH), SUMIFS and COUNTIFS, pivot tables, filters, conditional formatting, and absolute references, the dollar signs that stop a formula from shifting when you copy it. Finance and analyst tests may add text cleanup, date math, charts, and a small model with a what-if question. Few tests ask for macros unless the job posting mentions VBA or automation.

The figures below are typical ranges. Each employer picks its own version and vendors update their tests, so check your invite for the exact limit.

How long is an Excel assessment test?

Most employer Excel tests run 10 to 30 questions in 10 to 20 minutes. Some go longer. SHL's interactive Excel 365 test (listed in the SHL product catalog) gives you 35 minutes for up to 30 tasks in a simulated spreadsheet, and its Essentials version gives 25 minutes for up to 20. SHL also runs an adaptive multiple-choice version, where each question gets harder or easier depending on your last answer. TestDome sends a workbook file that you finish in your own Excel and upload. The Microsoft Office Specialist exam takes 50 minutes. The time limits are tight on purpose. Each task on its own is pitched so a competent user can do it; running out of minutes is what costs most people their points.

What is a good score on an Excel test?

There's no universal pass mark. The employer sets one, and most never tell you what it is. Many rank you against the other applicants instead of a fixed line. As an industry rule of thumb, not a published standard, around 80 percent is a common bar for finance and analyst roles, and jobs that use Excel lightly often set it lower. Some tests skip percentages: Indeed reports a level band (Expert, Highly Proficient, Proficient, Familiar, or Completed), and Microsoft exams are scored out of 1,000, with 700 needed to pass. If you finish every task with a few minutes to spare, you're usually in good shape. Miss the Microsoft exam's 700 and its retake policy lets you try again after 24 hours.

Can you assess Excel skills in an interview?

You can, and plenty of hiring managers do. The usual version is a screen share: they open a file and ask you to clean up a column, build a quick pivot table, or explain why a formula shows an error. Others ask you to describe a report you built in a past job, step by step. Talk as you work. An interviewer learns more from hearing you check your own numbers than from a perfect answer done in silence. If you get stuck, say what you would search for. That's how people use Excel at work, and most interviewers know it.

Excel test providers side by side

Here is how the common tests differ. Details vary by employer setup, so treat this as a guide and check your invite.

Test

Format

Length

Scoring

Shortcuts and undo allowed?

SHL interactive (Excel 365)

Simulated Excel window, hands-on tasks

35 minutes, up to 30 tasks (Essentials: 25 minutes, up to 20)

Score compared with other test takers

Limited; some shortcuts and undo may be switched off

SHL adaptive multiple choice

Multiple choice that gets harder or easier as you go

Set by the employer; check your invite

Adaptive score compared with other test takers

Not relevant; there is no spreadsheet to edit

TestDome

Workbook you finish in your own Excel and upload

Timed; the limit is shown before you start

Percent, checked against the expected answers

Yes; it's your own copy of Excel

Indeed Assessments

Mostly multiple choice, some interactive questions

Short; the time shows before you start

Band: Expert, Highly Proficient, Proficient, Familiar, or Completed

Mostly not relevant; few questions use a live grid

eSkill

Multiple choice and simulation, often mixed by the employer

Set by the employer

Percent score

Limited in simulation questions

Prove It / IBM Kenexa

Simulated Excel window, sometimes multiple choice

Set by the employer

Percent, compared with other test takers

Limited; the simulation may accept only one way to do a task

Microsoft Office Specialist (MOS)

Proctored, project-based tasks

50 minutes

700 out of 1,000 to pass

Yes, inside the exam's Excel tasks

Job ads ask for basic, intermediate, or advanced Excel without saying what those words mean. Try the checks below in a blank workbook. The first place you get stuck is your level, and the next step shows where to spend your practice time.

Basic Excel test for entry-level jobs

A basic Excel test for entry-level jobs checks that you can enter and format data, sort and filter a list, write SUM, AVERAGE, MIN, MAX, and COUNT formulas, fill a formula down a column, and make a simple chart. Try this: type 20 rows of sales, total them, find the average, and chart the result, all in under five minutes. If that feels slow, start your practice here. Most admin, reception, and junior office roles stop at this level.

Intermediate Excel skills: lookups, pivot tables, conditional logic

Intermediate is the level most Excel assessment tests for jobs are built around. At this level you can pull a price from a second sheet with XLOOKUP or VLOOKUP, total sales by region with SUMIFS, flag late orders with IF, lock a cell reference with a dollar sign, and turn a raw list into a pivot table without looking up the steps. Here's the self-check: if lookups feel easy but pivot tables still send you to a tutorial, you're low intermediate. Put your hours into pivot tables and mixed references. Together they cover a large share of what analyst and operations tests ask.

Advanced Excel skills: Power Query, dynamic arrays, macros

Advanced means you can clean a messy import with Power Query, write dynamic array formulas such as FILTER, UNIQUE, and SORT that spill results into many cells, build a model someone else can follow, and record or edit a simple macro. If pivot tables are second nature but you've never used FILTER or Power Query, you're upper intermediate, and those two tools are your gap. Finance, FP&A, and data roles test at this level. Most other roles don't.

Try a 9-question Excel mini-test

Work through these in order. Cover the answers, give yourself 15 minutes, and count how many you get right.

1. Basic. Cells B2 to B11 hold prices and C1 holds a tax rate. What do you type in D2 so you can fill it down? Answer:=B2*$C$1. The dollar signs lock the tax cell, so it doesn't shift when you copy the formula.
2. Basic. Total B2 to B11. Answer:=SUM(B2:B11). Typing the range beats clicking each cell.
3. Basic. Show "Pass" if C2 is 70 or more, otherwise "Fail". Answer:=IF(C2>=70,"Pass","Fail"). IF checks one condition and returns one of two results.
4. Intermediate. Find the price for the product code in A2 from a table on Sheet2 (codes in column A, prices in column C). Answer:=XLOOKUP(A2,Sheet2!A:A,Sheet2!C:C). XLOOKUP looks in one column and returns from another, without VLOOKUP's column number.
5. Intermediate. Total sales in column C where the region in column A is "East" and the month in column B is "March". Answer:=SUMIFS(C:C,A:A,"East",B:B,"March"). The sum range comes first, then each range and its rule.
6. Intermediate. Grade a score in C2: 90 or more is A, 80 or more is B, anything else is C. Answer:=IF(C2>=90,"A",IF(C2>=80,"B","C")). Nested IFs check the highest bar first.
7. Intermediate. Show total sales by region and month from a raw list. Answer: Insert a pivot table, put Region in Rows, Month in Columns, and Sales in Values as a Sum. Check the source range covers every row first.
8. Advanced. List every order over $500 and, separately, each customer name once. Answer:=FILTER(A2:D100,D2:D100>500) and =UNIQUE(B2:B100). Both spill their results into the cells below.
9. Advanced. A lookup returns #N/A for a code you can see in the table. Why? Answer: Most often a stray space or a number stored as text. Wrap the lookup value in TRIM, or convert the column to numbers, and it matches.

Score key: 0 to 3 right means basic, so start with formulas and references. 4 to 6 means intermediate, so drill lookups, SUMIFS, and pivot tables. 7 to 8 means upper intermediate, so add dynamic arrays and error fixing. All 9 means you're ready for an advanced test.

With AI tools, is Excel proficiency still important?

It still matters. Excel still appears in a huge number of job ads. It sits on O*NET's hot technology list of the software employers ask for most. AI has shifted what gets tested, though. Copilot in Excel can write a formula from a plain-English request, so newer tests lean less on remembering syntax and more on setting data up cleanly and spotting an answer that looks wrong. A simulated test window usually has no Copilot button, so you still need the formulas yourself. And someone has to check what the AI wrote. That person needs to know Excel.

Almost any office job can come with an Excel test, but the level it expects changes a lot by role. Here is what each kind of job usually asks for, so you prepare for the right one.

Administrative and office roles usually test at the basic level: formatting, sorting, simple formulas, and sometimes a chart. Speed and accuracy count for more than clever functions. Our guide to the administrative assistant skills assessment covers the typing and writing tests that often come with it.

Operations, sales operations, and supply chain roles sit at intermediate: lookups, SUMIFS, pivot tables, and cleaning up data exported from other systems.

Accounting and bookkeeping roles test intermediate skills plus care with money: matching two lists, rounding, and date math. Many firms add a separate numbers test, which our accounting aptitude test guide walks through.

Financial analyst, FP&A, and data analyst roles test at the advanced end: a small model, dynamic arrays, and sometimes Power Query. A data analytics skills assessment often comes in the same hiring round, and a business analyst aptitude test adds logic puzzles on top.

Career changers take these tests too. If you're mid-career and moving toward analyst or operations work, the Excel test is usually the easier part to fix. The harder question is how you'd take a month-end close week spent fixing other people's formulas, and that one is worth checking before you apply.

Prepare for the clock as much as the functions

Prepare for the format and the timer as much as for the functions. Three steps cover most of it. First, check the format and the level from the job posting or the recruiter. Second, use the level checks above to find your gap, and spend your time there instead of on things you already know. Third, practice with a timer running. On the day, read each task twice, answer the ones you're sure of first, and don't let one cell eat three minutes. If the test lets you skip and return, use that.

How do I practice an Excel test?

Rebuild real work tasks from scratch. Take a public data set, such as a sales list, and give yourself ten minutes to total it by region, pull a price from another sheet, and build a pivot table. Do it again the next day, faster. Simulated tests often block shortcuts and undo, so practice a few rounds with the mouse and the ribbon menus as well as the keyboard. For sample questions and a longer prep plan, see our Excel test prep guide.

Can I practice Excel for free?

You can, and you don't need to pay to find your level. A free practice test from a training site gives you a rough score in 10 to 15 minutes. CFI and JobTestPrep publish short free practice tests with answers, Coursera has a quick self-check that sorts you into beginner, intermediate, or advanced, and Wise Owl Training posts free exercises by topic. None of them match an employer's exact test, but they show you where you're weak. Use them to find the gap, then practice that gap on real data.

GCFGlobal's free Excel tutorials go from the basics through pivot tables, with practice files. Microsoft's help pages explain every function with examples, including XLOOKUP, which many newer tests expect. Excel for the web is free with a Microsoft account, so you don't need to buy Office to practice.

How do I become proficient in Excel?

Use Excel on real work you care about. A budget, a job-search tracker, or your team's weekly numbers will teach you more than a course you watch once. Add one new skill a week: lookups, then SUMIFS, then pivot tables, then a dynamic array formula. Microsoft suggests about 150 hours of instruction and hands-on use before its associate-level exam, which is a fair picture of what proficient takes. With regular use, most people get there in a few months.

Beyond the Excel Skills Assessment: Find the Career That Fits

You can get ready for an Excel test in a week. Finding out whether you'd enjoy the job behind it usually takes a year in the seat. Pigment's Career Design System gives you an earlier look. It maps your working style and your strengths, and ends with a report that names the jobs that match you and explains each match. If analyst work isn't on your list, you'll see what is. It costs $79, and it's built for people already in work: the median person taking it has about 13 years of work behind them.

See if spreadsheet work fits you