Excel assessments tests are a part of many companies' recruitment processes. It can be taken at any point during the process, with many candidates encountering an Excel test the same day as their interview. The point of the test is to examine your Excel skills as they are relevant to the job for which you are applying to. Read on to learn more about these tests and the types of questions on them. This pack is also suitable for Kenexa Prove It Excel tests.
Excel is a large part of everyday office work, so it is very likely you will be asked to take an online Excel test as part of your application process.
The Excel test can be structured as either a multiple choice test or one that uses interactive software to simulate the usage of Excel's interface. Though both types are available, the simulation test is more common. You'll be asked to complete a series of tasks on an Excel spreadsheet according to your level of expertise. Unlike working on the actual Excel software, these interfaces leave no room for errors, not all shortcuts are acceptable, and there can be no formula errors or spelling mistakes as most software offer no programme help. Furthermore, there is only one acceptable answer to questions that can usually be answered in more than one way.
The multiple-choice test may be perceived as easier than the interactive test. However, it will force you to master the terminology and structure of the programme.
The basic Excel skills test is often used for entry-level or administrative positions, i.e jobs that require people to be familiar with the most common Excel tasks. The types of tasks you may be asked to perform on the basic test include:
The intermediate Excel test is usually used for applicants who must be able to work with Excel at a level higher than the most technical or basic.
In addition to the tasks on the basic test, the tasks as this level include:
The advanced Excel skills test is aimed at applicants for jobs which require the use of Excel at its fullest capacity. For example, accountants or other jobs for which Excel is used for financial calculations or managing large databases.
Tasks on the Excel advanced test include:
Many of the psychometric test companies you may be familiar with also provide Excel skills tests. Some of the most common ones you may come across are:
Preparation ahead of any test is important to ensure you are calm and confident on test day. With JobTestPrep’s specially created Excel practice packs, you can familiarise yourself with the tasks you are likely to come up against on your test. Our pack is also designed to help you learn new skills that may appear on your test and that you might not be familiar with.
See some SHL style sample questions>>
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.
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 |
Additional sample questions are available here