Below are free sample questions similar to the questions seen on a typical Prove It Microsoft Excel assessment. Our products offer the ability to practice with software similar to the one used on the Real Test. Click on the "Start Practicing" key and increase your chances of success.
Below is a selection of sample questions similar to the Kenexa questions you might face on your Kenexa test. To get a real full preparation for the Microsoft Excel exam, simply click on “Start Practicing” button.
To answer the sample questions, copy the following table to a new Excel spreadsheet. The cell marked with (A1) must be pasted in cell A1 on the spreadsheet. Once the table has been copied, continue to the following question.
A | B | C | D | E | F | |
1 | Name | Surname | Position | Full Name | Age | Annual Salary* |
2 | John | Smith | Manager | John Smith | 35 | 85 |
3 | Jimmy | Michaels | Salesperson | Jimmy Michaels | 26 |
60 |
4 | Michelle | Levine | Manager | Michelle Adams | 37 | 80 |
5 | Levi | Johnson | Tech | Levi Johnson | 40 | 75 |
6 | Jenna | Masterson | Salesperson | Jenna Masterson | 26 | 60 |
*In thousand USD
Which of the keys below suitable for AutoSum?
What is the correct formula for calculating the weighted average grade?
Which of the following is correct to insert a new row?
What is the correct option to edit a formula in a cell?
What is the correct option to insert a table?
What is the correct option to open up the Find and Replace window?
Our test kits include selection of sample questions similar to Kenexa questions that may appear in the real test. To get full preparation for the Microsoft Excel exam, simply click on “Get the Full Preparation Pack” and significantly improve your chances of passing the exam.
Doing well on the Excel test can be the deciding factor for whether you get the job or not. Therefore, it is imperative that you practice. Prepare for your assessment with our JobTestPrep Excel practice and get the position you are seeking.