VBA Quiz - VBA Objective Questions and Answers - Set 03 - ObjectiveBooks

VBA Quiz - VBA Objective Questions and Answers - Set 03

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

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: