Failed an Excel Test? What to Do Next

You failed an Excel test, and it stings. The good news is that an Excel test checks a short list of skills, so a fail is usually a clear signal of what to practise, not a verdict on you. This guide walks you through what to do next: capture what went wrong, ask for feedback, close the gaps with hands-on practice, and go into the next test with a plan.

First, don't panic: a failed Excel test is fixable#

An Excel test measures a few specific skills on one day, under time pressure. Unlike a vague interview question, you can practise every one of those skills until it feels easy.

Most people who fail an Excel test fall short in one of three ways:

• A skill gap. They didn't know a function the test needed, such as VLOOKUP or SUMIFS.
• Speed. They knew the answers but ran out of time.
• Small errors. A missing $, a wrong range, or a typo in a criteria like "Wets".

Each one has a different fix, so the next step is to find out which one hit you.

Step 1: Write down what you remember#

Do this within an hour of the test, before the details fade. Open a notes file and list:

1. Each question or task you can remember.
2. Whether you answered it, guessed it, or skipped it.
3. What blocked you: "didn't know the function", "formula gave #N/A", "no time".

Be honest. This list is only for you, and it becomes your practice plan.

Step 2: Ask for feedback and the retake policy#

A short, polite email to the recruiter is normal and professional. Something like this works:

Thank you for the chance to take the Excel assessment. I'd like to improve, so could you tell me which areas I should focus on? I'd also like to know if a retake is possible later.

Not every company shares details, but even "the lookup section" is useful. Retake rules differ between employers and test platforms. Some allow a second attempt after a waiting period and others don't, so ask rather than guess.

Step 3: Find the skills that cost you marks#

Turn your notes into skills. This table matches common symptoms to the skill behind them:

If you track your practice questions in a small log like the one in this page's exercise, COUNTIFS shows you the weak topic in one formula. Two of the three wrong answers in that log are lookups, so lookups come first.

Not sure what level the job expected? The guide to Excel proficiency levels explains what basic, intermediate and advanced usually mean.

Step 4: Practise the weak skills, hands-on#

Reading about Excel won't fix a failed Excel test. Typing formulas will. Spend 20 to 45 minutes a day on your top one or two skills.

• Work in a real grid. Type every formula yourself. Copying from a page skips the part your brain needs.
• Use small tables first. Six to ten rows make it easy to check the answer by eye.
• Repeat until it is boring. When you can write =SUMIFS(D2:D9,B2:B9,"West") without thinking, move on.
• Learn the shortcuts that save time. Ctrl+Arrow to jump and Ctrl+Shift+Arrow to select (⌘ instead of Ctrl on a Mac), and F4 to add $ signs (fn+F4 or ⌘T on a Mac).

For task ideas, use this list of Excel practice tasks to do before a test. If the test was an entry-level screen, what a basic Excel test for employment covers shows the usual questions.

Step 5: Take a timed mock test before the retake#

Practice on single skills builds knowledge. A timed mock test builds speed and calm. Take one when your weak skills feel solid, then review every wrong answer and repeat the matching practice.

Start with the basic Excel mock test, then the intermediate Excel mock test if the job asked for more. The guide to taking an Excel mock test online explains how to get the most from each attempt. Aim to finish with a few minutes left for checking.

Treat the mock like the real thing. Sit somewhere quiet, close other tabs, start the timer and don't pause it. If a question blocks you for more than a minute or two, skip it and come back at the end. Nerves are easier to handle when the format already feels familiar, and a second or third mock usually feels much calmer than the first.

What to say on your CV and in your next application#

Be accurate about your level. If you wrote "advanced Excel" and failed a basic test, change the wording to match what you can do today, and update it as you improve. The guide to listing Excel skills on your resume shows honest wording that still sells your skills.

In a later interview, you can mention what you did after the setback: "I took an Excel test, found my lookups were weak, and practised them until I could do them quickly." That shows the kind of self-improvement employers like.

Practise it#

The fastest way back is to test yourself on the basics, then on conditional formulas. Take the basics skill check in a live spreadsheet, then the summary grid skill check for COUNTIFS and SUMIFS. Each one checks your answer instantly, so you see exactly which skill still needs work. Try the exercise on this page first.