VBA | Visual Basic for Applications Test

VISUAL BASIC for APPLICATIONS TEST

Progress

1.

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

Close it immediately and delete the file
Check where the file originates from, and if it is a trusted source or your own workbook, click Enable Content
Close the file then right-click and rename it before opening it again
None of the options listed above are correct

2.

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

The program will malfunction when it is executed.
When the value of myName is changed in one Sub procedure, it will also be changed in the other Sub procedure.
Visual Basic’s smart editor will alert you that this is an error before the program is executed
The two variables will be local to their respective Sub procedures.

3.

VBA Code run by

F9
F5
F4
F11

4.

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

Incomplete Loop
Random Loop
Infinite Loop
Pretest Loop

5.

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

True
False

6.

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

Autosize
Index
Items
Multiline

7.

An object is composed of :

Properties
Methods
Events
All the above

8.

The _______________ control used to insert image to the form

Picture
Shape
Image
Option

9.

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

True
False

10.

To close a form named Form1, you can use:

Form1.hide()
Form1.close()
Me.close()
Form1.exit()

11.

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

A.to change how objects look and feel.
when opening programs stored on a hard drive.
to allow the developer to graphically design program components.
to set program related options like Program Name, Program Location, etc.

12.

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

If Then
Do Until
For Next
Do While

13.

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

LoadImage
LoadPicture
LoadGraphics
None of these

14.

The value returned by InputBox is a string

True
False

15.

Basic Excel Object model as follows:

Applications -> Workbooks -> Worksheets -> Range/Chart
Workbooks -> Pages -> Worksheets -> Range/Chart
Applications -> Worksheets -> Workbooks -> Range/Chart

16.

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

Option Declare
Option Explicit
Option Implicit
Option Variables

17.

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

Frame
Label
List box
Command Button

18.

This control is used for titles/captions

Label
Title
Textbox
Text

19.

What will be the output of the following statement?

txtBox.Text = FormatCurrency(1234.567)

$1,234.57
1,234.57
$1234.57
$1234.567

20.

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

Select Case intValue Case Is 1 To 9 discount = .10 Case Is 10 To 19 discount = .15 Case Else discount = .20 End Select
Select Case intValue Case 1 To 9 discount = .10 Case 10 To 19 discount = .15 Case Else discount = .20 End Select
Select Case intValue Case 1 To 9 discount = .10 Case 10 To 20 discount = .15 Case Else discount = .20 End Select

21.

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

Procedure
Function
Module
None of the above

22.

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

ByVal
ByRef
Depends upon data type
Depends upon command

23.

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

634
634.0
0.00634
6.34

24.

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

select-case
if-endif
do-until
do loop -while

25.

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?

Case 1 To 8
Case 1 To 5, 8
Case 1 To 8, 5
Case 1 To 5; 8

26.

Private Procedure can be called from anywhere in the project

True
False

27.

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

Procedure
Call
Variable
Function

28.

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

True
False

29.

32-bit Software/Applications can be installed on:

Only 32-bit Systems
Only 64-bit Systems
32-bit and 64-bit Systems

30.

What is the color of comments?

Blue
Green
Red
Black

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