VBA Assessment

Fill in your basic details before continuing to take the VBA test

Name*
Company
Email*
Phone*
Human Verification-Enter code:
1) Which statement makes the declaration of variable mandatory ? None of the below
Option Mandatory
Option Explicit
Option Declare
2) Which data type is used to store numbers with fractional values ? None of the below
Long
Double
Change
3) What is the shortcut to toggle between VBA Editor and Excel ? None of the below
Alt+F11
Ctrl+F10
Ctrl+F11
4) Which shortcut is used to run the vba code step-by-step ? None of the below
F9
F7
F8
5) Which is the correct way to select cells 1st 5 cells in 1st row ? None of the below
Range("a1:d1").select
Range("a1,d1").select
range(a1:d1).select
6) Which statement will add a new sheet ? None of the below
sheet.add
sheets(1).add
newsheet.add
7) A code to run when a new sheet is added should be written in ? None of the below
Sheet Module
Workbook Module
Standard Module
8) How do you select a non empty cell in a column if cell a1 is active ? None of the below
activecell.down.select
a1.end(xldown).select
activecell.end(xldown).select
9) Which of this statement will select the row of a active cell ? None of the below
activecell.entirerow.select
activecell.activerow.select
activerow.select
10) If activecell is D5, which offset is used to select B2 ? None of the below
(-2,-3)
(-3,-2)
(-2,-4)
11) While assigning values which variable type uses the keyword "Set" ? None of the below
Range
Cells
String
12) Statement to show number of sheets in the activeworkbook ? None of the Below
activesheet.countsheets
sheets.count
activeworkbook.sheets
13) Which Loop requires a counter to count the number of iterations ? None of the below
For-Next
For-Each
Do-While
14) Which loop is best to fill a value until the column to its left is nonblank ? None of the below
For-Next
For-Each
Do-While
15) Which is the best way to insert vlookup function in vba ? None of the below
application.worksheetfunction.vlookup
application.lookup
vba.lookup
Contact us today at info@upskilltechnologies.com or call us at +91-9985130004