Microsoft Excel VBA Certification exam answers 2026: This page lists all 100 questions of the official Microsoft Excel VBA Certification exam by Itronix Solutions, each with its four answer options and the correct answer highlighted in green. Use it to revise every topic before you attempt the test and earn your verifiable certificate.
About this certification: This reference contains conceptual overviews, programming tasks, samples, and references to help you develop Excel solutions. Note.
| Certification | Microsoft Excel VBA Certification |
| Provider | Itronix Solutions |
| Category | Office & Computer Basics |
| Total questions | 100 multiple-choice questions |
| Marks | 1 mark per question (100 marks) |
| Passing score | 80% (80 out of 100) |
| Retake | Available if you do not pass |
| Certificate | Verifiable online certificate |
Take the exam: Microsoft Excel VBA Certification on Itronix Solutions. See every other Itronix exam in our complete list of Itronix certification answers.
Microsoft Excel VBA Exam Questions and Answers
Questions 1 to 25
1. Which of the following is NOT a feature of VBA?
Correct answer: A. Conditional Formatting
2. What is a macro in VBA?
Correct answer: B. A set of instructions to automate a task
3. Which of the following is NOT a VBA data type?
Correct answer: C. Character
4. What is the purpose of a variable in VBA?
Correct answer: D. To store data
5. Which of the following is NOT a VBA loop structure?
Correct answer: A. Repeat Until the Loop
6. The programming environment which permits coding, compilation, running and debugging from a single window is called
Correct answer: B. Integrated Development Environment (IDE)
7. The IDE of VBA supports since it permits drag and drop approach for design of user interface.
Correct answer: C. Rapid Application Development (RAD)
8. VBA permits of data from spreadsheets.
Correct answer: D. both reading and writing
9. VBA supports ready made user interface components like .
Correct answer: D. all of them
10. VBA supports through class module.
Correct answer: A. Object Oriented Programming System (OOPS)
11. Which shortcut key is used to set the properties of form while designing?
Correct answer: A. F4
12. What is the storage size of decimal data type in VBA?
Correct answer: B. 12 bytes
13. Which entity hold data in VBA?
Correct answer: C. Variables
14. Which object is member of the workbook?
Correct answer: D. Worksheet
15. Which button has three states in VBA?
Correct answer: A. Option button
16. What is the alternate name of Bugs?
Correct answer: A. Errors
17. Which is used to create user interface forms?
Correct answer: B. VBA
18. Which of the following is logical operator in VBA?
Correct answer: D. And
19. What is the full form of UDF in VBA?
Correct answer: C. User Defined Functions
20. Which VBA function compares given strings and returns -1 if the first string is smaller than the second string, returns 0 if both are equal and 1 if the first string is greater than second string?
Correct answer: A. Strcmp
21. VBA stands for:
Correct answer: B. Visual Basic for Applications
22. VBA is used in Excel to:
Correct answer: D. Automate tasks and build custom functions
23. The Visual Basic Editor is opened with:
Correct answer: C. Alt+F11
24. The Developer tab must be enabled to:
Correct answer: C. Access macro recording and VBA tools easily
25. A macro-enabled workbook is saved as:
Correct answer: C. .xlsm
Questions 26 to 50
26. The macro recorder:
Correct answer: D. Records actions and generates VBA code
27. A Sub procedure:
Correct answer: D. Performs actions and does not return a value directly
28. A Function procedure:
Correct answer: A. Returns a value and can be used as a worksheet formula
29. VBA code is stored in:
Correct answer: C. Modules within the VBA project
30. Comments in VBA start with:
Correct answer: A. An apostrophe (‘)
31. Option Explicit forces:
Correct answer: A. Declaration of all variables before use
32. Variables are declared using:
Correct answer: B. Dim
33. Dim total As Long declares:
Correct answer: A. A Long integer variable named total
34. The Variant data type:
Correct answer: B. Can hold any type of data
35. The String data type stores:
Correct answer: D. Text
36. The Boolean data type stores:
Correct answer: B. True or False
37. Range("A1").Value refers to:
Correct answer: A. The value in cell A1
38. Cells(2, 3) refers to:
Correct answer: A. Row 2, column 3 (cell C2)
39. Range("A1:A10") refers to:
Correct answer: C. A block of cells from A1 to A10
40. ActiveCell refers to:
Correct answer: D. The currently selected cell
41. ActiveSheet refers to:
Correct answer: D. The currently active worksheet
42. Worksheets("Data") refers to:
Correct answer: A. The worksheet named Data
43. ThisWorkbook refers to:
Correct answer: B. The workbook containing the running code
44. Workbooks.Open is used to:
Correct answer: B. Open a workbook file
45. Range("A1").Formula = "=SUM(B1:B10)" will:
Correct answer: D. Enter a SUM formula into A1
46. Range.Offset(1, 0) refers to:
Correct answer: D. The cell one row below
47. Range.Resize changes:
Correct answer: A. The size of a range
48. Finding the last used row often uses:
Correct answer: C. Cells(Rows.Count, 1).End(xlUp).Row
49. A For…Next loop:
Correct answer: B. Repeats code a set number of times
50. A For Each loop is used to:
Correct answer: D. Iterate through each item in a collection like cells in a range
Questions 51 to 75
51. A Do While loop runs:
Correct answer: B. While a condition is true
52. An If…Then…Else statement:
Correct answer: C. Executes code based on conditions
53. Select Case is useful when:
Correct answer: C. Testing a single expression against many values
54. MsgBox displays:
Correct answer: C. A message dialog to the user
55. InputBox is used to:
Correct answer: B. Get input from the user
56. UserForms in VBA allow:
Correct answer: D. Creating custom dialog boxes with controls
57. Common UserForm controls include:
Correct answer: C. TextBox, ComboBox, CommandButton and ListBox
58. Event procedures such as Workbook_Open run:
Correct answer: A. Automatically when a specific event occurs
59. Worksheet_Change runs when:
Correct answer: A. Cells on the worksheet are changed
60. On Error Resume Next:
Correct answer: C. Continues execution after an error
61. On Error GoTo ErrHandler:
Correct answer: B. Jumps to an error-handling section when an error occurs
62. Application.ScreenUpdating = False helps to:
Correct answer: D. Speed up macros by not redrawing the screen
63. Application.Calculation = xlCalculationManual:
Correct answer: C. Prevents recalculation during macro execution
64. Turning settings back on at the end of a macro is important to:
Correct answer: D. Restore normal Excel behaviour
65. With…End With blocks:
Correct answer: D. Perform multiple actions on the same object concisely
66. Arrays in VBA can be declared as:
Correct answer: D. Dim arr(1 To 10) As Long
67. Reading a range into an array improves:
Correct answer: C. Performance by reducing worksheet interactions
68. ReDim Preserve is used to:
Correct answer: A. Resize a dynamic array while keeping existing values
69. Collections and Dictionaries in VBA help to:
Correct answer: C. Store and look up groups of items
70. The Scripting.Dictionary object stores:
Correct answer: A. Key-value pairs
71. Debug.Print outputs text to:
Correct answer: A. The Immediate window
72. Breakpoints (F9) allow you to:
Correct answer: A. Pause code at a specific line for debugging
73. Stepping through code line by line uses:
Correct answer: A. F8
74. F5 in the VBA editor:
Correct answer: A. Runs the current macro
75. The Locals window shows:
Correct answer: D. Values of variables in the current procedure
Questions 76 to 100
76. The Watch window lets you:
Correct answer: C. Monitor specific expressions while debugging
77. Macro security settings in the Trust Center control:
Correct answer: D. Whether macros can run
78. Macros from unknown sources should be:
Correct answer: A. Treated cautiously as they may contain malicious code
79. Digitally signing a VBA project helps to:
Correct answer: B. Verify the macro publisher
80. User-defined functions (UDFs) can be used:
Correct answer: A. In worksheet cells like built-in functions
81. WorksheetFunction lets VBA use:
Correct answer: C. Excel’s built-in functions like VLookup and Sum
82. Automating PivotTables with VBA allows:
Correct answer: D. Creating and refreshing pivot reports programmatically
83. VBA can automate other Office apps such as:
Correct answer: A. Word and Outlook through object models
84. Sending emails from Excel VBA typically uses:
Correct answer: B. The Outlook object model
85. Looping through all files in a folder can use:
Correct answer: D. Dir function or FileSystemObject
86. Saving a workbook with code uses:
Correct answer: A. ThisWorkbook.Save or SaveAs
87. Deleting a worksheet without a prompt can use:
Correct answer: A. Application.DisplayAlerts = False before deleting
88. Named ranges in VBA make code:
Correct answer: B. Easier to read and more robust
89. Avoiding Select and Activate in VBA leads to:
Correct answer: C. Faster and more reliable code
90. Power Query and Office Scripts are alternatives to VBA for:
Correct answer: D. Data transformation and automation in modern Excel
91. Office Scripts use:
Correct answer: B. TypeScript and run in Excel on the web
92. Documenting VBA code with comments helps:
Correct answer: B. Others and your future self understand the logic
93. The main benefit of Excel VBA is:
Correct answer: B. Automating repetitive tasks and extending Excel’s capabilities
94. Exit Sub is used to:
Correct answer: B. Leave a Sub procedure early
95. The Immediate window can also be used to:
Correct answer: D. Run single lines of code and check values
96. Range.ClearContents removes:
Correct answer: D. Values and formulas but keeps formatting
97. Range.Copy Destination:=Range("D1") copies:
Correct answer: A. A range to another location
98. Application.WorksheetFunction.CountIf counts:
Correct answer: C. Cells meeting a condition
99. Format(Date, "dd-mm-yyyy") returns:
Correct answer: A. Today’s date formatted as text
100. Personal Macro Workbook (PERSONAL.XLSB) stores:
Correct answer: A. Macros available in all workbooks on your computer
How to Pass the Microsoft Excel VBA Exam
- Read every question carefully; most options look similar, so look for the most precise answer.
- Revise the questions above topic by topic rather than memorising letters, because option order can change in the live test.
- You need 80 correct answers out of 100 to pass, so aim to understand at least 85 to stay safe.
- If you do not clear it on the first attempt, review the questions you missed and use the retake option.
Frequently Asked Questions
How many questions are in the Microsoft Excel VBA Certification exam?
The exam has 100 multiple-choice questions, each worth 1 mark.
What is the passing score for the Microsoft Excel VBA Certification?
You need at least 80% (80 out of 100) to pass and receive the certificate.
Can I retake the Microsoft Excel VBA Certification exam?
Yes. If you score below 80%, you can retry the test after reviewing the topics.
Is the Itronix certificate verifiable?
Yes. Every certificate issued by Itronix Solutions has a unique ID that can be checked on the Itronix verify-certificate page.
More Office & Computer Basics Certification Answers
- Basics of Computer Certification Exam Answers
- Communication Skills Professional Certification Exam Answers
- Data entry Operator Certification Exam Answers
- Google Workspace Professional Certification Exam Answers
- Health and Nutrition Certification Exam Answers
- Interview Preparation Professional Certification Exam Answers
- Microsoft Advance Excel Certification Exam Answers
- Microsoft Office Specialist (MOS) Certification Exam Answers
Disclaimer: These answers are provided for learning and revision. Questions and answers are checked regularly; if you find a mistake, let us know in the comments.
Priya Dogra – Free Certifications, Exam Answers & Career Guides Free certification exam answers, courses, scholarships and career guides for learners worldwide