Programming with VBA Multiple Choice Practice Questions - Set 01 - ObjectiveBooks

Programming with VBA Multiple Choice Practice Questions - Set 01

Practice Test: Question Set - 01

1. Which shortcut key is used to set the properties of form while designing?
    (A) F4
    (B) Ctrl + F4
    (C) Alt + F4
    (D) Shift + F4

2. What is the storage size of decimal data type in VBA?
    (A) 2 bytes
    (B) 4 bytes
    (C) 8 bytes
    (D) 12 bytes

3. Which entity hold data in VBA?
    (A) Literals
    (B) Constants
    (C) Keywords
    (D) Variables

4. Which object is member of the workbook?
    (A) Sheets
    (B) Workbook
    (C) Worksheet
    (D) Range

5. Which button has three states in VBA?
    (A) Option button
    (B) Spin button
    (C) Push button
    (D) Command button

6. What is the Full form of IDE?
    (A) Integrated Development Element
    (B) Internal Development Environment
    (C) Integrated Development Environment
    (D) Internal Distributed Environment

7. What is called double clicking an object in VBA?
    (A) Events
    (B) Macros
    (C) Procedures
    (D) Methods

8. Which type of variable can be accessed or used by subroutines outside the modules in VBA?
    (A) Static
    (B) Private
    (C) Protect
    (D) Public

9. Which function returns the difference between two date values based on the interval specified in VBA?
    (A) Datediff()
    (B) Day()
    (C) Daydiff()
    (D) Datedif()

10. Which function returns the integer portion of a number in VBA?
    (A) Int()
    (B) Format()
    (C) Abs()
    (D) Sign()

11. Which box has three states in VBA?
    (A) List box
    (B) Combo box
    (C) Check box
    (D) Group box

12. Which window is similar to the locals window, but it is used to tracing the variables in VBA?
    (A) Call stack window
    (B) Watch window
    (C) Immediate window
    (D) Debugging window

13. Which VBA function compares given strings and returns -1 if the first string is smaller than the second string, returns 0 if both are equal and 1 if the first string is greater than second string?
    (A) Strcmp
    (B) Strcomp
    (C) Compare
    (D) Scmp

14. Which VBA built in function returns location at the second string occurs within the first string?
    (A) Mid()
    (B) Chr()
    (C) ASC()
    (D) Instr()

15. How many levels of variable scope available in VBA?
    (A) 2
    (B) 3
    (C) 4
    (D) 7

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: