--- title: "Kenexa Excel Test Practice: Free Timed Mock Test | PracticeExcel" description: "Prepare for the Kenexa Prove It! Excel test with 20 timed tasks in a live grid. Real formulas, scored instantly, with a free 10-question preview." canonical_url: "https://practiceexcelonline.com/tests/kenexa-excel-test" locale: en meta: "og:description": "Prepare for the Kenexa Prove It! Excel test with 20 timed tasks in a live grid. Real formulas, scored instantly, with a free 10-question preview." "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~S2VuZXhhIEV4Y2VsIFRlc3QgUHJhY3RpY2U6IEZyZWUgVGltZWQgTW9jayBUZXN0%2Cdescription_~UHJlcGFyZSBmb3IgdGhlIEtlbmV4YSBQcm92ZSBJdCEgRXhjZWwgdGVzdCB3aXRoIDIwIHRpbWVkIHRhc2tzIGluIGEgbGl2ZSBncmlkLiBSZWFsIGZvcm11bGFzLCBzY29yZWQgaW5zdGFudGx5LCB3aXRoIGEgZnJlZSAxMC1xdWVzdGlvbiBwcmV2aWV3Lg%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJDdXN0b21lciIsIkNpdHkiLCJQaG9uZSIsIk5vIHBob25lIl19LHsibiI6MiwiY2VsbHMiOlsiQmFnZXIgQmVudCIsIlJpYmUiLCI3NSAxMiAzNCA1NiIsIiJdfSx7Im4iOjMsImNlbGxzIjpbIkNhZsOpIE5vcmEiLCJLb2xkaW5nIiwiIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiU21lZGplbiIsIkhvcnNlbnMiLCI3NiAyMiAxOCA5MCIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIkJsb21zdGVyaHVzZXQiLCJTaWxrZWJvcmciLCIiLCIiXX0seyJuIjo2LCJjZWxscyI6WyJDeWtlbGvDpmxkZXJlbiIsIlZpYm9yZyIsIjg2IDYxIDIwIDQ0IiwiIl19XSwidGFyZ2V0IjpbMSwzXX19%2Cp_Ii90ZXN0cy9rZW5leGEtZXhjZWwtdGVzdCI%2Cs_8ZpRijgH7oWpHrNT.png" "og:image:height": "600" "og:image:type": image/png "og:image:width": "1200" "og:title": "Kenexa Excel Test Practice: Free Timed Mock Test | PracticeExcel" "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~S2VuZXhhIEV4Y2VsIFRlc3QgUHJhY3RpY2U6IEZyZWUgVGltZWQgTW9jayBUZXN0%2Cdescription_~UHJlcGFyZSBmb3IgdGhlIEtlbmV4YSBQcm92ZSBJdCEgRXhjZWwgdGVzdCB3aXRoIDIwIHRpbWVkIHRhc2tzIGluIGEgbGl2ZSBncmlkLiBSZWFsIGZvcm11bGFzLCBzY29yZWQgaW5zdGFudGx5LCB3aXRoIGEgZnJlZSAxMC1xdWVzdGlvbiBwcmV2aWV3Lg%2Ceyebrow_Excel%2Btests%2Bfor%2Bjob%2Bapplications%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJDdXN0b21lciIsIkNpdHkiLCJQaG9uZSIsIk5vIHBob25lIl19LHsibiI6MiwiY2VsbHMiOlsiQmFnZXIgQmVudCIsIlJpYmUiLCI3NSAxMiAzNCA1NiIsIiJdfSx7Im4iOjMsImNlbGxzIjpbIkNhZsOpIE5vcmEiLCJLb2xkaW5nIiwiIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiU21lZGplbiIsIkhvcnNlbnMiLCI3NiAyMiAxOCA5MCIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIkJsb21zdGVyaHVzZXQiLCJTaWxrZWJvcmciLCIiLCIiXX0seyJuIjo2LCJjZWxscyI6WyJDeWtlbGvDpmxkZXJlbiIsIlZpYm9yZyIsIjg2IDYxIDIwIDQ0IiwiIl19XSwidGFyZ2V0IjpbMSwzXX19%2Cp_Ii90ZXN0cy9rZW5leGEtZXhjZWwtdGVzdCI%2Cs_8ZpRijgH7oWpHrNT.png" --- > Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt) # **Kenexa Excel test practice** Recruitment agencies and employers often send candidates a Kenexa Prove It! Excel test before an interview. This practice test gives you 20 hands-on spreadsheet tasks in 30 minutes: you type each formula into a live grid and every answer is checked the way Excel would calculate it, so you find out what you still need to practice before the real one. 20 questions · 30 minutes · passing score 70% = 30:0070 % **Question 1 of 20** In E2, use COUNTBLANK to count the customers with no phone number in C2:C11. E2fx | | A | B | C | D | E | F | | --- | --- | --- | --- | --- | --- | --- | | 1 | Customer | City | Phone | | No phone | | | 2 | Bager Bent | Ribe | 75 12 34 56 | | | | | 3 | Café Nora | Kolding | | | | | | 4 | Smedjen | Horsens | 76 22 18 90 | | | | | 5 | Blomsterhuset | Silkeborg | | | | | | 6 | Cykelkælderen | Viborg | 86 61 20 44 | | | | | 7 | Ostehjørnet | Randers | | | | | | 8 | Fiskebaren | Skagen | 98 44 10 12 | | | | | 9 | Tømrer Thomsen | Herning | | | | | | 10 | Glarmester Gram | Holstebro | 97 42 33 01 | | | | | 11 | Isbaren | Grenaa | | | | | | 12 | | | | | | | 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. [**Unlock the full test from $19/month**](https://practiceexcelonline.com/pricing) [**Already premium? Sign in**](https://practiceexcelonline.com/login?next=/tests/kenexa-excel-test) Premium gets you the full 20-question test, your score history and a certificate when you pass. ## **What the Kenexa Excel test checks** Kenexa Prove It! tests are built to see whether you can do everyday office work in Excel without looking things up. The Excel tests come in several versions and levels, and the employer picks the one that fits the job. Some versions ask you to carry out tasks in a simulated Excel window; others ask what a formula or a feature does. Whatever the version, the formula questions come back to the same skills: totals and averages, percentages, rounding, counting and adding up with conditions, IF, and looking values up in a table. Those are the skills this practice test drills. ## **How this practice test works** You have 30 minutes for 20 questions, from counting blanks and working out a growth rate to HLOOKUP, a commission table and a VLOOKUP whose column is found with MATCH. 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. Your answer has to be a formula that still gives the right result when the numbers change, so typing the answer as a number does not count. Afterwards you see your score, every question you missed and where to practice it. ## **How to prepare** Take the free preview of the first 10 questions to see where you stand. Practice the topics behind your misses in the lessons, then take the full test against the clock. If the employer has told you the level of the test, spend most of your time on that level: a basic test is mostly totals, percentages and simple IF formulas, while an advanced one leans on lookups and conditional sums. ## **Not affiliated with Kenexa or IBM** PracticeExcel is not affiliated with Kenexa, IBM or Prove It!, and this is not their test. We wrote every question ourselves to practice the same skills, so a good score here means you can do the work, 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 missing phone numbers**](https://practiceexcelonline.com/practice/count/countblank-empty-cells) 2. [**2****Median salary**](https://practiceexcelonline.com/functions/median) 3. [**3****Growth from last year**](https://practiceexcelonline.com/practice/first-formulas/multiply-two-cells) 4. [**4****Price including VAT**](https://practiceexcelonline.com/practice/first-formulas/multiply-two-cells) 5. [**5****Discounted price to two decimals**](https://practiceexcelonline.com/practice/round/round-two-decimals) 6. [**6****Average delivery time to one decimal**](https://practiceexcelonline.com/practice/round/round-two-decimals) 7. [**7****Count the paid invoices**](https://practiceexcelonline.com/practice/countif/countif-text) 8. [**8****Total travel expenses**](https://practiceexcelonline.com/practice/sumif/sumif-with-sum-range) 9. [**9****Look up a price by product code**](https://practiceexcelonline.com/practice/vlookup/vlookup-exact-match) 10. [**10****Boxes needed for an order**](https://practiceexcelonline.com/practice/round/roundup-boxes-needed) 11. [**11****Third-largest deal**](https://practiceexcelonline.com/practice/minmax/large-second-highest) 12. [**12****Total of the payments above a limit**](https://practiceexcelonline.com/practice/sumif/sumif-greater-than) 13. [**13****Count full-time staff in one department**](https://practiceexcelonline.com/practice/countifs/countifs-two-conditions) 14. [**14****Count orders between 100 and 500**](https://practiceexcelonline.com/practice/countifs/countifs-between-two-numbers) 15. [**15****Check the length of an account number**](https://practiceexcelonline.com/functions/len) 16. [**16****Take the number out of a product code**](https://practiceexcelonline.com/functions/mid) 17. [**17****Revenue from units and prices**](https://practiceexcelonline.com/functions/sumproduct) 18. [**18****Look up a quarter with HLOOKUP**](https://practiceexcelonline.com/functions/hlookup) 19. [**19****Commission from a rate table**](https://practiceexcelonline.com/practice/vlookup/vlookup-approximate-match) 20. [**20****VLOOKUP with the column found by MATCH**](https://practiceexcelonline.com/functions/match) ## **Questions**
### What is on the Kenexa Excel test? Everyday spreadsheet work at the level the employer picks, from totals, percentages and rounding to conditional counts and sums, IF and lookups. This practice test covers the formula side with 20 questions.
### Is the Kenexa test multiple choice or hands-on? It depends on the version the employer chooses. Some versions are hands-on tasks in a simulated Excel window, others ask questions about formulas and features. Practicing real formulas prepares you for both.
### How long is this practice test? 30 minutes for 20 questions. The free preview has the first 10 questions in 15 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 job interviews: what gets tested and how to prepare**](https://practiceexcelonline.com/learn/excel-for-job-interviews) - [**VLOOKUP vs XLOOKUP vs INDEX MATCH: which lookup to use**](https://practiceexcelonline.com/learn/vlookup-vs-xlookup-vs-index-match) ## **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) - [**SHL Excel test practice**](https://practiceexcelonline.com/tests/shl-excel-test) - [**iMocha Excel test practice**](https://practiceexcelonline.com/tests/imocha-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/kenexa-excel-test#webpage","description":"Prepare for the Kenexa Prove It! Excel test with 20 timed tasks in a live grid. Real formulas, scored instantly, with a free 10-question preview.","name":"Kenexa Excel Test Practice: Free Timed Mock Test","url":"https://practiceexcelonline.com/tests/kenexa-excel-test","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/tests/kenexa-excel-test#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"mainEntity":[{"@id":"https://practiceexcelonline.com/tests/kenexa-excel-test#/schema/question/1"},{"@id":"https://practiceexcelonline.com/tests/kenexa-excel-test#/schema/question/2"},{"@id":"https://practiceexcelonline.com/tests/kenexa-excel-test#/schema/question/3"},{"@id":"https://practiceexcelonline.com/tests/kenexa-excel-test#/schema/question/4"},{"@id":"https://practiceexcelonline.com/tests/kenexa-excel-test#/schema/question/5"}],"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/tests/kenexa-excel-test"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/tests/kenexa-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":"Kenexa Excel Test Practice: Free Timed Mock Test","position":3}]},{"@id":"https://practiceexcelonline.com/tests/kenexa-excel-test#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"What is on the Kenexa Excel test?","acceptedAnswer":{"@type":"Answer","text":"Everyday spreadsheet work at the level the employer picks, from totals, percentages and rounding to conditional counts and sums, IF and lookups. This practice test covers the formula side with 20 questions."}},{"@id":"https://practiceexcelonline.com/tests/kenexa-excel-test#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Is the Kenexa test multiple choice or hands-on?","acceptedAnswer":{"@type":"Answer","text":"It depends on the version the employer chooses. Some versions are hands-on tasks in a simulated Excel window, others ask questions about formulas and features. Practicing real formulas prepares you for both."}},{"@id":"https://practiceexcelonline.com/tests/kenexa-excel-test#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How long is this practice test?","acceptedAnswer":{"@type":"Answer","text":"30 minutes for 20 questions. The free preview has the first 10 questions in 15 minutes."}},{"@id":"https://practiceexcelonline.com/tests/kenexa-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/kenexa-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/kenexa-excel-test#/schema/course/1","@type":"Course","description":"Recruitment agencies and employers often send candidates a Kenexa Prove It! Excel test before an interview. This practice test gives you 20 hands-on spreadsheet tasks in 30 minutes: you type each formula into a live grid and every answer is checked the way Excel would calculate it, so you find out what you still need to practice before the real one.","educationalLevel":"Intermediate","inLanguage":"en-US","name":"Kenexa Excel test practice","teaches":"COUNT, MEDIAN, FIRST-FORMULAS, ROUND, COUNTIF, SUMIF, VLOOKUP, MINMAX, COUNTIFS, LEN, MID, SUMPRODUCT, HLOOKUP, MATCH","timeRequired":"PT30M","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.