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%

Question 1 of 20

In E2, use COUNTBLANK to count the customers with no phone number in C2:C11.

	A	B	C	E
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 Already premium? Sign in

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.

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.