You are logged in as customer LOG OUT

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
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

 

  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 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"?

 

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. 

 

 

Not what you were looking for?
?