CP212 Practice Exam Questions and Answers Already Passed
Which programming concept can be described as "The parts of a program have access to which other
parts?"
a.Logic
b. Scope
c. Variable
d. Appearance - Answers Scope
What VBA function can be used to check to see if a value is a valid date?
a. isValidDate()
b. isDate()
c. isFloat()
d. isNumeric() - Answers IsDate()
In the code below, what is the scope of the salary variable?
Sub Test1()
Dim salary as Currency
salary = 5000
End Sub
a. Subroutine-level scope
b. Form-level scope
c. Project-level scope
d. Module-level scope - Answers Subroutine-level scope
,On assigning a value to a new variable inside a function, it automatically becomes a global variable
a. True
b. False - Answers False
A subroutine cannot call a function
a. True
b. False - Answers False
What is the name of the VBA object that represents an Excel file
a. Workbook
b. Spreadsheet
c. Application
d. Worksheet - Answers Workbook
Which VBA command will allow the user to access values from a Userform called myUserform before
the Userform is displayed to the user?
a. Load myUserform
b. Display myUserform
c. Show myUserform
d. Hide myUserform - Answers Load myUserform
Which VBA statement is typically used to display a Userform called myUserform on the screen for the
first time?
a. Show myUserform
b. Hide myUserform
, c. Display myUserform
d. Load myUserform - Answers Show myUserform
A Userform that allows you to keep working in Excel while its open is called _____________
a. Modeless
b. Moded
c. Modular
d. Modal - Answers Modal
What is the line of code used to have your program continue when an unusual error happens?
a. On Error GoTo 0
b. On Error Resume Next
c. On Error Return
d. On Error Resume Last - Answers On Error Resume Next
What line of code is used to turn off error handling?
a. On Error GoTo 0
b. On Error Resume Next
c. On Error Return
d. On Error Resume Last - Answers On Error GoTo 0
In the following code, what is the word "DataEntryError" called in VBA?
Sub SomeErrors()
On Error GoTo DataEntryError
strUsername = InputBox("What is your name?", "User input", "")
Which programming concept can be described as "The parts of a program have access to which other
parts?"
a.Logic
b. Scope
c. Variable
d. Appearance - Answers Scope
What VBA function can be used to check to see if a value is a valid date?
a. isValidDate()
b. isDate()
c. isFloat()
d. isNumeric() - Answers IsDate()
In the code below, what is the scope of the salary variable?
Sub Test1()
Dim salary as Currency
salary = 5000
End Sub
a. Subroutine-level scope
b. Form-level scope
c. Project-level scope
d. Module-level scope - Answers Subroutine-level scope
,On assigning a value to a new variable inside a function, it automatically becomes a global variable
a. True
b. False - Answers False
A subroutine cannot call a function
a. True
b. False - Answers False
What is the name of the VBA object that represents an Excel file
a. Workbook
b. Spreadsheet
c. Application
d. Worksheet - Answers Workbook
Which VBA command will allow the user to access values from a Userform called myUserform before
the Userform is displayed to the user?
a. Load myUserform
b. Display myUserform
c. Show myUserform
d. Hide myUserform - Answers Load myUserform
Which VBA statement is typically used to display a Userform called myUserform on the screen for the
first time?
a. Show myUserform
b. Hide myUserform
, c. Display myUserform
d. Load myUserform - Answers Show myUserform
A Userform that allows you to keep working in Excel while its open is called _____________
a. Modeless
b. Moded
c. Modular
d. Modal - Answers Modal
What is the line of code used to have your program continue when an unusual error happens?
a. On Error GoTo 0
b. On Error Resume Next
c. On Error Return
d. On Error Resume Last - Answers On Error Resume Next
What line of code is used to turn off error handling?
a. On Error GoTo 0
b. On Error Resume Next
c. On Error Return
d. On Error Resume Last - Answers On Error GoTo 0
In the following code, what is the word "DataEntryError" called in VBA?
Sub SomeErrors()
On Error GoTo DataEntryError
strUsername = InputBox("What is your name?", "User input", "")
