---
title: "iMocha Excel Test Practice: Free Timed Mock Test | PracticeExcel"
description: "Prepare for the iMocha Excel test with 20 timed tasks in a live grid, from COUNTIF wildcards to text clean-up and lookups. Scored instantly."
canonical_url: "https://practiceexcelonline.com/tests/imocha-excel-test"
locale: en
meta:
"og:description": "Prepare for the iMocha Excel test with 20 timed tasks in a live grid, from COUNTIF wildcards to text clean-up and lookups. Scored instantly."
"og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~aU1vY2hhIEV4Y2VsIFRlc3QgUHJhY3RpY2U6IEZyZWUgVGltZWQgTW9jayBUZXN0%2Cdescription_~UHJlcGFyZSBmb3IgdGhlIGlNb2NoYSBFeGNlbCB0ZXN0IHdpdGggMjAgdGltZWQgdGFza3MgaW4gYSBsaXZlIGdyaWQsIGZyb20gQ09VTlRJRiB3aWxkY2FyZHMgdG8gdGV4dCBjbGVhbi11cCBhbmQgbG9va3Vwcy4gU2NvcmVkIGluc3RhbnRseS4%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIk9yZGVyIiwiQW1vdW50IiwiT3JkZXJzIHdpdGggYW4gYW1vdW50Il19LHsibiI6MiwiY2VsbHMiOlsiMTAwMSIsIjI1MCIsIiJdfSx7Im4iOjMsImNlbGxzIjpbIjEwMDIiLCJwZW5kaW5nIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiMTAwMyIsIjQxMCIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIjEwMDQiLCIiLCIiXX0seyJuIjo2LCJjZWxscyI6WyIxMDA1IiwiMTI1IiwiIl19XSwidGFyZ2V0IjpbMSwyXX19%2Cp_Ii90ZXN0cy9pbW9jaGEtZXhjZWwtdGVzdCI%2Cs_MPqHkWsqYvVYCDWY.png"
"og:image:height": "600"
"og:image:type": image/png
"og:image:width": "1200"
"og:title": "iMocha Excel Test Practice: Free Timed Mock Test | PracticeExcel"
"twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~aU1vY2hhIEV4Y2VsIFRlc3QgUHJhY3RpY2U6IEZyZWUgVGltZWQgTW9jayBUZXN0%2Cdescription_~UHJlcGFyZSBmb3IgdGhlIGlNb2NoYSBFeGNlbCB0ZXN0IHdpdGggMjAgdGltZWQgdGFza3MgaW4gYSBsaXZlIGdyaWQsIGZyb20gQ09VTlRJRiB3aWxkY2FyZHMgdG8gdGV4dCBjbGVhbi11cCBhbmQgbG9va3Vwcy4gU2NvcmVkIGluc3RhbnRseS4%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIk9yZGVyIiwiQW1vdW50IiwiT3JkZXJzIHdpdGggYW4gYW1vdW50Il19LHsibiI6MiwiY2VsbHMiOlsiMTAwMSIsIjI1MCIsIiJdfSx7Im4iOjMsImNlbGxzIjpbIjEwMDIiLCJwZW5kaW5nIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiMTAwMyIsIjQxMCIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIjEwMDQiLCIiLCIiXX0seyJuIjo2LCJjZWxscyI6WyIxMDA1IiwiMTI1IiwiIl19XSwidGFyZ2V0IjpbMSwyXX19%2Cp_Ii90ZXN0cy9pbW9jaGEtZXhjZWwtdGVzdCI%2Cs_MPqHkWsqYvVYCDWY.png"
---
> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)
# **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%
=
25:0070 %
**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.
D2fx
| | A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | Order | Amount | | Orders with an amount | | |
| 2 | 1001 | 250 | | | | |
| 3 | 1002 | pending | | | | |
| 4 | 1003 | 410 | | | | |
| 5 | 1004 | | | | | |
| 6 | 1005 | 125 | | | | |
| 7 | 1006 | 380 | | | | |
| 8 | 1007 | pending | | | | |
| 9 | 1008 | 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/month**](https://practiceexcelonline.com/pricing) [**Already premium? Sign in**](https://practiceexcelonline.com/login?next=/tests/imocha-excel-test)
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. [**1****Count the orders with an amount**](https://practiceexcelonline.com/practice/count/count-numbers)
2. [**2****Count the sign-ups**](https://practiceexcelonline.com/practice/count/counta-non-empty-cells)
3. [**3****Labor cost for a week**](https://practiceexcelonline.com/practice/sum/sum-a-column)
4. [**4****Join first and last name**](https://practiceexcelonline.com/functions/concat)
5. [**5****Last four digits of an account**](https://practiceexcelonline.com/functions/right)
6. [**6****Bonus or no bonus**](https://practiceexcelonline.com/practice/if/if-pass-fail)
7. [**7****Position of an order in a queue**](https://practiceexcelonline.com/practice/index-match/match-function)
8. [**8****Look up a department by employee ID**](https://practiceexcelonline.com/practice/vlookup/vlookup-number-id)
9. [**9****Remove the separators from a phone number**](https://practiceexcelonline.com/functions/substitute)
10. [**10****Round a price up to the next ten**](https://practiceexcelonline.com/practice/round/round-nearest-hundred)
11. [**11****Count tickets that mention a word**](https://practiceexcelonline.com/practice/countif/countif-text)
12. [**12****Count the Copenhagen offices**](https://practiceexcelonline.com/practice/countif/countif-text)
13. [**13****Total for products starting with a word**](https://practiceexcelonline.com/practice/sumif/sumif-text-criteria)
14. [**14****Total of all orders not canceled**](https://practiceexcelonline.com/practice/sumif/sumif-greater-than)
15. [**15****Count leads with an email address**](https://practiceexcelonline.com/practice/countifs/countifs-two-conditions)
16. [**16****Flag invoices for review**](https://practiceexcelonline.com/practice/logical/if-or)
17. [**17****First name from a full name**](https://practiceexcelonline.com/functions/left)
18. [**18****Tidy up a badly typed name**](https://practiceexcelonline.com/functions/proper)
19. [**19****Build a cost-center code**](https://practiceexcelonline.com/functions/left)
20. [**20****Average with a text and a number condition**](https://practiceexcelonline.com/functions/averageifs)
## **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**
- [**Excel for finance and accounting: the skills you actually use**](https://practiceexcelonline.com/learn/excel-for-finance)
## **Other Excel tests**
- [**Indeed Excel assessment practice test**](https://practiceexcelonline.com/tests/indeed-excel-assessment)
- [**Excel test for job interviews**](https://practiceexcelonline.com/tests/excel-test-for-job-interview)
- [**Kenexa Excel test practice**](https://practiceexcelonline.com/tests/kenexa-excel-test)
- [**SHL Excel test practice**](https://practiceexcelonline.com/tests/shl-excel-test)
- [**TestGorilla Excel test practice**](https://practiceexcelonline.com/tests/testgorilla-excel-test)
- [**Excel test for finance jobs**](https://practiceexcelonline.com/tests/excel-test-for-finance)
- [**Excel test for accounting and bookkeeping**](https://practiceexcelonline.com/tests/excel-test-for-accountants)
- [**Excel test for budgeting and planning**](https://practiceexcelonline.com/tests/excel-test-for-budgeting)
- [**Excel test for admin jobs**](https://practiceexcelonline.com/tests/excel-test-for-admin-jobs)
- [**Excel test for data analysts**](https://practiceexcelonline.com/tests/excel-test-for-data-analysts)
```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#webpage","description":"Prepare for the iMocha Excel test with 20 timed tasks in a live grid, from COUNTIF wildcards to text clean-up and lookups. Scored instantly.","name":"iMocha Excel Test Practice: Free Timed Mock Test","url":"https://practiceexcelonline.com/tests/imocha-excel-test","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#/schema/question/1"},{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#/schema/question/2"},{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#/schema/question/3"},{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#/schema/question/4"},{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/tests/imocha-excel-test"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel tests for job applications","item":"https://practiceexcelonline.com/tests","position":2},{"@type":"ListItem","name":"iMocha Excel Test Practice: Free Timed Mock Test","position":3}]},{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What is on the iMocha Excel test?","acceptedAnswer":{"@type":"Answer","text":"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."}},{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Does this practice test include text formulas?","acceptedAnswer":{"@type":"Answer","text":"Yes. Almost half of the questions use text formulas such as LEFT, RIGHT, FIND, SUBSTITUTE, TRIM and PROPER, or wildcards in COUNTIF and SUMIF."}},{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How long is the practice test?","acceptedAnswer":{"@type":"Answer","text":"25 minutes for 20 questions. The free preview has the first 10 questions in 13 minutes."}},{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"What score should I aim for?","acceptedAnswer":{"@type":"Answer","text":"The passing score here is 70%, 14 of 20. Aim for 80% or more before the real test."}},{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#/schema/question/5","@type":"Question","inLanguage":"en-US","name":"Do I get a certificate?","acceptedAnswer":{"@type":"Answer","text":"Yes. Pass the full test with a verified email and you get a certificate with a public link for your résumé or LinkedIn."}},{"@id":"https://practiceexcelonline.com/tests/imocha-excel-test#/schema/course/1","@type":"Course","description":"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.","educationalLevel":"Intermediate","inLanguage":"en-US","name":"iMocha Excel test practice","teaches":"COUNT, SUM, CONCAT, RIGHT, IF, INDEX-MATCH, VLOOKUP, SUBSTITUTE, ROUND, COUNTIF, SUMIF, COUNTIFS, LOGICAL, LEFT, PROPER, AVERAGEIFS","timeRequired":"PT25M","provider":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```
## Sitemap
See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.