Free Excel Test for Interviews

Prepare With JobTestPrep's Sample Questions

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

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.

*US Dollars

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™

• Kenexa Prove It Style Excel Test
• Advanced Excel Assessment Test
• Basic Excel Assessment Test

Related Links: