Indeed Excel assessment practice test
Employers who hire through Indeed often ask candidates to take an Excel skills assessment before the interview. This mock test gives you 20 real spreadsheet tasks against the clock: you type each formula into a live grid, and every answer is checked the way Excel would calculate it. Pass 14 of the 20 and you are ready for the real thing.
20 questions · 30 minutes · passing score 70%
Question 1 of 20
In B8, calculate the total revenue for January to June.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Month | Revenue | ||||
| 2 | Jan | 12400 | ||||
| 3 | Feb | 9850 | ||||
| 4 | Mar | 11300 | ||||
| 5 | Apr | 13750 | ||||
| 6 | May | 10900 | ||||
| 7 | Jun | 14200 | ||||
| 8 | Total | |||||
| 9 |
No tips during the test. I'm back with help when the clock stops.
The free preview is the first 10 questions in 15 minutes. It isn't saved.
Premium gets you the full 20-question test, your score history and a certificate when you pass.
What the Indeed Excel assessment checks
Indeed's skills tests are short, timed and practical. For Excel they look at whether you can work with a spreadsheet without help: add up and average a column, count what matches a condition, round a result, make a decision with IF and pull a value out of a table with a lookup.
You are not asked to recite definitions. You are given a small table and a question, and you are expected to find the answer with the right formula, quickly.
How this practice test works
You get 30 minutes for 20 questions, in the order the topics usually build up: SUM and AVERAGE first, then COUNT, MAX and MIN, ROUND and simple percentage formulas, IF, COUNTIF, SUMIF and AVERAGEIF, and finally VLOOKUP, IFERROR and XLOOKUP. Each question has its own small sheet, written for this test only, so you cannot have practiced the exact task before. Click the answer cell, type your formula and press Enter, exactly as you would in Excel.
You can skip a question and come back to it. Nothing is marked until you hand in, so you get the same pressure as the real test. When you finish, or when the time runs out, you see your score, which questions you got wrong and where to practice each one.
How to prepare in a week
Take the test once cold to see where you stand. Then work through the lessons for every question you missed; they have hints that point at the usual mistakes, such as a missing FALSE at the end of VLOOKUP or a criterion without quotes. Take the test again two or three days later. Most people who pass the mock test with 80% or more are comfortable on the day.
Not affiliated with Indeed
PracticeExcel is not affiliated with Indeed, and this is not Indeed's own test. The questions are written by us to practice the same skills, so a good score here means you know the formulas, not that you have seen the exact questions.
What the test covers
Each question practices one of these skills. Follow a link to practice it before you start.
- 1Total revenue for six months
- 2Average test score
- 3Count the orders with an amount
- 4Count the sign-ups
- 5Highest store sales
- 6Lowest supplier price
- 7Average delivery time to one decimal
- 8Price including VAT
- 9Share of the sales target
- 10Bonus or no bonus
- 11Free shipping over 500
- 12Count the paid invoices
- 13Count the orders over 1,000
- 14Total travel expenses
- 15Sales for the rep named in a cell
- 16Average salary in one department
- 17Look up a price by product code
- 18Look up a department by employee ID
- 19Show "Not found" for a missing code
- 20Find a SKU to the left with XLOOKUP
Questions
What is on the Indeed Excel assessment?
Practical spreadsheet tasks: totals and averages, counting with conditions, rounding, IF, and lookups such as VLOOKUP. This mock test covers the same ground with 20 questions.
How long is the practice test?
30 minutes for 20 questions. The free preview has the first 10 questions in 15 minutes.
What score do I need to pass?
70%, which is 14 of the 20 questions. Aim for 80% or more before the real assessment.
Can I use the Danish or English function names?
Use English names here. On ExcelOpgaver, the Danish site, both Danish names such as LOPSLAG and English names are accepted.
Do I get a certificate?
Yes. Pass the full test with a verified email and you get a certificate with a public link you can add to your résumé or LinkedIn.