Get Our Free Word Sample Assessment Questions
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.
Practice Online for the Excel 2016 Assessment Tests
Prepare for 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 Word exam, simply click Get The Full Preparation Pack below.
Excel Sample Questions
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 | 37 | 80 | |
| 5 | Levi | Johnson | Tech | Levi Johnson | 40 | 75 |
| 6 | Jenna | Masterson | Salesperson | Jenna Masterson | 26 | 60 |
*In thousand USD
Basic Level Questions
- Align the text to the right.
- Insert a new row between John and Jimmy.
- Set the page orientation to "Landscape".
Intermediate-Advanced Level Questions
- Highlight every cell with an Annual Salary over 70 thousand USD.
- Under “Full Name”, in cell D4, write a function that combines the “Name” and the “Surname” (like in cell D3).
- Create a PivotTable for "Annual Salary" per "Age".
- What is the fastest way to change all instances of the word "Psychometric" within column B to the word "Aptitude"?
Learn About the 5 Most Common Topics on Excel Assessment Tests
Prepare for 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 Word Exam, simply click Get The Full Preparation Pack below.
Prepare for Your Excel Test
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.
