VISUAL BASIC for APPLICATIONS TEST

Progress

1.

To load graphics on a control at runtime, we have to use the function….

2.

When the block of code finishes the execution, what will the final value of X be?

Public Sub Example ()

Dim Y As Integer

Dim X As Integer

X = 0

Y = 10

For Count = Y To 1 Step -2

X = X + Y

If Y = (Y = 1) Then

Exit For

End If

Next Count

X = X / X

MsgBox X

End Sub

3.

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

4.

Which event, runs macros automatically in excel VBA while opening Workbook

5.

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

6.

Suppose you are designing an application for admissions to a college or university, and you need to decide how to provide the user with a selection of racial backgrounds. Which control would be most appropriate?

7.

An object is composed of :

8.

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

9.

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

10.

The _______________ control used to insert image to the form

11.

A Combo box is loaded in the From_Initialize event with:

Combo1.AddItem “Red”

Combo1.AddItem “Blue”

Combo1.AddItem “Green”

12.

Which is the conversion for the following If...Then...ElseIf statement to a Select...Case statement?

If intValue > 0 And intValue <= 9 Then

discount = .10

Else If intValue >9 And intValue <=20

discount = .15

Else

discount = .20

13.

Private Procedure can be called from anywhere in the project

14.

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

15.

The value returned by InputBox is a string

16.

Given the following section of code, if a programmer called the GetAge() subroutine, what value would the message box display? 

Private Sub GetAge()

Dim UserAge As String

UserAge = 10

UserAge = InputBox("Enter your age", "Get Age")

Call ShowAge

End Sub

Private Sub ShowAge()

Dim UserAge As Integer

UserAge = 0

MsgBox (UserAge)

End Sub

17.

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

18.

To close a form named Form1, you can use:

19.

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

20.

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

21.

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

22.

You have declared 4 variables

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

23.

Which of the following statements is not true about user-defined functions?

24.

A single Case statement can contain multiple values

25.

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

26.

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

27.

What will be the output of the following statement?

txtBox.Text = FormatCurrency(1234.567)

28.

VBA Code run by

29.

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?

30.

What data type can hold any type of data?

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