Practice Test: Question Set - 03
1. Which color of dot indicates the breakpoint in VBA?
- (A) Grey
- (B) Yellow
- (C) Maroon
- (D) Red
2. Which of the following is logical operator in VBA?
- (A) "+"
- (B) "-"
- (C) "*"
- (D) "AND"
3. Which key word is used to declare the variable in VBA?
- (A) Sub
- (B) Declare
- (C) Dim
- (D) AS
4. Which VBA property returns a range object that represents all the cells on the worksheet?
- (A) Cells
- (B) Rows
- (C) Index
- (D) Name
5. Which type of list box enables one choice of adjacent choice in VBA?
- (A) Drop down
list
- (B) Single -
selection list box
- (C) Multiple -
selection list box
- (D) Extended -
selection list box
6. What is called the set of statement that are executed under one name?
- (A) Macros
- (B) Properties
- (C) Procedures
- (D) Events
7. Which method is used to pass the reference to the arguments?
- (A) Ref
- (B) Val
- (C) Reference
- (D) By Ref
8. Which VBA code is used to remove the user form from memory?
- (A) Unload me
- (B) Userform1.hide
- (C) Unload
userform1
- (D) User form
show false
9. Which mathematical function generates a random number in VBA?
- (A) Random()
- (B) Rnd()
- (C) Rand()
- (D) Round()
10. Which one creates a box with a scrollable list containing a number of input values in VBA?
- (A) Combo box
- (B) Option
button
- (C) Text box
- (D) List box
11. Which shortcut key is used to open the immediate window?
- (A) Ctrl + G
- (B) Ctrl + L
- (C) Alt + G
- (D) Alt + L
12. Which scope does the variable declared with dim and remains in the existence only as long as the procedure in which if is declared is running?
- (A) Global scope
- (B) Local scope
- (C) Module scope
- (D) Project
scope
13. In VBA, How many types of access specifiers available in VBA?
- (A) 2
- (B) 3
- (C) 4
- (D) 6
14. What is the full form of UDF in VBA?
- (A) User Data
Functions
- (B) User Defined
Functions
- (C) Undefined
Functions
- (D) Used Data
Functions
Next Tests: