VISUAL BASIC for APPLICATIONS TEST

Progress

1.

A ____________ is a predefined VB procedure that you can call upon when needed.

2.

A ______________ returns a value to the part of the program that called it.

3.

Do…Loop... Until code block is always executed once.

4.

Which of the following statement is not a looping statement in VBA?

5.

Which part of VBA window, refers to area where code is written.

6.

Study the screenshot below. What is the appropriate action to take when a workbook displays this message (Security Warning Macros have been disabled)?

7.

This control is used for titles/captions

8.

To force all variables is a VBA project to be declared, which must be stated in a module?

9.

A loop that does not have the way of stopping is called a ___________

10.

32-bit Software/Applications can be installed on:

11.

___________ control is used to provide an identifiable grouping for other controls

12.

Private Procedure can be called from anywhere in the project

13.

The value returned by InputBox is a string

14.

You have declared 4 variables

 Which of these variable declarations is not a valid VBA statement?

15.

Suppose the variable myName is declared in a Dim statement in two different Sub procedures. Which statement is true?

16.

What will the value of ThisVar be after the following lines of code execute? 

Dim ThisVar As String 
Dim MyName = "John" 
ThisVar = MyName & "John"


 

17.

What property of controls tells the order they receive the focus when the tab key is pressed during run time? it.

18.

There can be different data types of an element in an array

19.

Why Macro is used

20.

What data type can hold any type of data?

21.

The _______________ statement first executes the statements and then tests the condition after each execution

22.

To close a form named Form1, you can use:

23.

To save a VBA project with an Excel workbook, the workbook must be saved as what type of file?

24.

Which property determines whether a control is displayed to the user?

25.

What will be the output of the following statement?

txtBox.Text = FormatCurrency(1234.567)

26.

What value is stored in a variable of type single if we try to assign the variable to the value 634?

27.

The Properties window plays an important role in the development of Visual Basic Applications. It is mainly used

28.

__________ are the attributes of an object that control the object's appearance and behavior.

29.

___________ statement enables us to trap runtime error.

30.

Which windows displays a list of all forms and modules making up your application.

Assessment complete! Thank you for you time.
We are redirecting you to the result page, Please click on 'SUBMIT'