7 PrepPacks™
1,230 Prepared
400+ Questions

Important Facts on Advanced Excel Tests

The advanced level test is aimed for candidates who will manage a large amount of data and use the software at high capacity. It therefore requires a candidate to master the different features of the software. This doesn't mean you won't see any basic or intermediate questions on the advanced level test. They will, however, be the minority. Most of the questions will deal with formulas, macro creation, advanced formatting and document properties. Make sure to review the different topics so you will be as ready as you can.

Test Topics

Advanced level Excel tests usually feature some questions regarding basic Excel topics related to the software’s interface and use. However, the assessment will mainly revolve around higher level topics such as creating and executing Macro commands, PivotTables, advanced Excel functions, utilising Excel’s in-depth software features, and more. These tests can sometimes prove challenging for even the most experienced Excel users, so be sure you are well prepared and acquainted with the different topics and types of questions before taking the test. Our advanced Excel practice pack was created for experienced users who want to focus their training around the relevant topics for their test. Our practice pack covers all advanced test topics, but also features much more.

Excel Assessment Test Sample Questions

Here are some sample Excel test questions which could appear on an interactive test. In order to properly practice the following questions, copy and paste the chart below to a clean Excel worksheet - left click, hold and drag to mark the table, right click and choose "copy". On the Excel worksheet choose the first cell on the left (A1), right click and choose paste. Make sure that the cell named A1 is indeed located at cell A1 on your worksheet.

First name (A1) Last name Department Full name Age Annual income (th. $)
Elisabeth Aragon Finance Elisabeth Aragon 23 55
Marlo Acogny R&D   21 76
Molly Freedman Finance   25 60
Kathleen Allen R&D   26 75
Renee Hobbs R&D   25 60

Intermediate - Advanced Level Sample Questions

  1. Fill in with red every income higher than 70 using conditional formatting
  2. Under "full name," combine the first and last name using the CONCATENATE function

For more sample questions, with answers and full explanations, click here.

The JobTestPrep Advantage

There are hundreds of different features and commands in Microsoft Excel, and it’s nearly impossible to master all of them. You wouldn’t study the entirety of British history just to take a test on World War I, would you? JobTestPrep’s practice materials were specifically designed to address the topics relevant to advanced level Excel assessment tests. Our practice packs include:

  1. Two full-length interactive tests containing intermediate to advanced level questions. These tests can be taken in one of two modes: “testing” mode simulates the actual test experience, while “step-by-step” mode provides a learn-while-doing experience.
  2. An additional 180 practice questions divided into drills by topic. These drills can also be taken in “step-by-step” mode to further enrich your Microsoft Excel skills.

Excel & Word Combo Pack

Microsoft Office assessments usually included both Excel and Word tests. Our Excel+Word combo practice pack allows you to save both time and effort preparing for your assessment tests.

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