Interactive Test Questions

Below are sample questions to give you a sense of what you will face on your test. 

Please copy the table below and paste it in a new Excel spreadSheet. Make sure the table is aligned correctly and that the cell marked A1 is pasted in Cell A1 on the spreadsheet.

  A B C D E F
1 Producer Model Type Full Model Name Year Yearly Sales (Mil, US Dollars)
2 Vonda GLE Mini Vonde GLE 2009 65
3 Zord Triple Pick-Up   2010 85
4 Gaudi Zoon Mini   2012 45
5 Menz Citrus Family   2009 65
6 Buzuki Sun Family   2008 70

Basic Level Questions

  1. Change the table's alignment to Center.
  2. Insert a new column Below Menz.
  3. Set the Page Orientation to Landscape.

Intermediate-Advanced Level Questions

  1. Highlight all cells with Yearly Sales above 60 (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.

 


Multiple Choice Test Questions

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

Prepare For Success

If you need more extensive preparation look no further than our complete test package. This test is just a sample and by no means is a full preparation for the real test. Ensure you are fully prepared with our top quality PrepPacks™.

 

JobTestPrep is not a part of Microsoft and is not related to them in any way. JobTestPrep offers preparation services for psychometric tests.