Prepare With JobTestPrep's Sample Questions

Below you will find Excel questions similar to the ones that will appear on the test. Practice with the questions below to see where to focus your preparation efforts and see where you need to improve. 


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.

Name (A1) Surname Position Full Name Age Annual salary
(th. USD)
John Smith Manager John Smith 35 85
Jimmy Michaels Saleperson 26 60
Michelle Levine Manager 37 80
Levi Johnson Tech 40 75
Jenna Masterson Salesperson 26 60

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 Sales over 70 (th. $).
  2. Under “Full Name”, in cell D4, write a function that combines the “Name” and the “Surename” (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