PracticeExcelSign in
Excel tests for job applications

iMocha Excel test practice

iMocha is a skills assessment platform that employers use to test candidates before an interview, and Excel is one of the skills it covers. This practice test gives you 20 spreadsheet tasks in 25 minutes, with a strong dose of the text and data clean-up that office and operations roles ask for, typed as real formulas in a live grid.

20 questions · 25 minutes · passing score 70%

Question 1 of 20

Some orders have no amount yet. In D2, use COUNT to count how many orders in B2:B9 have an amount.

D2
ABCDEF
1Order Amount Orders with an amount
21001 250
31002 pending
41003 410
51004
61005 125
71006 380
81007 pending
91008 95
10

No tips during the test. I'm back with help when the clock stops.

The free preview is the first 10 questions in 13 minutes. It isn't saved.

Unlock the full test from $19/monthAlready premium? Sign in

Premium gets you the full 20-question test, your score history and a certificate when you pass.

What the iMocha Excel test checks

iMocha's Excel tests are put together by the employer, who chooses the topics and the level. A test can mix multiple-choice questions about Excel with hands-on tasks, so you need to know what the formulas do and be able to write them.

Alongside the usual counts, sums and lookups, these tests often look at how you handle messy data: joining and splitting names, cleaning up codes and phone numbers, and counting or adding up rows by part of a word. This practice test puts extra weight on that.

How this practice test works

You have 25 minutes for 20 questions. They start with COUNT and COUNTA, move through text formulas such as RIGHT, SUBSTITUTE, LEFT with FIND, TRIM and PROPER, and finish with wildcards in COUNTIF and SUMIF and an AVERAGEIFS with two conditions. Each question has its own small sheet, written for this test only.

Click the answer cell, type your formula and press Enter, as in Excel. Nothing is marked until you hand in. Afterwards you see your score, the questions you missed and the lesson or function page that teaches each one.

How to prepare

Take the free preview of the first 10 questions, then practice whatever slowed you down. Text formulas are where most people lose time, because one missing quote or a wrong position number gives the wrong answer. Write each one out on a small example first, then take the full test against the clock.

Not affiliated with iMocha

PracticeExcel is not affiliated with iMocha, and this is not iMocha's test. We wrote every question ourselves to practice the same skills, so a good score here means you know the formulas, not that you have seen the real questions.

What the test covers

Each question practices one of these skills. Follow a link to practice it before you start.

  1. 1Count the orders with an amount
  2. 2Count the sign-ups
  3. 3Labor cost for a week
  4. 4Join first and last name
  5. 5Last four digits of an account
  6. 6Bonus or no bonus
  7. 7Position of an order in a queue
  8. 8Look up a department by employee ID
  9. 9Remove the separators from a phone number
  10. 10Round a price up to the next ten
  11. 11Count tickets that mention a word
  12. 12Count the Copenhagen offices
  13. 13Total for products starting with a word
  14. 14Total of all orders not canceled
  15. 15Count leads with an email address
  16. 16Flag invoices for review
  17. 17First name from a full name
  18. 18Tidy up a badly typed name
  19. 19Build a cost-center code
  20. 20Average with a text and a number condition

Questions

What is on the iMocha Excel test?

The employer chooses the topics and level. Expect counting and summing with conditions, lookups and text formulas for cleaning up data, sometimes as multiple choice and sometimes as hands-on tasks.

Does this practice test include text formulas?

Yes. Almost half of the questions use text formulas such as LEFT, RIGHT, FIND, SUBSTITUTE, TRIM and PROPER, or wildcards in COUNTIF and SUMIF.

How long is the practice test?

25 minutes for 20 questions. The free preview has the first 10 questions in 13 minutes.

What score should I aim for?

The passing score here is 70%, 14 of 20. Aim for 80% or more before the real test.

Do I get a certificate?

Yes. Pass the full test with a verified email and you get a certificate with a public link for your résumé or LinkedIn.

Read the guide

Other Excel tests