Excel quiz

How the quiz works

• Five tasks, one at a time. Each is a small table with a question. You can move back and forth between them.
• Ten minutes. The clock starts when you press Start. When it runs out, your answers are handed in as they are.
• You write the answer. Any formula that gets the right result counts. A number typed in by hand doesn't: the site changes the data behind the scenes and checks that your answer follows.
• No hints while the clock runs. Your score shows at the end. The report, with what went wrong on each task and the lesson for it, comes with Pro.

A multiple-choice quiz checks whether you recognise the right formula. This one checks whether you can write it on a sheet, the way a spreadsheet task in a job test does.

After the quiz

• Open the challenge for each task you missed. The list above links each one. Each takes a few minutes and explains the usual mistake.
• Try it again in a few days. The quiz uses the same tasks and data each time, so a second go straight away mostly tests memory.
• Then take a longer test. The basic and advanced tests and the role tests have ten tasks in 25 minutes. All the practice tests are on one page.
• Be ready to talk about it. An interview may follow a test with questions out loud. Common Excel interview questions, with short answers.

Other Excel tests

Excel test for data analysts, Excel test for finance jobs, Excel test for accounting jobs, Excel test for administrative assistants, Basic Excel test, Advanced Excel test. Or start from what Excel interview tests check, with the formats and the test providers.

FAQ

Is this Excel quiz free?

Yes. The quiz, the two tasks on this page and every linked challenge are free and need no sign-up. The score is free; Pro adds the task-by-task report.

Is the Excel quiz multiple choice?

No. Each question is a small table, and you answer by writing a formula in the green cells. Any formula that gets the right result counts.

How long does the quiz take?

Ten minutes at most. The clock starts when you press Start, and your answers are handed in when it runs out.

What level is this quiz?

Basic to intermediate: $ references, IF, COUNTIF, VLOOKUP and TRIM. For more, take the basic or advanced practice test, ten tasks in 25 minutes each.

Do I need Excel installed?

No. The sheet runs in your browser. A laptop or desktop is the most comfortable way to take it.

Is this an Excel certification?

No, it is practice. Microsoft's own certification is Microsoft Office Specialist (MOS), a separate paid exam. Hands-On Excel is not affiliated with Microsoft.