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
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.
- Add up the travel costs in B6
- Work out the average order value in B7
- Count how many guests answered "Yes", in D2
- Show "Bonus" in C2 if the sales are 1,000 or more, otherwise "No bonus"
- Add up the sales of the East region, in E2
- Find the price of product P-03 with VLOOKUP, in F2
- Work out the sale price in D2: the price minus the discount
- Join first and last name with a space between, in C2
- Which function counts every cell that isn't empty, text included?
- 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.
| Task | Answer | Why |
|---|---|---|
| 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&" "&B2 | Joins first name, a space and last name. |
| Count filled cells | COUNTA | COUNT only counts numbers; COUNTA counts text too. |
| The #N/A error | Value not found | VLOOKUP 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:
- Sums and averages: SUM, AVERAGE, MIN and MAX.
- Counting and adding with a condition: COUNTIF, SUMIF and their multi-condition versions COUNTIFS and SUMIFS.
- Decisions: IF, often combined with AND or OR.
- Lookups: VLOOKUP, XLOOKUP or INDEX MATCH.
- Percentages and references: percentage change and absolute references like $A$1.
- Data tools: sorting and filtering and pivot tables.
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*C2is 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.