You are logged in as customer LOG OUT

 

 

Get Prepared With Our Full Exam

Access our comprehensive Intermediate/Advanced Excel Exam and get a complete practice experience. Start practicing with exclusive online practice tests, that will give you a sense of confidence on the test day. Simply click on Buy The Full Test below.

 

Sample-SHL Style 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
(mil,USD)
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

Answer the questions below and click on NEXT for more Sample Questions. When you select the answers, fill the consequent form and a PDF file with answers and explanations will be sent to the email provided by you.

 


Get Prepared With Our Full Exam

Access our comprehensive Intermediate/Advanced Excel Exam and get a complete practice experience. Start practicing with exclusive online practice tests, that will give you a sense of confident on the day of your test. Simply click on Buy The Full Test below.

 

 

 

 

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.

Not what you were looking for?
?