Prove It Excel Test Preparation – Practice, Examples and Tips








Select the PrepPack™ You Need

Important Facts about the Prove It Excel Test

Kenexa's Prove It Excel test assesses 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:

Test Name Desription
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.

Inside Info and Tips

  • Unlike working on the actual Excel software, the Prove It interface leaves no room for errors. Some of the shortcuts cannot be used, formulas have to be typed correctly without the program’s help, and there’s only one acceptable answer to Excel test questions which can usually be answered in more than one way.
  • Make sure you refresh your skills before you take the test. Practice the various commands and be familiar with more than one way of executing them.
  • You can use a second device (cell phone or laptop) for parallel assistance. Note that even though time is not limited, it is being measured, and therefore will influence your final rate.

What Our Prove It Excel Test Prep Includes?

  • A downloadable Excel training software.
  • Two full-length Excel assessment tests (25q each).
  • 180 additional Excel practice questions by topic.
  • Detailed explanations per question.
  • Smart score reports.
  • Realistic & interactive – simulates the actual test. 

Excel & Word Prove It Assessment Tests

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.

Now available:

Sample Questions

Below are some sample questions which are similar in style to tasks seen in an actual Prove It Excel test.
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).

First name (A1) Last name Faculty Full name Age Score
David Breindel Biology   23 89
Robert Share Law   25 95
Tom Ashman Chemistry   21 100
Julia Lombardo Electronics   26 76
Linda Cohen Psychology   25 85
Max Colman Business   24 87

Normal User Sample Questions: 

  1. Change the font style of the first row to Cambria.
  2. Right align the text.
  3. Rename the worksheet to "Testprep".

Power User Sample Questions:

  1. Fill n with red every score higher than 85 using conditional formatting.
  2. Under "full name." combine the first and last name (concatenate function).
  3. Show the numbers under the “Score" column as percentages.

For more sample questions and detailed solutions click here.

Related Links 

Prove It Word Test Prove It Accounting Test
Prove It Typing Test Prove It Data Entry Test
 Kenexa Tests Preparation  
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.


Not what you were looking for?