Looking for a pre-employment test on VBA Excel? Please visit Isograd Testing Services website.
Tosa assessments and certification exams on VBA Excel
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 | NA | NA | |
Duration | 0min | 0min | |
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.