SHL Excel Sample Questions - Free Excel Test

Interactive Test Questions

To complete the following questions, you must first copy the table below into a new Excel Spreadsheet. Make sure the cell marked with (A1) is pasted in cell A1 on the spreadsheet. After the table is in place, proceed to the following question.

Maker (A1) Type Class Full Model Name Year Annual Sales
Missam SLX Business Missam SLX 2014 55
Dubaru Double Van   2015 60
Tia Jet Van   2013 76
ZMV Cruise Compact   2016 75
Fonda Life Compact   2015 60

Basic Level Questions

  1. Align the Text to the right.
  2. Insert a now row between Missam and Dubaru.
  3. Change the Page Orientation to Vertical.

Intermediate-Advanced Level Questions

  1. Highlight every cell with Annual Sales over 70 (mil. $) green.
  2. Under “Full Model Name”, in cell D4, write a function that combines the “Maker” and the “Type” (like in cell D3).
  3. Create a PivotTable for Annual Sales per Year.

Multiple Choice Test Questions

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


Get Ready to Succeed with JobTestPrep

Even though our free tests invite you to try your hand at answering these questions, they still cannot guarantee that you will pass your examination with success. Our thoughtfully compiled PrepPacks™, by contrast, provide a more systematic preparation for tests and will lead you to employment. Make an investment in our materials and start carving a career in your desired position.


JobTestPrep is not a part of and/or SHL and is not related to them in any way. JobTestPrep offers preparation services for assessment tests.

Not what you were looking for?