Excel practice test and assessment prep

Free Excel practice test: pass your Excel exam test the first time.

CellReady is a free Excel practice test site. You type real formulas in a browser spreadsheet, get graded the second you press Enter, and see why an answer is wrong. Built for pre-employment Excel tests like Kenexa Prove It, TestGorilla and employers' own hiring tests. Works for Excel and Google Sheets.

28graded exercises, beginner to VLOOKUP and INDEX MATCH
6job roles with their own prep track
0downloads. Everything runs in the browser
Example: graded instantly
B8=SUM(B2:B7)
AB
1RepSales
2Dana1,250
3Luis830
4Priya2,100
5Marcus475
6Jen990
7Omar1,600
8Total7,245
CorrectSUM adds every number in B2 through B7. A range beats typing B2+B3+B4 because it still works when rows are added.
How it works

Three steps, no setup

Step 1

Pick your job

Admin assistant, bookkeeper, analyst, data entry, office manager or HR. Each track covers only what that test asks.

Step 2

Type the formula

Work in a live grid with real data. Every exercise can reshuffle its numbers, so you can't memorize answers.

Step 3

Get graded, earn XP

We check the result, not just the text, and explain the mistake in one plain sentence. Every solve earns XP toward levels, badges and a streak. See your progress.

What the tests cover

The skills employers actually check

Formulas

SUM, AVERAGE, COUNT, IF, ROUND, percentages and absolute references like $B$2.

Lookups

VLOOKUP, XLOOKUP, INDEX and MATCH, plus handling a value that isn't in the table.

Text cleanup

TRIM, PROPER, UPPER, LEFT, RIGHT and joining text with &. Data entry tests lean on these.

Dates

YEAR, DATE, DATEDIF for tenure, and counting dates before a cutoff. Common on HR and bookkeeping tests.

Sorting, filtering, pivot tables, charts and conditional formatting are done with menus, not formulas, so the grader can't check them yet.

What this is

What is an Excel practice test?

An Excel practice test is a set of timed spreadsheet exercises that copy the format of a pre-employment Excel assessment. You get a small data set, a target cell, and a task like "total the sales column" or "count the orders over $500." The test checks the result your formula produces. CellReady runs these exercises in your browser, grades them instantly, and explains each mistake in one sentence.

Who it's for

Job seekers who have an Excel test coming up for an administrative, bookkeeping, data entry, HR, office manager or analyst role. Also employers, trainers and teachers who need to test or teach spreadsheet skills.

What makes it different

The grader runs your formula on live data instead of matching text, so any correct approach passes. Numbers reshuffle on every attempt, so you learn the logic instead of memorizing answers. Progress, XP and badges keep you practicing.

What it costs

The core set of exercises is free with no account. The full set of role tracks and timed mock tests is $12 a month, cancel any time. Teams and schools pay per group.

Tests covered

Which Excel assessment tests does this prepare you for?

CellReady covers the skills that appear on the most common pre-employment Excel tests in the United States:

TestGorilla and similar online tests

Short timed tests employers send by link, often about 10 minutes. Mostly what a formula returns, conditional functions and lookups. Indeed retired its own Excel test, so many employers moved to tools like these.

Kenexa Prove It Excel test

Originally IBM Kenexa, now sold by SHL. Normal User and Power User levels, for Excel versions from 2003 to 2016. Covers formulas and formatting, and the Power User level adds advanced formulas. What to expect.

Interview take-home workbooks

A spreadsheet and a set of questions to answer before or during the interview. Common for analyst and finance roles. How to prepare.

Employer in-house Excel tests

Many companies give candidates a workbook and 30 to 60 minutes. These vary the most, which is why CellReady organizes practice by job role instead of by test vendor.

CellReady is not affiliated with SHL, IBM Kenexa, TestGorilla, Indeed, LinkedIn or Microsoft. We do not copy their questions. We cover the formula skills these tests check. Indeed and LinkedIn have both retired their skills assessments.

What to expect

What's on an Excel assessment test?

Most Excel tests for office jobs check five areas. Here is what each one asks, and what we recommend you can do without hesitating before test day.

1. Basic formulas

SUM, AVERAGE, MIN, MAX, COUNT, percentages and simple arithmetic. Expect at least a third of the questions here.

2. Conditional functions

IF, COUNTIF, SUMIF and sometimes AND and OR. The most common place people lose points.

3. Cell references

Relative versus absolute references, like B2 versus $B$2, and copying a formula down a column without breaking it.

4. Lookups

VLOOKUP, XLOOKUP, and INDEX with MATCH. Required for analyst and bookkeeping roles, optional for admin roles.

5. Sorting, filtering and formatting

Sort a table, filter to one category, remove duplicates, format numbers as currency, freeze the header row.

Common questions

Excel test questions people ask before they practice

How long does it take to prepare for an Excel test?

Most people with some Excel experience are ready after about three hours of practice spread over one week. Complete beginners should plan on two weeks of 20-minute daily sessions.

What score do you need to pass an Excel assessment?

There is no standard passing score. Each employer sets its own line, and many look at the score next to your resume rather than as a strict pass or fail. Aim to get every basic and conditional question right.

Can I practice for an Excel test without Excel installed?

Yes. CellReady runs entirely in the browser. You type formulas in a simplified grid and the grader checks the result, so you don't need Microsoft 365.

Does this work for Google Sheets tests?

Yes. Almost every formula on an Excel test works the same in Google Sheets. Switch the practice page to Google Sheets mode and the grid and labels change to match.

Is the Excel practice test free?

The core exercises are free with no account. A free account saves your progress across devices. Paid plans add role-specific tracks and timed mock tests.

What is the hardest part of an Excel assessment?

Conditional functions and absolute references. People know SUM and AVERAGE but freeze on COUNTIF, SUMIF and when to use $ signs. Those get the most practice time on CellReady.

Last reviewed October 2026.

Also for

The same grader, three more jobs

Employers

Send a candidate a timed test link. See the score and every formula they typed.

Create a candidate test

Teams

Assign a track to staff, allow retries, and watch progress week by week.

Set up team training

Schools

One link per assignment, a due date, and completion by student. Excel or Google Sheets.

Create an assignment

Start with the free set

Seven exercises, no account. Upgrade for all 28, plus timed mock tests for your role.