Free Excel Test Sample Questions

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

 

Practice More Sample Questions

Basic Level Questions

  1. Align the text to the right.
  2. Insert a new row between John and Jimmy.
  3. Set the page orientation to "landscape".

Intermediate-Advanced Level Questions

  1. Highlight every cell with an annual salary of over 70 thousand USD.
  2. Under “Full Name”, in cell D4, write a function that combines the “name” and the “surname” (like in cell D3).
  3. Create a PivotTable for "annual salary" per "age".
  4. 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?

  1. = (c2+c3+c4)/3
  2. = 230*0.5*0.3*0.2
  3. = 76.7*0.5+65*0.3+90*0.2
  4. = 75*0.5+65*0.3+90*0.2

Which of the following is correct to insert a new row?

  1. Alt+H+I+R
  2. Alt+H+I+C
  3. Alt+H+I+I
  4. Alt+H+I+S

What is the correct option to edit a formula in a cell?

  1. F2
  2. F4
  3. CTRL+2
  4. CTRL+G

 What is the correct option to insert a table?

  1. ALT+N+R
  2. ALT+N+C
  3. ALT+N+V
  4. ALT+N+T

What is the correct option to open up the Find and Replace window?

  1. ALT+H+FD+R
  2. CTRL+F
  3. ALT+H+R
  4. 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. 

 

Microsoft and other trademarks are the property of their respective trademark holders. None of the trademark holders are affiliated with JobTestPrep or this website.