What is the SHL Excel Test

Excel tests can vary in complexity and length depending on the job description, with some companies creating their own in-house test and others turning to external testing companies, such as SHL - one of the world's leading assessment companies. The SHL Microsoft Excel test comes in three versions:

  • SHL interactive - a timed SHL Excel assessment that includes 30 questions with a 35 minutes limit
  • SHL interactive essentials - a slightly shorter version of the SHL interactive, with 20 questions that need to be answered in 25 minutes
  • SHL adaptive - in this test, the level of questions changes based on your performance in the previous question - becoming harder or easier.  

Our Microsoft Excel test prep pack offers comprehensive and accurate practice for different levels of Excel skills, helping you reach the high score you want and taking you one step closer to landing the job.  


Sample SHL Excel Test Questions and Answers

Below are sample SHL Microsoft excel test questions and answers to give you a sense of what you will face on your test. Once you have finished answering the questions, open the Questions and Answers page to see the full answers. 

 

To get started, copy the table below and paste it into a new Excel spreadsheet. Make sure the table is aligned correctly and that the top left cell is pasted in cell A1 on the spreadsheet.

Maker Type Class Full Model Name Year Annual Sales (Mil $)
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

Excel Sample Test Questions - Basic

  1. Align the text to the right
  2. Insert a new row between Missam and Dubaru. 
  3. Set the page orientation to landscape.

Excel Sample Test Questions - Intermediate

  1. Highlight all cells with yearly sales above 70 mil.$.
  2. 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.

Now that you are done working on the spreadsheet, try the following general Excel practice test questions:

General Sample Practice Test Questions - Basic

A. How would you select non-contiguous cells?

  1. Hold Ctrl → left-click on each cell
  2. Hold Shift → left-click on each cell
  3. Right-click on each cell
  4. Hold Alt → left-click on each cell

 

B. Which of the following commands doesn't affect the text font?

  1. Bold
  2. Underline
  3. Borders
  4. Italics

 

C. How should the following formula be written: Multiply Cell A1 by 6, and divide that by 4? 

  1. =A1X6/4
  2. =A1X6%4
  3. =A1*6/4
  4. =A1*6%4

 

General Excel Sample Test Questions - Advanced

 

A. Fill Handle will generate content based on the following:

  1. Mathematical Series
  2. Alignment Pattern
  3. Design Pattern
  4. All of the Above

 

B. The “Save As” command will NOT allow you to… 

  1. Save as a PDF
  2. Save as a template
  3. Save as a Word document
  4. Save at a specific location

 

C. The Conditional Formatting feature is used to: 

  1. Set the default cell format
  2. Format conditional statements
  3. Format cells conditional on the text size
  4. Change the style of cells meeting a condition

 

Done answering the questions? Open the Questions and Answers page to see how you did, and access complete SHL Excel test answers and solving tips.

Looking for a complete SHL practice? Go to our free SHL test practice.


  

Ace the SHL Excel Test with JobTestPrep

Even though our free SHL Excel test practice questions are useful in giving you a taste of what's to come, they aren't enough to guarantee that you will pass your test. The real test will challenge you to analyze data, format cells, and carry out advanced functions, while also expecting you to have a strong grasp of basic Excel such as knowing the right keyboard shortcut, wrap text, and simple data entry.

This is why you will need thorough and accurate practice, and with our Excel PrepPacks™, you will have all the prep you need. 

 

 

JobTestPrep is not a part of SHL and is not related to them in any way. JobTestPrep offers preparation services for assessment tests.
;
Not what you were looking for?
?