GOVERNMENT INDUSTRIAL TRAINING INSTITUTE – DHARMAPURI
1.
What is VBA?
a)
A Microsoft programming language used to extend Excel functions
2.
What does VBA stand for?
a)
Visual Basic for Applications
3.
What is a macro used for?
To automatically
complete a series of Excel steps
4.
What does a VBA macro consist of?
B) Computer code that performs some actions on or
with objects
5.
Which of the following VBA windows shows the code of the active object?
d) Code window
6.
What stores Excel data?
c) Variable
7.
In VB a variable name cannot be more than _____ characters.
a)
255
8.
__ are the programming elements whose value can be
changed during the execution of program.
b) Variable
9.
___ Bytes are required for the byte data type in
VBA.
a) 1
10.
___ Bytes are required for the integer data types
in VBA.
b)2
11.
___ Bytes are required for the long data types in
VBA.
c) 4
12.
___ Bytes are required for the Boolean data types
in VBA.
b)2
13.
___ Bytes are required for the single data types in
VBA.
c) 4
14.
___ Bytes are required for the double data types in
VBA.
c) 8
15.
___ Bytes are required for the decimal data types
in VBA.
b)14
16.
___ Bytes are required for the currency data types
in VBA.
c) 8
17.
___ Bytes are required for the date data types in
VBA.
c) 8
18.
___ Bytes are required for the object data types in
VBA.
d) 4
19.
Which is not a Data type of VBA
b)Text
20.
___ function returns the current system date only
in VBA
a)
Date
21.
___ function returns the current date and time in
VBA
b)Now
22.
___ function returns the current system time only in VBA
b)Time
23.
___ Function
in VBA returns the difference between two dates.
c) Datediff()
24.
___ Function in VBA returns the date after which a
certain date time has been added.
d) dateadd()
25.
___ Function returns the square root of any number
in VBA.
a)
Sqr()
26.
__ Function returns the integer part of any number
in VBA.
c) int()
27.
___ is the syntax used to create a message box in
VBA
a)
“Message”,icon+button,”Title”
28.
In message box of VBA the YES button represents the
value __
a)
9
29.
In message box of VBA the OK button represents the
value of ___
a)
1
30.
A small rectangular window comes for taking input
value is known as __ in VBA.
a) Input box
Thank you so much for this amazing post keep it up.
ReplyDeleteSEO Company Islamabad I am feeling lucky to share with you our SEO website.
Appreciate you sharing, great article.Much thanks again. Really Cool.
ReplyDeletetableau training