Excel 2007, Excel 2010, Excel 2013 and Excel 2016 skills assessments

The online test is available for Excel 2007, 2010, 2013 and 2016 in English, French and Dutch. It can be used to assess new job candidates or to identify training needs. As the test is adaptive, it can also be used to gauge candidate progress after completion of an Excel training course. Questions are accompanied by images and videos. Some questions include in-application testing in which the candidate is asked to perform certain tasks in Excel.

Software environment (save, print, protect, etc.)

This category covers the configuration of print and save options, protecting a workbook, and the Excel environment (workbook window components, customizing the ribbon, Quick Access Toolbar, etc.).

Functions

Questions in this category cover formulas and functions. As the test is adaptive, depending on candidate skills, subjects tested can vary from simple formulas (computing a sum, performing a simple test) to complex formulas (DATABASE, VLOOKUP, INDEX).

Data management

Question in this category cover data management. The easiest questions cover basic data sorts and the creation of simple charts. The more difficult questions cover advanced filters, goal seek, etc. There are also many questions and exercises on pivot tables.

Formatting

Question in this category cover Excel formatting. The easiest questions cover basic cell formatting (alignment, font, styles). The more difficult questions cover advanced number formatting and conditional formatting.