Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Excel tests › Excel practice test

Excel practice test with answers

This Excel practice test has 10 tasks like the ones in a real Excel test: formulas in an Excel window plus a few quick questions. There are no tips while you work. At the end you see your score, and for every task you got wrong you see the right answer.

In this guide
  1. Take the practice test
  2. Answers explained
  3. What your score means
  4. What Excel tests ask
  5. Tips for the real test
  6. FAQ

Take the practice test

Click a cell, type your formula and press Enter, just like in Excel. You get two tries per task. You don't need Excel on your computer: it all runs in your browser.

  1. Add up the travel costs in B6
  2. Work out the average order value in B7
  3. Count how many guests answered "Yes", in D2
  4. Show "Bonus" in C2 if the sales are 1,000 or more, otherwise "No bonus"
  5. Add up the sales of the East region, in E2
  6. Find the price of product P-03 with VLOOKUP, in F2
  7. Work out the sale price in D2: the price minus the discount
  8. Join first and last name with a space between, in C2
  9. Which function counts every cell that isn't empty, text included?
  10. Your VLOOKUP shows #N/A. What does that usually mean?

The answers explained

Finished, or stuck on one? Here is how to solve each task, and why it works.

TaskAnswerWhy
Total travel costs=SUM(B2:B5)SUM adds up every number in the range B2 to B5.
Average order=AVERAGE(B2:B6)Adds up the five orders and divides by five.
Guests coming=COUNTIF(B2:B6,"Yes")Counts only the cells that say Yes.
Bonus or not=IF(B2>=1000,"Bonus","No bonus")The test is true, so IF returns the first value.
Sales in the East=SUMIF(A2:A6,D2,B2:B6)Adds the sales only in rows where the region matches D2.
Look up a price=VLOOKUP(E2,A2:C5,3,FALSE)Finds P-03 in the first column and returns column 3, the price.
Price after discount=B2*(1-C2)1 minus 25% is 75%, and 75% of 80 is 60.
Full name=A2&" "&B2Joins first name, a space and last name.
Count filled cellsCOUNTACOUNT only counts numbers; COUNTA counts text too.
The #N/A errorValue not foundVLOOKUP returns #N/A when the lookup value isn't in the first column.

Another formula that gives the same result is fine too. In a real test, the result is what counts.

What your score means

  • 9 or 10 correct: you're ready for a basic Excel test. Try the intermediate Excel test next.
  • 7 or 8 correct: solid. Look at the tasks you missed and practise those functions once more.
  • 6 or fewer: work through the Excel lessons first. They teach the same formulas with a tip at every step.

What Excel tests usually ask

Most Excel tests for jobs and courses check the same core skills. If you can do these without help, you'll pass most basic and intermediate tests:

Tips for the real test

  • Read the task twice. Check which cell the answer goes in and whether it asks for a number, text or a percentage.
  • Start with =. Without it, Excel treats your formula as text.
  • Use cell references, not typed numbers. =B2*C2 is what testers want to see, not =80*0.75.
  • Exact match in lookups. End VLOOKUP with FALSE (or 0), or you may get a wrong value without an error.
  • Don't get stuck. Skip a hard task and come back to it at the end.

Frequently asked questions

Is this Excel practice test like a real Excel test?

Yes. You type formulas in an Excel window and answer a few short questions, just like most online Excel tests employers use. The tasks cover the skills those tests check most.

Do I need Excel to take the test?

No. The test runs in your browser in a small Excel window. It works on a laptop, a tablet and a phone.

Can I see the answers?

Yes. When you get a task wrong twice, you see the right formula straight away. All answers are also explained on this page, under the test.

How long does the practice test take?

About 10 minutes. There's no time limit, so you can take as long as you need.

What should I do after the practice test?

Take one of the three Excel tests for job interviews: basic, intermediate or advanced. Each has 12 tasks, a score and a certificate when you pass.