VISUAL BASIC for APPLICATIONS TEST

Progress

1.

To close a form named Form1, you can use:

2.

Which Case clause will be true whenever the value of the selector in a Select Case block is between 1 and 5 or is 8?

3.

What is the color of comments?

4.

___________ statement enables us to trap runtime error.

5.

_______________ is the function to compare 2 strings.

6.

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

7.

When the form is first referenced in any manner by program,the triggered event is….

8.

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

9.

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

10.

Basic Excel Object model as follows:

11.

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

12.

What will be the output of the following statement?

txtBox.Text = FormatCurrency(1234.567)

13.

Which property for a textbox allows the textbox to accept more than 1 line of data entry?

14.

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

15.

Why Macro is used

16.

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

17.

This operator reverses the truth value of an expression; making a true expression false and a false expression true.

18.

Private Procedure can be called from anywhere in the project

19.

___________ indicates whether a particular condition is on or off

20.

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

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


 

21.

Which of the following arithmetic operations has the highest level of precedence?

22.

What will be the output of the following code?

Sub LoopExample()

Dim StartNumber As Integer

Dim EndNumber As Integer

Dim Answer As Integer

Answer = 5

EndNumber = 5

For StartNumber = 1 To EndNumber

Answer = Answer + EndNumber

Next StartNumber

MsgBox Answer

      End Sub

23.

VBA Code run by

24.

Given that x = 7, y = 2, and z = 4, the following If block will display “TRUE”. If (x > y) Or (y > z) Then txtBox.Text = “TRUE” End If

25.

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

26.

The value returned by InputBox is a string

27.

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

28.

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

29.

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

30.

An object is composed of :

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