Prepare for Excel Assessments
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.
Click here for our CEB SHL style Excel test preparation. This pack is also suitable for Kenexa Prove It Excel tests.
Excel Tests Key Features
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.
Things You Need to Know
- Be certain of the test's location. While some companies will ask you to take the test at their offices, online tests taken from home are becoming more and more popular. If you plan to take the test online, prepare accordingly. Make sure you are in a quiet environment and that there will be no interruptions during the test.
- Though time is not always limited, it is being measured, and it will eventually influence your final score. Try to be as fast as you can whilst also maintaining accuracy.
- Scores are relative, so being good is not enough. You have to be better than others.
- Most testing companies provide tests for Excel 2010 and 2013. Though the differences are relatively minor, it is always preferred to practise the right version. Even if you have worked with Excel before, don't give up practising. The same task feels different when performed under the pressures of a test. Refresh your skills, become familiar with features you didn't use before, and master the ones you already know.
Excel Test by Levels
Basic Excel Test
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:
- Creating basic formulas - using SUM, AVERAGE, COUNT and so on
- Formatting cells - borders, shading, wrapping text, creating uniform alignments, changing cell contents to bold, merging cells and so on
- Creating basic charts
- Performing simple tasks - saving a file in more than one format, opening a new tab, and more
Intermediate Excel Test
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:
- Creating more sophisticated formulas - IF, VLOOKUP and more
- Formatting cells - conditional formatting, text columns, adjusting page and print layouts
- Performing more sophisticated tasks - using text strings, customising charts, data validation, working out percentages and more
Advanced Excel Test
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:
- Advanced formulas such as "if" and "concatenate"
- Using formatting functions such as locking cells, using group and outline
- Creating and using PivotTables and PivotCharts
- Setting up a database
Online Excel Test Providers
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:
- CEB’s SHL Microsoft Excel tests
- IBM’s Kenexa Prove It! Excel tests
- Thomas International skills online Excel tests
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.
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.
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
- Fill in with red every income higher than 70 using conditional formatting
- Under "full name," combine the first and last name using the CONCATENATE function
Additional sample questions are available here
JobTestPrep is not a part of Microsoft and is not related to them in any way. JobTestPrep offers preparation services for psychometric tests.
