Wednesday , November 18 2026
Breaking News

Microsoft Excel VBA Certification Exam Answers 2026 (All 100 Questions)

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?

A. Conditional Formatting ✔
B. Debugging Tools
C. Dynamic Typing
D. Object-Oriented Programming

Correct answer: A. Conditional Formatting

2. What is a macro in VBA?

A. A type of variable
B. A set of instructions to automate a task ✔
C. A data structure
D. A loop

Correct answer: B. A set of instructions to automate a task

3. Which of the following is NOT a VBA data type?

A. String
B. Boolean
C. Character ✔
D. Integer

Correct answer: C. Character

4. What is the purpose of a variable in VBA?

A. To create a loop
B. To define a function
C. To format cells
D. To store data ✔

Correct answer: D. To store data

5. Which of the following is NOT a VBA loop structure?

A. Repeat Until the Loop ✔
B. Do While Loop
C. While Loop
D. For Loop

Correct answer: A. Repeat Until the Loop

6. The programming environment which permits coding, compilation, running and debugging from a single window is called

A. Compiler
B. Integrated Development Environment (IDE) ✔
C. Editor
D. Highlighter

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.

A. Procedural Approach
B. reverse approach
C. Rapid Application Development (RAD) ✔
D. postfix approach

Correct answer: C. Rapid Application Development (RAD)

8. VBA permits of data from spreadsheets.

A. neither reading nor writing
B. reading
C. writing
D. both reading and writing ✔

Correct answer: D. both reading and writing

9. VBA supports ready made user interface components like .

A. UserForm, CommandButton
B. Label, TextBox, ComboBox, ListBox
C. TabStrip, OptionButton, ToggleButton
D. all of them ✔

Correct answer: D. all of them

10. VBA supports through class module.

A. Object Oriented Programming System (OOPS) ✔
B. Procedural programming
C. Functional programming
D. property based model

Correct answer: A. Object Oriented Programming System (OOPS)

11. Which shortcut key is used to set the properties of form while designing?

A. F4 ✔
B. Ctrl + F4
C. Alt + F4
D. Shift + F4

Correct answer: A. F4

12. What is the storage size of decimal data type in VBA?

A. 2bytes
B. 12 bytes ✔
C. 8 bytes
D. 4 bytes

Correct answer: B. 12 bytes

13. Which entity hold data in VBA?

A. Constants
B. Keywords
C. Variables ✔
D. Literals

Correct answer: C. Variables

14. Which object is member of the workbook?

A. Range
B. Sheets
C. Workbook
D. Worksheet ✔

Correct answer: D. Worksheet

15. Which button has three states in VBA?

A. Option button ✔
B. Spin button
C. Push button
D. Command button

Correct answer: A. Option button

16. What is the alternate name of Bugs?

A. Errors ✔
B. Keywords
C. Variables
D. Constants

Correct answer: A. Errors

17. Which is used to create user interface forms?

A. Javascrip
B. VBA ✔
C. C
D. HTML

Correct answer: B. VBA

18. Which of the following is logical operator in VBA?

A. +
B. –
C. *
D. And ✔

Correct answer: D. And

19. What is the full form of UDF in VBA?

A. Undefined Functions
B. sed Data Functions
C. User Defined Functions ✔
D. User Data Functions

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?

A. Strcmp ✔
B. Strcomp
C. Compare
D. Scmp

Correct answer: A. Strcmp

21. VBA stands for:

A. Variable Basic Access
B. Visual Basic for Applications ✔
C. Very Basic Automation
D. Visual Builder Add-in

Correct answer: B. Visual Basic for Applications

22. VBA is used in Excel to:

A. Design websites
B. Host databases
C. Edit photos
D. Automate tasks and build custom functions ✔

Correct answer: D. Automate tasks and build custom functions

23. The Visual Basic Editor is opened with:

A. F5
B. Ctrl+F11
C. Alt+F11 ✔
D. Alt+F4

Correct answer: C. Alt+F11

24. The Developer tab must be enabled to:

A. Use formulas
B. Create charts
C. Access macro recording and VBA tools easily ✔
D. Print sheets

Correct answer: C. Access macro recording and VBA tools easily

25. A macro-enabled workbook is saved as:

A. .xlsx
B. .csv
C. .xlsm ✔
D. .xls only

Correct answer: C. .xlsm

Questions 26 to 50

26. The macro recorder:

A. Encrypts files
B. Writes perfect optimised code always
C. Deletes macros
D. Records actions and generates VBA code ✔

Correct answer: D. Records actions and generates VBA code

27. A Sub procedure:

A. Is a worksheet
B. Always returns a value
C. Is a cell
D. Performs actions and does not return a value directly ✔

Correct answer: D. Performs actions and does not return a value directly

28. A Function procedure:

A. Returns a value and can be used as a worksheet formula ✔
B. Deletes data
C. Only runs on open
D. Cannot return values

Correct answer: A. Returns a value and can be used as a worksheet formula

29. VBA code is stored in:

A. Cells only
B. Charts
C. Modules within the VBA project ✔
D. PDFs

Correct answer: C. Modules within the VBA project

30. Comments in VBA start with:

A. An apostrophe (‘) ✔
B. —
C. //
D. #

Correct answer: A. An apostrophe (‘)

31. Option Explicit forces:

A. Declaration of all variables before use ✔
B. Automatic saving
C. Faster code
D. Hidden code

Correct answer: A. Declaration of all variables before use

32. Variables are declared using:

A. Declare only
B. Dim ✔
C. Var
D. Let only

Correct answer: B. Dim

33. Dim total As Long declares:

A. A Long integer variable named total ✔
B. A string
C. A range
D. A worksheet

Correct answer: A. A Long integer variable named total

34. The Variant data type:

A. Cannot be used
B. Can hold any type of data ✔
C. Holds only numbers
D. Holds only text

Correct answer: B. Can hold any type of data

35. The String data type stores:

A. Booleans
B. Numbers only
C. Dates only
D. Text ✔

Correct answer: D. Text

36. The Boolean data type stores:

A. Ranges
B. True or False ✔
C. Dates
D. Text

Correct answer: B. True or False

37. Range("A1").Value refers to:

A. The value in cell A1 ✔
B. The address
C. The format
D. The formula only

Correct answer: A. The value in cell A1

38. Cells(2, 3) refers to:

A. Row 2, column 3 (cell C2) ✔
B. Row 3, column 2
C. Cell B3 always
D. Cell A1

Correct answer: A. Row 2, column 3 (cell C2)

39. Range("A1:A10") refers to:

A. Only A1
B. Only A10
C. A block of cells from A1 to A10 ✔
D. The whole sheet

Correct answer: C. A block of cells from A1 to A10

40. ActiveCell refers to:

A. A random cell
B. The last cell
C. The first cell
D. The currently selected cell ✔

Correct answer: D. The currently selected cell

41. ActiveSheet refers to:

A. A workbook file
B. The first sheet always
C. A chart
D. The currently active worksheet ✔

Correct answer: D. The currently active worksheet

42. Worksheets("Data") refers to:

A. The worksheet named Data ✔
B. A chart
C. A workbook
D. A range

Correct answer: A. The worksheet named Data

43. ThisWorkbook refers to:

A. The active workbook always
B. The workbook containing the running code ✔
C. A new workbook
D. A closed workbook

Correct answer: B. The workbook containing the running code

44. Workbooks.Open is used to:

A. Create charts
B. Open a workbook file ✔
C. Close Excel
D. Delete files

Correct answer: B. Open a workbook file

45. Range("A1").Formula = "=SUM(B1:B10)" will:

A. Delete A1
B. Format A1
C. Calculate in VBA only
D. Enter a SUM formula into A1 ✔

Correct answer: D. Enter a SUM formula into A1

46. Range.Offset(1, 0) refers to:

A. One row above
B. The same cell
C. One column right
D. The cell one row below ✔

Correct answer: D. The cell one row below

47. Range.Resize changes:

A. The size of a range ✔
B. The column width only
C. The font size
D. The sheet name

Correct answer: A. The size of a range

48. Finding the last used row often uses:

A. ActiveCell.Row only
B. Rows.Count only
C. Cells(Rows.Count, 1).End(xlUp).Row ✔
D. Range("A1").Row

Correct answer: C. Cells(Rows.Count, 1).End(xlUp).Row

49. A For…Next loop:

A. Runs once
B. Repeats code a set number of times ✔
C. Only checks conditions
D. Never runs

Correct answer: B. Repeats code a set number of times

50. A For Each loop is used to:

A. Count rows only
B. Close workbooks
C. Declare variables
D. Iterate through each item in a collection like cells in a range ✔

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:

A. Once only
B. While a condition is true ✔
C. Never
D. Exactly ten times

Correct answer: B. While a condition is true

52. An If…Then…Else statement:

A. Loops forever
B. Declares variables
C. Executes code based on conditions ✔
D. Opens files

Correct answer: C. Executes code based on conditions

53. Select Case is useful when:

A. Saving workbooks
B. Declaring arrays
C. Testing a single expression against many values ✔
D. Opening files

Correct answer: C. Testing a single expression against many values

54. MsgBox displays:

A. A chart
B. A formula
C. A message dialog to the user ✔
D. A new sheet

Correct answer: C. A message dialog to the user

55. InputBox is used to:

A. Display charts
B. Get input from the user ✔
C. Save files
D. Delete data

Correct answer: B. Get input from the user

56. UserForms in VBA allow:

A. Only formulas
B. Only charts
C. Only pivot tables
D. Creating custom dialog boxes with controls ✔

Correct answer: D. Creating custom dialog boxes with controls

57. Common UserForm controls include:

A. Pivot tables only
B. Cells only
C. TextBox, ComboBox, CommandButton and ListBox ✔
D. Charts only

Correct answer: C. TextBox, ComboBox, CommandButton and ListBox

58. Event procedures such as Workbook_Open run:

A. Automatically when a specific event occurs ✔
B. Only on printing
C. Never
D. Only manually

Correct answer: A. Automatically when a specific event occurs

59. Worksheet_Change runs when:

A. Cells on the worksheet are changed ✔
B. A chart is created
C. Excel starts only
D. The workbook closes

Correct answer: A. Cells on the worksheet are changed

60. On Error Resume Next:

A. Fixes errors automatically
B. Stops all code
C. Continues execution after an error ✔
D. Deletes errors

Correct answer: C. Continues execution after an error

61. On Error GoTo ErrHandler:

A. Restarts Excel
B. Jumps to an error-handling section when an error occurs ✔
C. Saves the file
D. Ignores all code

Correct answer: B. Jumps to an error-handling section when an error occurs

62. Application.ScreenUpdating = False helps to:

A. Delete sheets
B. Stop calculations forever
C. Hide the workbook permanently
D. Speed up macros by not redrawing the screen ✔

Correct answer: D. Speed up macros by not redrawing the screen

63. Application.Calculation = xlCalculationManual:

A. Encrypts data
B. Saves files
C. Prevents recalculation during macro execution ✔
D. Deletes formulas

Correct answer: C. Prevents recalculation during macro execution

64. Turning settings back on at the end of a macro is important to:

A. Crash Excel
B. Delete data
C. Slow down code
D. Restore normal Excel behaviour ✔

Correct answer: D. Restore normal Excel behaviour

65. With…End With blocks:

A. Declare functions
B. Create loops
C. Handle errors
D. Perform multiple actions on the same object concisely ✔

Correct answer: D. Perform multiple actions on the same object concisely

66. Arrays in VBA can be declared as:

A. arr[10]
B. Array arr = 10
C. List arr(10)
D. Dim arr(1 To 10) As Long ✔

Correct answer: D. Dim arr(1 To 10) As Long

67. Reading a range into an array improves:

A. Formatting
B. Errors
C. Performance by reducing worksheet interactions ✔
D. File size

Correct answer: C. Performance by reducing worksheet interactions

68. ReDim Preserve is used to:

A. Resize a dynamic array while keeping existing values ✔
B. Sort arrays
C. Delete arrays
D. Copy arrays

Correct answer: A. Resize a dynamic array while keeping existing values

69. Collections and Dictionaries in VBA help to:

A. Draw charts
B. Print sheets
C. Store and look up groups of items ✔
D. Format cells

Correct answer: C. Store and look up groups of items

70. The Scripting.Dictionary object stores:

A. Key-value pairs ✔
B. Only numbers
C. Only charts
D. Only formulas

Correct answer: A. Key-value pairs

71. Debug.Print outputs text to:

A. The Immediate window ✔
B. A file
C. A message box
D. A cell

Correct answer: A. The Immediate window

72. Breakpoints (F9) allow you to:

A. Pause code at a specific line for debugging ✔
B. Save code
C. Run faster
D. Delete lines

Correct answer: A. Pause code at a specific line for debugging

73. Stepping through code line by line uses:

A. F8 ✔
B. F5
C. F2
D. F12

Correct answer: A. F8

74. F5 in the VBA editor:

A. Runs the current macro ✔
B. Steps line by line
C. Closes the editor
D. Opens help

Correct answer: A. Runs the current macro

75. The Locals window shows:

A. Excel cells
B. The project files
C. Charts
D. Values of variables in the current procedure ✔

Correct answer: D. Values of variables in the current procedure

Questions 76 to 100

76. The Watch window lets you:

A. Print code
B. Edit charts
C. Monitor specific expressions while debugging ✔
D. Save files

Correct answer: C. Monitor specific expressions while debugging

77. Macro security settings in the Trust Center control:

A. Cell formats
B. Printer settings
C. Chart styles
D. Whether macros can run ✔

Correct answer: D. Whether macros can run

78. Macros from unknown sources should be:

A. Treated cautiously as they may contain malicious code ✔
B. Shared widely
C. Ignored safely
D. Always enabled

Correct answer: A. Treated cautiously as they may contain malicious code

79. Digitally signing a VBA project helps to:

A. Hide code
B. Verify the macro publisher ✔
C. Speed up macros
D. Change formulas

Correct answer: B. Verify the macro publisher

80. User-defined functions (UDFs) can be used:

A. In worksheet cells like built-in functions ✔
B. Never
C. Only in charts
D. Only in VBA

Correct answer: A. In worksheet cells like built-in functions

81. WorksheetFunction lets VBA use:

A. Only VBA functions
B. Only charts
C. Excel’s built-in functions like VLookup and Sum ✔
D. Only files

Correct answer: C. Excel’s built-in functions like VLookup and Sum

82. Automating PivotTables with VBA allows:

A. Changing fonts only
B. Deleting data
C. Only manual pivots
D. Creating and refreshing pivot reports programmatically ✔

Correct answer: D. Creating and refreshing pivot reports programmatically

83. VBA can automate other Office apps such as:

A. Word and Outlook through object models ✔
B. Only Excel
C. Only Paint
D. Only Notepad

Correct answer: A. Word and Outlook through object models

84. Sending emails from Excel VBA typically uses:

A. Only Access
B. The Outlook object model ✔
C. Only PowerPoint
D. Only Word

Correct answer: B. The Outlook object model

85. Looping through all files in a folder can use:

A. Only MsgBox
B. Only InputBox
C. Only Range
D. Dir function or FileSystemObject ✔

Correct answer: D. Dir function or FileSystemObject

86. Saving a workbook with code uses:

A. ThisWorkbook.Save or SaveAs ✔
B. Cells.Save
C. Range.Save
D. Sheet.Delete

Correct answer: A. ThisWorkbook.Save or SaveAs

87. Deleting a worksheet without a prompt can use:

A. Application.DisplayAlerts = False before deleting ✔
B. ScreenUpdating False only
C. Debug.Print
D. Calculation manual

Correct answer: A. Application.DisplayAlerts = False before deleting

88. Named ranges in VBA make code:

A. Error-prone
B. Easier to read and more robust ✔
C. Hidden
D. Slower

Correct answer: B. Easier to read and more robust

89. Avoiding Select and Activate in VBA leads to:

A. Slower code
B. More errors
C. Faster and more reliable code ✔
D. More screen flicker

Correct answer: C. Faster and more reliable code

90. Power Query and Office Scripts are alternatives to VBA for:

A. Database hosting
B. Video editing
C. Graphic design
D. Data transformation and automation in modern Excel ✔

Correct answer: D. Data transformation and automation in modern Excel

91. Office Scripts use:

A. Python only
B. TypeScript and run in Excel on the web ✔
C. VBA only
D. SQL only

Correct answer: B. TypeScript and run in Excel on the web

92. Documenting VBA code with comments helps:

A. Increase file size only
B. Others and your future self understand the logic ✔
C. Slow execution
D. Hide errors

Correct answer: B. Others and your future self understand the logic

93. The main benefit of Excel VBA is:

A. Designing websites
B. Automating repetitive tasks and extending Excel’s capabilities ✔
C. Making files larger
D. Replacing Excel

Correct answer: B. Automating repetitive tasks and extending Excel’s capabilities

94. Exit Sub is used to:

A. Close Excel
B. Leave a Sub procedure early ✔
C. Restart the loop
D. Delete the module

Correct answer: B. Leave a Sub procedure early

95. The Immediate window can also be used to:

A. Edit charts
B. Design forms
C. Print sheets
D. Run single lines of code and check values ✔

Correct answer: D. Run single lines of code and check values

96. Range.ClearContents removes:

A. Comments only
B. Formatting only
C. The entire sheet
D. Values and formulas but keeps formatting ✔

Correct answer: D. Values and formulas but keeps formatting

97. Range.Copy Destination:=Range("D1") copies:

A. A range to another location ✔
B. Only formats
C. Only values to clipboard forever
D. Nothing

Correct answer: A. A range to another location

98. Application.WorksheetFunction.CountIf counts:

A. All cells
B. Blank cells only
C. Cells meeting a condition ✔
D. Characters

Correct answer: C. Cells meeting a condition

99. Format(Date, "dd-mm-yyyy") returns:

A. Today’s date formatted as text ✔
B. A cell reference
C. A number
D. An error

Correct answer: A. Today’s date formatted as text

100. Personal Macro Workbook (PERSONAL.XLSB) stores:

A. Macros available in all workbooks on your computer ✔
B. Only one workbook’s data
C. Passwords
D. Charts

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

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.

About Priya Dogra

Priya Dogra runs priyadogra.com, where she shares free certification courses, internships, jobs, scholarships and exam preparation guides for Indian students and freshers. Follow her on YouTube, LinkedIn and Instagram for the latest opportunities.

Check Also

Unix/ Linux Certification exam answers 2026

Unix/ Linux Certification Exam Answers 2026 (All 100 Questions)

All 100 Unix/ Linux Certification exam questions with correct answers highlighted - updated 2026.

Leave a Reply

Your email address will not be published. Required fields are marked *