Kenexa's Prove It Excel test measures your ability to complete tasks in Microsoft's Excel software at various levels. You will receive an email with a link to start an online test. In most cases, you will be asked to take a battery of Microsoft Office and typing assessments, with Excel being one of them.
The test is entirely interactive, and simulates the functionality of real Excel software. Tasks will pop up at the bottom of the screen and you will have to complete each task prior to moving on to the next. There will be no multiple-choice questions on the test.
There are two levels of Kenexa Microsoft Excel tests; both are untimed:
|Normal User||Basic Excel test. Gives you 30 prompts|
|Power User||Advanced Excel test. Gives you 25 prompts|
The basic test is designed mostly for clerical positions. The test's tasks vary from using simple Excel functions, performing general commands such as printing options, and formatting cells and layout. The advanced (power user) test might also require knowledge of pivot table, macro creation, filtering, and functions such as VLOOKUP, COUNTIF and CONCATENATE.
JobTestPrep offers different preparation solutions of Excel practice tests, tailored to the expertise level and Excel edition (2010/13/16). This will allow the highest fit for the actual test, and will provide you with suitable practice.
In most cases, your assessment will include both Excel and Word tests. If this is the case for you, check out our new combo pack to help you improve your performance in both Excel and Word, as well as save you money.
Here are some sample questions which resemble the style of tasks seen in a real Prove It Excel test.
In order to properly practice the following questions, copy and paste the chart below to a clean Excel worksheet (left click, hold and drag to mark the table, right click – choose "copy" , at the Excel worksheet choose the first cell on the left (A1), right click – choose paste).
Make sure that the cell named A1 is indeed located at cell A1 at your worksheet.
|First name (A1)||Last name||Faculty||Full name||Age||Score|
For more sample questions and detailed solutions click here.
|Prove It Word Test||Prove It Accounting Test|
|Prove It Typing Test||Prove It Data Entry Test|
IBM, Kenexa, Microsoft, and other trademarks are the property of their respective trademark holders. None of the trademark holders are affiliated with JobTestPrep or this website.