CP212 PRACTICE EXAM QUESTIONS AND ANSWERS
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 - CORRECT ANSWER✅✅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() - CORRECT ANSWER✅✅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 - CORRECT ANSWER✅✅Subroutine-level scope
On assigning a value to a new variable inside a function, it automatically becomes a global variable
,a. True
b. False - CORRECT ANSWER✅✅False
A subroutine cannot call a function
a. True
b. False - CORRECT ANSWER✅✅False
What is the name of the VBA object that represents an Excel file
a. Workbook
b. Spreadsheet
c. Application
d. Worksheet - CORRECT ANSWER✅✅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 - CORRECT ANSWER✅✅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 - CORRECT ANSWER✅✅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 - CORRECT ANSWER✅✅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 - CORRECT ANSWER✅✅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 - CORRECT ANSWER✅✅On Error GoTo 0
In the following code, what is the word "DataEntryError" called in VBA?
Sub SomeErrors()
On Error GoTo DataEntryError
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 - CORRECT ANSWER✅✅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() - CORRECT ANSWER✅✅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 - CORRECT ANSWER✅✅Subroutine-level scope
On assigning a value to a new variable inside a function, it automatically becomes a global variable
,a. True
b. False - CORRECT ANSWER✅✅False
A subroutine cannot call a function
a. True
b. False - CORRECT ANSWER✅✅False
What is the name of the VBA object that represents an Excel file
a. Workbook
b. Spreadsheet
c. Application
d. Worksheet - CORRECT ANSWER✅✅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 - CORRECT ANSWER✅✅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 - CORRECT ANSWER✅✅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 - CORRECT ANSWER✅✅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 - CORRECT ANSWER✅✅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 - CORRECT ANSWER✅✅On Error GoTo 0
In the following code, what is the word "DataEntryError" called in VBA?
Sub SomeErrors()
On Error GoTo DataEntryError
