VBA MCQs (Chapterwise Multiple Choice Questions)

How does a class module indicate that it uses a particular interface?

The interface itself is part of the class module.

By means of the Interface keyword and the name of the interface

By means of the Implements keyword and the name of the interface

The name of the interface is passed as a parameter.

Answer & Explanation

Correct Answer: The name of the interface is passed as a parameter.

Note: This Question is unanswered, help us to find answer for this one

Which cell is selected if you run this code Range("E3:312").Range("B3").Select

F5

F3

B3

E3

Answer & Explanation

Correct Answer: F3

Note: This Question is unanswered, help us to find answer for this one

With out creating a reference to the Microsoft Scripting Runtime for the DLL to create a Dictionary object, choose the VBA code to allow you to do so.

CreateObject("Scripting.Dictionary")

CreateObject("Application.Dictionary")

CreateObject "Dictionary.Scripting"

CreateObject("Dictionary.Scripting")

Answer & Explanation

Correct Answer: CreateObject("Scripting.Dictionary")

Note: This Question is unanswered, help us to find answer for this one

Is it possible to create an array with the lowerbound being two?

Sometimes

No

Yes

Answer & Explanation

Correct Answer: Yes

Note: This Question is unanswered, help us to find answer for this one

What does a VBA macro consist of?

User instructions and Excel functions

Computer code that performs some actions on or with objects

Macro instructions that direct the user application and provide help to the user

Excel functions

Answer & Explanation

Correct Answer: Computer code that performs some actions on or with objects

Note: This Question is unanswered, help us to find answer for this one

A declaration has scope, which has three levels. What are they?

Module, Project and Automation

Procedure, Private Module and Public Module

Subroutine, Module and Project

Procedure, Project and Global

Answer & Explanation

Correct Answer: Procedure, Private Module and Public Module

Note: This Question is unanswered, help us to find answer for this one

Which of these statements will start a loop of exactly 20 iterations?

For i = 1 to 21

For i = 2 to 40

For i = 2 to 22

For i = 2 to 40 Step 2

Answer & Explanation

Correct Answer: For i = 2 to 40 Step 2

Note: This Question is unanswered, help us to find answer for this one

Which is the correct way to use formulas on Excel in VBA code

Using range("A1").value

Using Worksheetfunction object

Using Range("A1").function

Answer & Explanation

Correct Answer: Using Worksheetfunction object

Note: This Question is unanswered, help us to find answer for this one

A VBA unit is called a _____.

Routine

Event Procedure

Program

Executor

Subroutine

Answer & Explanation

Correct Answer: Event Procedure

Note: This Question is unanswered, help us to find answer for this one

If VBA code declares FileCount as a constant rather than a variable, the code tends to run faster. Why is this?

The scope of constants is limited to the procedure that declares them

Constants are declared at compile time, but variables are declared at run time

Once declared in a project, the value of a constant cannot be changed. There is no need to look up the current value of FileCount when it is a constant.

The Const declaraton specifies the most efficient type given the constant's value

Answer & Explanation

Correct Answer: The Const declaraton specifies the most efficient type given the constant's value

Note: This Question is unanswered, help us to find answer for this one

VBA Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.