ExcelReady › Microsoft Excel test for jobs

Job applicants · Pre-employment tests

Microsoft Excel test for jobs: what to expect and how to prepare

Many employers test Excel skills before they hire, especially for office, finance, operations and analyst roles. Here is what those tests usually cover, by role, and how to get ready in a few days.

What a pre-employment Excel test looks like

Which skills are tested, by job

RoleTypical levelSkills that come up most
Administrative and officeBasic to intermediateFormulas, SUM/AVERAGE, formatting, sorting and filtering, simple IF
Accounting and bookkeepingIntermediateAbsolute references, SUMIFS, lookups, rounding, dates
Data and business analystIntermediate to advancedXLOOKUP or INDEX/MATCH, PivotTables, nested IF, text cleaning, charts
FinanceAdvancedFinancial functions (PMT, NPV), scenario models, lookups, error checking

Try a typical test question

Conditional sums with two criteria are a classic intermediate task.

Try itNo sign-up

Total East region sales in Q1

In F2, add up the sales in column C where the region is East and the quarter is Q1.

How to prepare in five steps

  1. Ask the recruiter which level and format the test is. Many will tell you.
  2. Take a free Excel test to see your weak spots.
  3. Practice the skills for your role from the table above, in a real grid.
  4. Do at least one timed mock test, so the clock doesn't surprise you.
  5. On the day: read each task twice, use cell references instead of typed numbers, and skip a hard task rather than losing five minutes on it.

Know where you stand in 10 minutes

Ten realistic tasks, scored instantly, with the lessons to practice next.

Start the free test

Frequently asked questions

What is on a Microsoft Excel test for a job?

Most cover formulas, cell references, SUM and AVERAGE, IF logic, SUMIFS or COUNTIFS, lookups, sorting and filtering, and for analyst roles PivotTables and charts.

Can I fail an Excel test and still get the job?

Sometimes, if the rest of your application is strong, but many employers use a minimum score to filter candidates. It's worth preparing for.

Can I use Google Sheets to prepare?

Mostly, yes: the core formulas work the same. But if the test is in Excel, practice in an Excel-style grid so the layout and function names are familiar.

How hard is an intermediate Excel test?

Intermediate tests expect you to combine skills: an IF inside a lookup, or SUMIFS with two conditions, often under time pressure. A few days of focused practice usually closes the gap.

More free Excel resources