ExcelReady › Excel practice test

Practice questions · Instant feedback

Excel practice test: realistic questions with instant feedback

The fastest way to prepare for an Excel assessment is to practice the exact tasks it asks for, in a real grid, with feedback on every mistake. Start with the questions below.

The two kinds of Excel tests

TypeWhat it looks likeHow to prepare
Multiple choiceQuestions about what a formula returns or which menu does somethingKnow the common functions well enough to predict their result
Interactive (simulation)A spreadsheet where you do the task yourself, often timedPractice typing formulas quickly and correctly: this is the harder type

Most job tests also come in levels. Basic tests ask for formulas, SUM and formatting. Intermediate tests add IF, absolute references, SUMIFS and lookups. Advanced tests add PivotTables, INDEX/MATCH, XLOOKUP and data cleaning.

Practice question 1: look up a price

Lookups are on almost every intermediate Excel test. Use XLOOKUP, VLOOKUP or INDEX/MATCH: any correct formula counts.

Try itNo sign-up

Find the price for a product code

In F2, look up the price of the product code in E2.

Practice question 2: IF with two conditions

Tests love conditions that combine: both must be true, or either one.

Try itNo sign-up

Who earns a bonus?

In D2, show Yes if sales in B2 are at least 10,000 and the rating in C2 is at least 4. Otherwise show No.

A 7-day plan before your Excel test

  1. Day 1: take the free 10-minute test to find your weak spots.
  2. Day 2: formulas, order of operations and absolute references ($A$1).
  3. Day 3: IF, AND, OR and nested IFs.
  4. Day 4: SUMIFS, COUNTIFS and AVERAGEIFS.
  5. Day 5: lookups: XLOOKUP, VLOOKUP with FALSE, INDEX/MATCH.
  6. Day 6: PivotTables, sorting and filtering, plus a timed mock test.
  7. Day 7: a second mock test in a different version, then review only what you got wrong.

Pro builds this plan around your actual test date and fills it with the lessons you need most.

Find your weak spots first

The free test tells you which days of the plan matter most for you.

Start the free test

Frequently asked questions

Where can I find a free Excel practice test?

The questions on this page and the 10-minute skills test are free and run in your browser. Pro adds four timed mock tests (office, analyst, finance and advanced), each in three versions.

How long should I practice before an Excel test?

If you already use Excel, 3 to 7 days of focused practice is usually enough to fix the gaps a test exposes. Starting from scratch, plan for two to three weeks.

Should I learn VLOOKUP or XLOOKUP?

Both. XLOOKUP is simpler and newer, but many tests and workplaces still use VLOOKUP. If you use VLOOKUP, always add FALSE for an exact match.

Are interactive Excel tests timed?

Usually, yes. That's why practicing in a real grid matters: knowing a formula isn't enough if typing it takes too long.

More free Excel resources