Kenexa Prove It! Excel test practice
The Kenexa Prove It! Excel test is a simulation: you do tasks in an Excel-like window rather than answering multiple-choice questions. It comes in Normal User and Power User versions. The best practice is timed, hands-on tasks with no hints: formulas, formatting, sorting and filtering, and for Power User, lookups and PivotTables.
ExcelReady is independent and not affiliated with, endorsed by or sponsored by IBM. We don't have their questions. Our practice tests use the same format and skills, so you can prepare for whichever version you get.
What the Kenexa Prove It! Excel test is like
- It's an interactive simulation of Excel, not a multiple-choice quiz. You click, type and use menus as you would in Excel.
- There are two common versions: Normal User and Power User. Employers pick the one that fits the role.
- Test-prep sites report about 30 tasks for Normal User and about 25 for Power User. IBM doesn't publish these numbers, and employers can set up their own version.
- Because it's a simulation, how you do a task can matter, not only the result. Using the ribbon or a standard shortcut is the safe choice.
Practise in the same format
Timed, no hints, marked at the end. Runs in any browser on Mac or Windows, with no Excel licence needed.
Basic Excel skills test
10 tasks in 15 minutes on an orders table: totals, averages, COUNTIF and SUMIF, an IF flag, absolute references and a filter.
Admin, office, customer service and entry-level roles.
Intermediate Excel skills test
12 tasks in 25 minutes on an HR roster: XLOOKUP across sheets, SUMIFS and COUNTIFS, IFS, text and date formulas, conditional formatting and a PivotTable.
Analyst, operations, HR, finance and sales support roles.
Advanced Excel skills test
11 tasks in 30 minutes on a sales ledger: dynamic arrays, two-way and multi-criteria lookups, SUMPRODUCT, sorting by two keys and a two-way PivotTable.
Financial analyst, data analyst, business intelligence and consulting roles.
Skills to practise
- Formulas with SUM, AVERAGE and cell referencesYour first formulas
- Absolute references ($A$1) when you fill formulasRelative vs absolute references ($)
- Formatting numbers, dates and cellsFormatting shortcuts
- Sorting and filtering a tableFilter a table
- IF and COUNTIF/SUMIFThe IF function
- VLOOKUP and XLOOKUP (Power User)VLOOKUP exact match
- PivotTables (Power User)Pivot tables 1
Tips for the day
- Read the whole task before you click. Simulations often ask for one specific cell or range.
- Point formulas at cells instead of typing numbers, so they still work if the data changes.
- Don't get stuck: skip a task you can't do and come back if there's time.
- Practise on a Windows-style layout if you use a Mac. Simulations usually copy Windows Excel.
Questions people ask
Is the Kenexa Prove It Excel test multiple choice?
Mostly no. It's a simulation where you do tasks in an Excel-like window. Some versions may include a few questions, but the core is hands-on.
What's the difference between Normal User and Power User?
Normal User covers everyday tasks like formulas, formatting, sorting and filtering. Power User adds harder work such as lookups, PivotTables and more complex functions.
Can I find the real Kenexa Prove It questions?
No legitimate site has them, and "answer key" files online are unreliable. Practise the skills in a timed, hands-on test instead, so you can handle whatever version the employer uses.
What score do I need to pass?
Each employer sets its own pass mark, and it isn't usually shared. Aim to pass our practice tests at 70% or more with time to spare.
Sources
Test names are trademarks of their owners. Test details change and employers set their own versions, so check your invitation for the time limit and format.