Free Excel test for job interviews

Got an Excel assessment coming up? Take a timed practice test built like the ones employers send: 18 formula tasks in 25 minutes, graded instantly, with a score report showing exactly which skills to fix. No signup.

What's tested

Basic formulas, cell references and $ locks, IF / AND / IFERROR, COUNTIF and SUMIFS, lookups (VLOOKUP, XLOOKUP or INDEX/MATCH) text cleanup, and a few harder tasks at the end: tiered logic, two-condition lookups and splitting messy text. These are the formula skills that come up most in employer Excel tests. Any correct formula counts, and Google Sheets-only functions like QUERY are not accepted, just like in Excel.

Some real tests also check formatting, charts and pivot tables by clicking through menus. This test covers the formula part, which is where most people lose points.

Independent practice test with original questions. Not affiliated with Indeed, IBM Kenexa, SHL, Criteria, TestGorilla or any other test provider.

FAQ

What is on an Excel test for a job interview?

Most employer Excel assessments check basic formulas (SUM, AVERAGE), cell references and $ locks, IF logic, COUNTIF and SUMIFS, lookups such as VLOOKUP, XLOOKUP or INDEX/MATCH, and text cleanup. Many also include formatting, sorting, charts and pivot tables.

Is this the same as the Indeed or Kenexa Excel test?

No. This is an independent practice test with original questions. Indeed Assessments was discontinued in 2024, and employers now use a range of tools such as SHL, Criteria, TestGorilla and in-house tests. The formula skills they check are the same ones practiced here.

What score do I need to pass an Excel test?

Each employer sets its own cut-off. Aim for 80% or more on this test before a real assessment.