Practice Prove It Style Excel Test - Power User








Select the PrepPack™ You Need
Arbel Yellin

Arbel, Microsoft Exam Expert at JobTestPrep.

Have a question? Contact me at:

Important Facts on Kenexa Prove It! Excel Tests

Kenexa holds a question bank divided into basic, intermediate, and advanced level questions. The Power User Excel Test contains 25 questions. On this test, approximately 10 of the questions are basic, five are intermediate and 10 are at the advanced level. As you can see, questions on the Power User test are mostly of intermediate-advanced difficulties. This also means that while the difficulty range is wide enough to include basic formatting features and simple tasks such as Save As... and Printing, a large proportion of the test will still be about more complex tasks such as PivotTables, Macro Creation, and advanced software properties.

JobTestPrep enables you to practice according to your level of expertise and by doing so increase your chances of achieving a high test score.

Kenexa Prove It Excel Test Sample Questions

Here are some sample questions that resemble the style of items seen on 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," on 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
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

Excel Power 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"

For more sample questions, click here.

How Does This Product Work?

We have partnered with one of the world's leading Microsoft Office assessment providers, giving you an opportunity to practice the same tests that employers use in pre-employment selection processes.

  1. After purchase, you will be directed to fill out a form on your personal page.
  2. Once filled, an access code will be sent to you within 24 hours.
  3. You will then have to download the Excel training software to your computer.
  4. Once download is complete, you can start practicing.
  5. Please review the system requirements before making a purchase.

Note that there are no refunds once the access code has been used.

Practice Modes

There are two practice modes you can use

  • Testing: here you'll find four full length tests (two for each software), 25 prompts each. Time is limited, no explanations provided during the test, and there is no immediate feedback after each question.
  • Training: this mode will allow you to "learn while doing" .here you'll find both the 4 full tests mentioned, as well as additional practice drills divided by topic. Unlike "test" mode, Time is not limited, you are allowed to access full explanation at each point and you will get instant feedback after every question.

JobTestPrep's Practice Packs Advantages

The Microsoft Excel software features a huge amount of options and commands. It is impossible to master all of them in a short time. That makes studying for the Power User test with random web presentations and tutorials unproductive and tedious – it would be like studying the entirety of American history just to take a test on the Civil War.

For that reason, JobTestPrep has created practice packs designed specifically to prepare you for the Power User Excel Test, focusing on the topics that are most relevant to the test.

The Practice Packs Includes

  • Two full-length interactive tests – covering all the crucial topics you will need for the test in a step-by-step fashion
  • Additional 180 questions – divided into five tests by topic
  • Two training modes – "testing" allows you to experience an actual test environment, while in "training" mode you can learn while completing the tests.
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?