Excel practice test and assessment prep

Practice for your Excel test and pass it 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 the Excel assessment tests used by Indeed, Kenexa Prove It, LinkedIn and employers' own hiring tests. Works for Excel and Google Sheets.

140exercises, beginner to pivot tables
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. The single most failed section on Indeed's test.

Data cleanup

Sort, filter, remove duplicates, text to columns, TRIM and PROPER.

Pivot tables and charts

Summarize sales by region, build a bar chart, read the result.

Exercise counts and coverage above are sample figures for this demo site.

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:

Indeed Excel assessment

A short skills test employers attach to job applications on Indeed. Mostly formulas, sorting, filtering and basic formatting. Usually 10 to 15 questions.

Kenexa Prove It Excel test

IBM's older but still common test for office roles. Normal User and Power User levels. Tasks are performed in a simulated Excel window, from basic formulas up to pivot tables.

LinkedIn Excel skills assessment

A 15-question multiple-choice quiz. Passing earns a badge on your profile. Heavy on functions, references and what a given formula returns.

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 Indeed, IBM Kenexa, LinkedIn or Microsoft. We do not copy their questions. We cover the same skills in the same formats.

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?

Most employers treat 70 to 80 percent as passing, but each company sets its own line. Indeed shows employers a level (Familiar, Proficient, Expert) rather than a pass or fail.

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. Paid plans add role-specific tracks, timed mock tests and progress saved across devices.

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

Ten exercises, no account. Upgrade when you want the full track for your role.