Home > COPA (Computer Operator and Programming Assistant) > Quizzes > COPA Practice Test: Programming with VBA
COPA Practice Test: Programming with VBA
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 85% Most missed: “Which variable recognized only within the procedure in which it is declared?”

Visual Basic for Applications is an implementation of Microsoft's event-driven programming language Visual Basic 6.0 built into most desktop Microsoft Office applications.

COPA Practice Test: Programming with VBA
Time left 00:00
25 Questions

1. Which workbook property returns the name of the object including its path on disk in VBA?
2. Which shortcut key is used to set the properties of form while designing?
3. How many levels of variable scope available in VBA?
4. Which function returns the difference between two date values based on the interval specified in VBA?
5. Which function returns the integer portion of a number in VBA?
6. What is called the set of statement that are executed under one name?
7. Which code is used to display a user form in VBA?
8. Which mathematical function generates a random number in VBA?
9. Which button has three states in VBA?
10. Which window displays the watched expression including the one just added?
11. What is the shortcut key to run the current procedure in VBA?
12. Which entity hold data in VBA?
13. Which function returns the hyperbolic cosine of the specified angle in VBA?
14. Which function returns specified part of a given date in VBA?
15. Which data type can hold any type of values in VBA?
16. Which function is used to check whether the given input is numeric or Not in VBA?
17. 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?
18. Which shortcut key is used to open the immediate window?
19. Which type of variable can be accessed or used by subroutines outside the modules in VBA?
20. Which type of variable cannot be declared within a procedure in VBA?
21. Which window displays the entire list of local variables and their current values in VBA?
22. Which key word is used to declare the variable in VBA?
23. Which type of work book method cannot be modified in VBA?
24. What is the another name trigger for an action in VBA?
25. What is the alternate name of Bugs?