Excel 2007, Excel 2010 and Excel 2013 skills assessments

    The online test is available for Excel 2007, 2010 and 2013 in French and English. 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.

    Microsoft Word 2010 assessment test sample question
    Demonstration Assessment test Certification exam
    • 10 questions
    • Average completion time: 8 minutes
    • Taken online
    • Level on a 1-to-3 scale
    • 25 questions
    • Average completion time: 30 minutes
    • Taken online
    • Immediate skills report
    • 35 questions
    • Time allotment: 60 minutes
    • Taken online via our remote proctoring system (coming soon)
    • Diploma sent within 5 business days

    Please enter a valid e-mail.