VISUAL BASIC for APPLICATIONS TEST

Progress

1.

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

2.

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

3.

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

4.

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

5.

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

6.

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

7.

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

8.

32-bit Software/Applications can be installed on:

9.

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

10.

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

11.

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

12.

_______________ is the function to compare 2 strings.

13.

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

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


 

14.

You have declared 4 variables

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

15.

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

16.

___________ statement enables us to trap runtime error.

17.

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?

18.

What is the color of comments?

19.

A Combo box is loaded in the From_Initialize event with:

Combo1.AddItem “Red”

Combo1.AddItem “Blue”

Combo1.AddItem “Green”

20.

Which of the following is default in VBA for data passing?

21.

Which character in VBA, indicates start of a comment

22.

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

23.

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

24.

___________ function is used to return a copy of a string without leading spaces.

25.

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

26.

___________ indicates whether a particular condition is on or off

27.

The value returned by InputBox is a string

28.

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

29.

This control is used for titles/captions

30.

The _______________ control used to insert image to the form

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