VISUAL BASIC for APPLICATIONS TEST

Progress

1.

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

2.

To close a form named Form1, you can use:

3.

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

4.

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

5.

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

6.

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

7.

What is the color of comments?

8.

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

9.

32-bit Software/Applications can be installed on:

10.

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

11.

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

12.

The _______________ control used to insert image to the form

13.

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

14.

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

15.

___________ indicates whether a particular condition is on or off

16.

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

17.

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

18.

You have declared 4 variables

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

19.

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

20.

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

21.

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

22.

___________ statement enables us to trap runtime error.

23.

_______________ is the function to compare 2 strings.

24.

VBA Code run by

25.

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

26.

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

27.

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

28.

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

29.

A single Case statement can contain multiple values

30.

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

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


 

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