Priya Dogra – Certification | Jobs | Internships
Related Articles
Microsoft Excel VBA Free Certificate | Itronix Solutions
About the Quiz:
Check your skill by answering these Microsoft Excel VBA Quiz questions. This quiz will help you to check your knowledge and improve it further. List of the most asked real-world basic to advance level Microsoft Excel VBA Quiz interview questions and answers for freshers and experienced.
Practice Below the best Microsoft Excel VBA Quiz MCQ Questions that checks your basic knowledge of Excel VBA. This Test contains 15 Multiple Choice Questions. So, you have to select the right answer to check your final preparation for your exams & interviews.
Certificate: Test your knowledge with Itronix Solutions basic Microsoft Excel VBA Quiz made especially for beginners. Pass the test and get a Certificate of achievement!
Terms and Conditions:
- Every MCQ set focuses on a specific topic in Microsoft Excel VBA.
- 15 Multiple Choice Questions & Answers in Microsoft Excel VBA with answers.
- This quiz consists of 15 multiple-choice questions.
- Each question in the quiz is of multiple-choice or “true or false” format.
- You may review your answer choices and compare them to the correct answers after your final attempt.
Here are the Questions and Answers:
List of the most asked real-world basic to advanced level Microsoft Excel VBA Quiz MCQ questions and answers for freshers and experienced.
Question 1: What does VBA stand for?
Answer: Visual Basic Application
Question 2: Which of the following is NOT a feature of VBA?
Answer: Conditional Formatting
Question 3: What is a macro in VBA?
Answer: A set of instructions to automate a task
Question 4: Which of the following is the correct syntax for a comment in VBA?
Answer: ‘
Question 5: VBA code can work only with Excel
Answer: False
Question 6: If you record a macro, where will it be stored?
Answer: In Module
Question 7: What is the correct object order?
Answer: Application.Workbook.Worksheet.Range
Question 8: Which word is used to declare a variable?
Answer: Dim
Question 9: Which variable is used to store text?
Answer: String
Question 10: Option Explicit will obligate us to
Answer: Declare variables
Question 11: Which of the following is NOT a VBA data type?
Answer: Character
Question 12: What is the purpose of a variable in VBA?
Answer: To store data
Question 13: What is a function in VBA?
Answer: A predefined set of code that performs a specific task
Question 14: Which of the following is NOT a VBA operator?
Answer: %
Question 15: Which of the following is the correct syntax for an If-Then-Else statement in VBA?
Answer: If condition Then statement ElseIf condition Then statement Else statement
