CP212 – Practice Midterm
Spring 2016
Part 1: Choose the best answer
1) A ________ is a container that is used to organize programming code in VBA.
A) project
B) module
C) procedure
D) window
2) ________ in VBA consists of one or more procedures.
A) A module
B) Design time
m
C) A project
er as
D) Run time
co
eH w
3) An Excel workbook that supports macros has the ________ file extension.
o.
A) .xlsc
B) .xlsx
rs e
ou urc
C) .xlsm
D) .xls
o
4) If you use Option Explicit at the top of the code window, you don’t have to explicitly
declare your variable data types.
aC s
vi y re
A) True
B) False
5) VBA is a(n) ________ programming language.
ed d
A) standard
ar stu
B) macro-enabled
C) syntax-driven
D) object-oriented
sh is
6) A ________ procedure in VBA performs an action but does not return a specific value.
Th
A) property
B) function
C) private
D) sub
7) The ________ of a variable determine(s) which program statements can access the value
in the variable.
A) scope
B) declaration
C) concatenation
D) functions
https://www.coursehero.com/file/29756653/Practice-MidtermCP212S17pdf/
Spring 2016
Part 1: Choose the best answer
1) A ________ is a container that is used to organize programming code in VBA.
A) project
B) module
C) procedure
D) window
2) ________ in VBA consists of one or more procedures.
A) A module
B) Design time
m
C) A project
er as
D) Run time
co
eH w
3) An Excel workbook that supports macros has the ________ file extension.
o.
A) .xlsc
B) .xlsx
rs e
ou urc
C) .xlsm
D) .xls
o
4) If you use Option Explicit at the top of the code window, you don’t have to explicitly
declare your variable data types.
aC s
vi y re
A) True
B) False
5) VBA is a(n) ________ programming language.
ed d
A) standard
ar stu
B) macro-enabled
C) syntax-driven
D) object-oriented
sh is
6) A ________ procedure in VBA performs an action but does not return a specific value.
Th
A) property
B) function
C) private
D) sub
7) The ________ of a variable determine(s) which program statements can access the value
in the variable.
A) scope
B) declaration
C) concatenation
D) functions
https://www.coursehero.com/file/29756653/Practice-MidtermCP212S17pdf/
