Multiple Choice Questions (MCQs) on Programming in Excel with VBA

1.  What is VBA?

A)           A Microsoft programming language used to extend Excel functions

B)           A GUI Excel interface for the novice developer

C)           A open-source programming environment that works with Excel

D)           A Microsoft programming environment that replaces Excel



2.  A VBA unit is called a _____.

A)           Subroutine

B)           Routine

C)           Macro

D)           Program



3.  What does VBA stand for?

A)           Visual Basic for Applications

B)           Virtual Basic for Advanced programming

C)           Very Basic Applications

D)           Visual Basic Applied



4.  What is a macro used for?

A)           To access programs in Excel

B)           To create buttons and forms in Excel

C)           To automatically complete a series of Excel steps

D)           To link Excel files together



5.  What does a VBA macro consist of?

A)           Excel functions

B)           Computer code that performs some actions on or with objects

C)           User instructions and Excel functions

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



6.  Which of the following VBA windows shows the code of the active object?

A)           Explorer Window

B)           Properties window

C)           Immediate window

D)           Code window



7.  What stores Excel data?

A)           Compartment

B)           Variable

C)           Macro

D)           Field



8.  Which of the following would NOT be a good use for a macro?

A)           Inserting a logo on all spreadsheets

B)           Creating a custom button

C)           Performing the same calculation on multiple workbooks

D)           Computing statistical calculations on data



9.  A piece of a macro that completes some sub task is called a _____ procedure.

A)           function

B)           sub

C)           visual

D)           sub macro



10.  Which of the following would you begin a comment line with?

A)           Single quote

B)           Double quote

C)           Underscore

D)           Equal sign