You are logged in as customer LOG OUT

Prepare With JobTestPrep's Sample Questions

Below you will find Excel questions similar to the ones that will appear on the test. Take a look at the questions below to see where you are lacking and need improvement. Start an all-around preparation effort using Excel PrepPack™ and gain instant access to our best online resources to guarantee you pass your assessment!


Practice Online for the Excel 2016 Assessment Tests

Surpass the competition with the aid of our exclusive job recruitment preparation materials. We offer 24/7 access to a vast array of practice tests, study guides, and more to ensure your victory. Join us and begin practicing today!



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


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

Learn About the 5 Most Common Topics on Excel Assessment Tests

Multiple-Choice Test Questions

Submit your answers to the questions below and fill the consequent form. A PDF file with answers and explanation for all questions will be sent to the email provided by you.

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 JobTestPrep's Excel Practice and get the position you are seeking. 

Looking for more practice? Get the preparation you need with our other Excel PrepPacks™

Related Links:

Free Mechanical Aptitude Test Free Postal Exam  473
Free Situational Judgement Test Free Police Exam
Free Cognitive Assessment Test Free Clerical Test Practice
Not what you were looking for?