VISUAL BASIC for APPLICATIONS TEST

Progress

1.

Why Macro is used

2.

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

3.

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

4.

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

5.

What do you need to select to set the developer mode?

6.

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

7.

VBA Code run by

8.

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

9.

_______________ is the function to compare 2 strings.

10.

The _______________ control used to insert image to the form

11.

You have declared 4 variables

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

12.

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

13.

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

14.

To break up long lines of code, the line continuation character in VBA is

15.

The value returned by InputBox is a string

16.

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

17.

Which character in VBA, indicates start of a comment

18.

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

19.

A Combo box is loaded in the From_Initialize event with:

Combo1.AddItem “Red”

Combo1.AddItem “Blue”

Combo1.AddItem “Green”

20.

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

21.

32-bit Software/Applications can be installed on:

22.

An object is composed of :

23.

An array that maintains multiple sets of information referenced by more than one index is called ________________

24.

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

25.

What is the color of comments?

26.

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

27.

A single Case statement can contain multiple values

28.

What data type can hold any type of data?

29.

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

30.

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

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