Assess the skills of Microsoft Excel 2010 or 2013 your candidates. Our tests are grouped into four themes: Formatting, Calculation, Database and Graphic. Each theme includes several skills that you can evaluate.

Free Signup!
Image

Skills




Calculations


Extend a formula to multiple cells
AVERAGE Function
SUM Function
Operator %
Operators * and /
Operators + and -
Locking $ both dimensions
Locking $ one dimension
Simple IF Function
Basic SUMIF/COUNTIF Functions
SUMPRODUCT function
Operator ^
Multiple cells range argument
COUNT function
Advanced IF Function
Define/modify a name for a cell range
Automatic SUM on SUBTOTALS
Apply data validation to cells
Define and use names in formulas
SUMPRODUCT function and conditions
TIME function
TEXT function
STATISTICAL functions

Database


Basic Filters
Automatic Filters
Sorting Column Data Ascending / Descending
Refreshing PivotTable Data
Create a simple list
Advanced Filters
VLOOKUP Function
Adding/Removing Fields in a PivotTable
Adding/Removing Filters in a PivotTable
Creating a PivotTable
Find / Replace
Displaying Table Data Totals
TRANSPOSE function
INDEX/MATCH functions
Advanced INDEX/MATCH functions
Advanced VLOOKUP Function
Adding a Calculated Field in a PivotTable
Adding/Modifying a PivotChart
Retrieving PivotTable Data


Chart


Modifying Data Labels
Removing / Adding Chart Data Series
Removing / Adding Chart Legend
Removing / Adding Chart Title
Resizing graphics and/or shapes
Selecting a Chart Type
Modifying Chart Legend Display
Chart : Color Style
Modifying Chart Style
Switching Row/Column in a Graph
Selecting Data Series in a Graph
Creating a Combo Chart : Mixed format
Advanced Display of Axis
Creating a Combo Chart : Secondary Axis
Creating "Waterfall" Charts
Creating "Scatter" Charts