CP212 - PRACTICE MIDTERM

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/