Here, We see VBA LinkedIn Skill Assessment Answer. This assessment test consists of 15-20 MCQs to demonstrate your knowledge of your selected skills. MCQs come from different topics – Declarations, Procedures, and Calls, Syntax, User-Defined Elements, VBE..

List of all LinkedIn Skills Assessment Answer

VBA LinkedIn Skill Assessment Answer

Q1. Which two sets of values are printed by this function and sub?

Function GetVitals(ID AsLong, Age AsLong, Optional Weight AsLong) AsString
    GetVitals="ID=" & ID &"Age=" & Age & "Weight=" & Weight
EndFunctionSub ShowVitals()
    Dim ID AsLong, Age AsLong,Weight asLong
    Debug.Print GetVitals(ID:=5,Age:=20)
    Debug.Print GetVitals(ID:=6,Age:=25,Weight:=130)
EndSub

ID=5 Age = 20 Weight=
ID=6 Age = 25 Weight=130

B✔

ID=5 Age = 20 Weight=0
ID=6 Age = 25 Weight=130

ID=5 Age = 20 Weight=Null
ID=6 Age = 25 Weight=130

ID=5 Age = 20
ID=6 Age = 25 Weight=130

Q2. This code shows the first statement of CalledSub. Which calling statement will work properly?

Sub CalledSub(Surname, Age)

call Calledsub “smith”,26
CalledSub(surname=”smith”, Age = 26)
CalledSub(Surname:=”Smith”, Age:=26)
CalledSub”smith”, 26✔

Q3. What is the principal difference between a class and an object?

There is no meaningful difference. The terms are used interchangeably.
A class declares an object’s properties. An object completes the declaration by defining events and methods.
An object is a template for a class.
A class describes the design of an object. An object is an instance of that design.✔

Q4. What value does the MsgBox statement display?

Sub MySub(VarA AsLong, ParamArray VarB() As Variant)
MsgBox VarB(0)
EndSubSub ShowValue()
Call MySub(10, "First arg", 2, 3.1416)
EndSub

2
10
First arg✔
3.1416

Q5. What object is needed to put a user form module in a VBA project?

an associated standard code module
UserForm✔
associated class module
user form class

Q6. What is the output?

Sub UseSum()
Dim TestArray() AsInteger, Total AsIntegerReDim TestArray(1)
TestArray(1) = 6ReDim TestArray(2)
TestArray(2) = 3
Total = WorksheetFunction.Sum(TestArray)
EndSub

3✔
0
9
6

Q7. The Driver subroutine is declared by Sub Driver (Y). Which statement results in a compile error?

Driver x✔
call Driver(x)
call Driver x✔
Driver (X)

Q8. You have several variables to display on a user form, and there are too many variables to display at once. Which control best enables the user to see all the variables?

Frame
multipage
TabStrip
ListBox✔

Q9. Below is a function named SquareIt. Which version of the subroutine named Area results in a compile error?

Function SquareIt(ByRef Basis AsInteger) AsLong
SquareIt = Basis ^ 2EndFunction

sub Area()

Dim Result AsLong, Side AsInteger
Side = 5
Result = Squarelt(Side)
EndSub

Sub Area()

Dim Result AsLong, Side
Side = 5
Result = SquareIt(Cint(Side))
EndSub

Q10. EmailAddress() is an array. It is declared by Dim EmailAddress(10) As String, and option Base 1 is in effect. How many rows and columns are in EmailAddress()?

10 rows and 10 columns
10 rows and 1 column✔
10 rows and 0 columns
1 row and 10 columns

Q11. Which cell is selected if you run this code?

Range("E3:312").Range("B3").Select

F5
F3✔
B3
E3

Q12. Which variable name is valid in VBA?

_MyVar
My_Var✔
My-Var
1MyVar

Reference link

Use the following rules when you name procedures, constants, variables, and arguments in a Visual Basic module: You must use a letter as the first character. You can’t use a space, period (.), exclamation mark (!), or the characters @, &, $, # in the name. Name can’t exceed 255 characters in length.

Q13. Which is a valid definition of a user-defined data type?

A✔

Type CBC
Name AsStringNextAsStringEnd Type

Type CBC
Name AsString
_Next AsStringEnd Type

Type CBC
Name AsString
@OptionAsStringEnd Type

Type CBC
Name AsString
%ForAsStringEnd Type

Q14. What is one way to duplicate a user form from one project into a different project?

Save and close the project with the existing user form.
Click Insert > File.
Browse to the location of the existing project.
Right-click it and select the user form you want to duplicate.

Open the existing user form in Desing Mode.
Right-click the form and select Copy.
Switch to the other project.
Right-click Module and select Paste.

In the Project Explorer, right-click the user form and select Copy.
Switch to the new project.
Right-click UserForms and select Paste.

D✔

Open the existing user form in Design Mode.
Click File > Export File.
Switch to the other project.
Click File > Import File.

Q15. The recording of a macro in Word is likely to be an incomplete record of the user’s actions. Why?

Word’s Macro Recorder does not record actions initiated by keyboard shortcuts.
Word’s Macro Recorder does not support Find & Replace edits.
Word’s Macro Recorder does not record actions initiated by clicking a button on the Ribbon’s Developer tab.
Word’s Macro Recorder does not record actions that involve the selection of text by pointing with the mouse pointer.✔

Q16. Which statement should precede a subroutine’s error handler?

End
Return
Exit Sub✔
Stop

Q17. How many values can MyArray hold?

Option Base 0
Sub BuildArray()
Dim MyArray(5) As Integer

0
32,769
5
6✔

Q18. Which statement is true?

Set establishes a value in a class; Let returns a value from a class.
Let establishes a value in a class; Set returns a value from a class.
Let establish a value in a class; Get returns a value from a class.✔
Get establishes a value in a class; Set returns a value from a class.

Q19. A declaration has a scope, which has three levels. What are they?

Module, Project, and Automation
Procedure, Private Module, and Public Module✔
Subroutine, Module, and Project
Procedure, Project, and Global

Q20. There are two references that must be selected in the Visual Basic Editor in order for any Visual Basic code to run in Excel. What are these two references?

MS Excel object library and MS Office object library
VBA and MS Office object library
VBA and Excel object library✔
MS Excel object library and OLE automation

Q21. Which action will cause your project to reset its variables?

Edit the list of arguments of the current routine while in debug mode.
Click End in a run-time error dialog.✔
Add an ActiveXcontrol to a worksheet.
all of these answers

Q22. Which keyboard shortcut causes VBE to locate the declaration of a procedure?

Shift+F3
Alt+F (Windows) or Option+F (Mac)
Shift+F2✔
Ctrl+F (Windows) or Command+F (Mac)

Q23. When you define a new class of object, where do you assign a name to it?

in the class module’s name
in the class module’s code
in a standard module’s code
in a standard module’s Properties✔

Q24. How does a class module indicate that it uses a particular interface?

The interface itself is part of the class module.
by means of the Interface keyword and the name of the interface
by means of the Implements keyword and the name of the interface
The name of the interface is passed as a parameter.✔

Q25. What is needed for the contents of Module1 to be available to other modules in a VBA project, but not to any other VBA project?

Set Option Global at the top of Module1
Declare module-level variables as Private
Set Module Level Scope at the top of Module1
Set Option Private Module at the top of Module1✔

Q26. When used with an array named MyArray, what is the preferred way to set the beginning and ending values of a loop control variable?

For i = 0 To UBound(MyArray,1)
For i = 1 To UBound(MyArray,1)
For i = LBound(MyArray,1) To UBound(MyArray,1)✔
It depends on whether Option Base 0 or Option Base 1 is in use.

Q27. What is the value of Test3?

Enum TestEnum
    Test1
    Test2
    Test3
EndEnum

0
1
3
2✔

Q28. Which statement declares an array?

Dim MyArray() As Integer✔
Dim MyArray() As Array
Dim MyArray As Integer
Dim MyArray As Array

reference

Q29. To use VBA code to maintain a different VBA project, you can make use of VBA’s extensibility. What is needed to enable extensibility?

Set Macro Security to Trust Access to the VBA Project Object Model
The project’s workbook should be protected in the Ribbon’s Review tab
Include a reference to Microsoft VBA Extensibility 5.3✔
Include a reference to Microsoft VBA Extensibility 5.3 and set Macro Security to Trust Access to the VBA Project Object Model

Q30. How do you add a user form to a VBA project?

Select the project in the Project window of the Visual Basic Editor
Click the Design Mode button and select Insert Mode

Select the project in the Project window of the Visual Basic Editor
Click the Toolbox button and select UserForm

Select the project in the Project window of the Visual Basic Editor
Right-click the Run menu and select Customize

D✔

Select the project in the Project window of the Visual Basic Editor
Click Insert > UserForm

Q31. Explicit variable declaration is required. MyVar is declared at both the module and the procedure level. What is the value of MyVar after first AAA() and then BBB() are run?

Dim MyVar AsStringSub AAA()
Dim MyVar AsString
MyVar = "Procedure AAA Scope"EndSubSub BBB()
MyVar = "Procedure BBB Scope"EndSub

MyVar equals “Procedure AAA Scope”
ISNULL(MyVar) is TRUE
MyVar equals “Procedure BBB Scope”✔
MyVar is NULL

Q32. Which code block from class modules returns a compile error?

PublicPropertyGet HDL() AsDouble
HDL = pHDL
EndPropertyPublicPropertyLet HDL(Value AsDouble)
pHDL = Value
EndProperty

PropertyGet HDL() AsDouble
HDL = Value
EndPropertyPropertyLet HDL(Value AsDouble)
pHDL = Value
EndProperty

PublicPropertyGet HDL() AsDouble
HDL = Value
EndPropertyPublicPropertyLet HDL(Value AsDouble)
pHDL = Value
EndProperty

D✔

PublicPropertyGet HDL() AsSingle
HDL = pHDL
EndPropertyPublicPropertyLet HDL(Value AsDouble)
pHDL = Value
EndProperty

Q33. If VBA code declares FileCount as a constant rather than a variable, the code tends to run faster. Why is this?

The scope of constants is limited to the procedure that declares them
Constants are declared at compile time, but variables are declared at run time
Once declared in a project, the value of a constant cannot be changed. There is no need to look up the current value of FileCount when it is a constant.
The Const declaration specifies the most efficient type given the constant’s value✔

Q34. A VBA project must declare four classes. How many class modules are needed?

two (one for the properties and one for the methods)
one (each class is declared in the same module)
four (one for each class)
as many as are required by the variable types that the objects return✔

Q35. What does this code display?

Sub MakeErrors()
Dim Y As Variant, Z As Variant
OnErrorResumeNext
Y = 1 / 0
MsgBox "Y = " & Y
OnErrorGoTo0
Z - (0 - 3) ^ 0.5
MsgBox "Z = " & Z
EndSub

an error message
Y and Z
Z = in a message box and then a subsequent error message✔
Y = in a message box and then a subsequent error message

Q36. The VBA code block shown in the following four options runs when UserForm1’s CommandButton1 button is clicked. Which block of code leaves UserForm1 loaded but not visible until the FoundErrors function has checked it, and then enables processing to continue if no errors are found?

PrivateSub CommandButton1_Click()
If FoundErrors(Me) Then _
Me.Show
EndSub

PrivateSub CommandButton1_Click()
IfNot FoundErrors(UserForm1) Then _
Unload UserForm1
EndSub

C✔

PrivateSub CommandButton1_Click()
Me.Hide
DoWhile FoundErrors(Me)
Me.Show
LoopEndSub

PrivateSub CommandButton1_Click()
DoWhile FoundErrors(UserForm1)
UserForm1.show
LoopEndSub

Q37. Which is the correct way to structure a With block?

With Selection
&TypeText Text:="8/24/2019"
&TypeParagraph
&TypeText Text:="1161 Alamosa Drive"EndWith

B✔

With Selection
.TypeText Text:="8/24/2019"
.TypeParagraph
.TypeText Text:="1161 Alamosa Drive"EndWith

With Selection
TypeText Text:="8/24/2019"
TypeParagraph
TypeText Text:="1161 Alamosa Drive"EndWith

With Selection:
&TypeText Text:="8/24/2019"
&TypeParagraph
&TypeText Text:="1161 Alamosa Drive"EndWith