VBA Excel
test

Available languages: English, French
Version(s): 1.0, 19

Tosa assessments and certification exams

Assessments are not required to be proctored when taken remotely, while certification exams must be taken in-person or via our remote proctoring solution.

Assessment test Certification exam
Number of questions 20 25
Duration 40min 60min
Exam protocol Taken online Taken online under proctored conditions, in-person or via our remote proctoring system
Results Skill level on a 1 to 5 scale. Detailed skills reports Score on a 1 to 1000 scale. Diploma delivered within 5 business days

Skills domains

Objects

This domain covers the candidates’ knowledge of using Excel-related objects and all types of collections that contain objects (workbooks, worksheets, rows/columns, cells, charts). It also covers the declaration of variables, the manipulation of charts, and the management of object building blocks (fields, properties, methods, events).

Procedures

This domain evaluates the candidates’ ability to code within procedures, handle procedures (conditions, loops, errors, events, etc.), and call procedures.

Dialog boxes, forms and ActiveX controls

The candidates are tested on their knowledge of ActiveX controls, simple dialog boxes (MsgBox, InputBox), and Userforms (building with the different controls, display, events, usage).

Environment and debugging tools

This domain covers the creation of custom functions, the different editor windows (properties, spy, etc.), and the use of instructions (points of interest, stop instructions, step-by-step debugging, error handling). It also covers the creation of add-ins and code protection.