ExcelReady › Free Excel test

Free · 10 minutes · No sign-up

Free Excel test: check your skills in 10 minutes

Ten real tasks in a live spreadsheet, against the clock. You type actual formulas, every answer is checked instantly, and you get a report showing which skills to practice before a job test.

What's on the free Excel test

The test covers the skills that show up most often in Excel assessments for office, finance and analyst jobs. Each task is one realistic problem in a small spreadsheet.

#SkillWhat you do
1FormulasMultiply units by price
2FunctionsTotal six months of figures
3ReferencesApply a fixed bonus rate with an absolute reference
4LogicDecide free shipping with IF
5Conditional sumsTotal the sales for one region
6LookupsFind a price from a product code
7TextCombine first and last names
8DatesWork out a delivery time
9ShortcutsLock references the fast way
10LookupsFix a lookup that returns the wrong result

Try a sample question

This is the kind of task you'll see. Type a formula in the bar, or click the cells to insert them, then press Enter.

Try itNo sign-up

How many orders are over $500?

In E2, count the orders in column B that are larger than $500.

How the test is scored

Who the test is for

Ready? It takes 10 minutes.

Free, no account needed. Your result stays in your browser.

Start the free test

Frequently asked questions

Is the Excel test really free?

Yes. The 10-minute skills test, the first three lessons and the speed drills are free, with no account and no card. Pro adds all lessons and the timed mock tests.

Do I need Excel installed?

No. The test runs in a spreadsheet in your browser, so it works on any computer, including a Mac or a work laptop without Excel.

Is this the same as the Excel test employers use?

No test is identical to every employer's, but this one covers the skills that come up most often: formulas, references, IF logic, SUMIFS, lookups, text and dates.

What score is good?

For most office jobs, aim for 8 out of 10 or better. The report shows which skills cost you points, and links to the lessons that fix them.

More free Excel resources