Get Our Free Excel 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.
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 Excel exam, simply click on “Start Practicing” button.
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 | Michelle Adams | 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 of 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"?
Which of the keys below suitable for AutoSum?
- Alt plus S
- CTRL plus S
- ALT plus =
- CTRL plus =
What is the correct formula for calculating the weighted average grade?
- = (c2+c3+c4)/3
- = 230*0.5*0.3*0.2
- = 76.7*0.5+65*0.3+90*0.2
- = 75*0.5+65*0.3+90*0.2
Which of the following is correct to insert a new row?
- Alt+H+I+R
- Alt+H+I+C
- Alt+H+I+I
- Alt+H+I+S
What is the correct option to edit a formula in a cell?
- F2
- F4
- CTRL+2
- CTRL+G
What is the correct option to insert a table?
- ALT+N+R
- ALT+N+C
- ALT+N+V
- ALT+N+T
What is the correct option to open up the Find and Replace window?
- ALT+H+FD+R
- CTRL+F
- ALT+H+R
- ALT+H+FD+F
Prepare for Success
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.
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.