SHL Excel Sample Questions

Here you will find some sample questions to start practicing your Excel skills. Good luck! If at any point you don’t know what to do next or don’t understand the instructions, don't get discouraged, check out our Excel Preparation Package featuring tests and tutorials that will prepare you for your test.
Practice CEB’s SHL Style Excel Tests

Three Multiple Choice tests, Two Interactive Tests + over 180 additional practice questions and 3 full length Excel tutorials!

Only £29

Interactive Test Questions

Below are a few examples of questions that might appear on your interactive Excel test. In order to proceed, please copy the following table to a new Excel SpreadSheet. Make sure that the cell marked (A1) is pasted in Cell A1 on the Spreadsheet.

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

  1. Basic Level Questions
    1. Align the yext to the right.
    2. Insert a new row between Missam and Dubaru.
    3. Change the page orientation to vertical.

  2. Intermediate-Advanced Level Questions:
    1. Highlight every cell with annual sales over 70 (mil. $) green.
    2. Under “Full Model Name”, in cell D3, write a function that combines the “Maker” and the “Type” (like in cell D2).
    3. Create a PivotTable for "Annual Sales per Year".

Multiple Choice Test Questions

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

Back to top

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

Free Resources
Free Psychometric Tests
Top Products
SHL Excel Test

Secured Payment 

"Your products increased my score a lot in the test."
Ornela, Premium membership, September 2015

As Seen On - Graduate jobs, Postgrad study, Work Experience, Graduate Career InformationACCA Careers - Accountancy and Finance JobsWikiJob - Interview questions for jobs and internships in investment banking, finance, law, consultingLawyer 2B - Law Training Contracts and Careers in LawAlumnEye - Réussir ses entretiens Finance et Conseil
Created by red-id