GOVERNMENT INDUSTRIAL TRAINING INSTITUTE – DHARMAPURI
1.
What is VBA?
a)
A Microsoft programming language used to extend Excel functions
b)
A GUI Excel interface for the novice developer
c)
A open-source programming environment that works with Excel
d)
A Microsoft programming environment that replaces Excel
2.
2.What does VBA stand for?
a)
Visual Basic for Applications c) Virtual Basic for Advanced
programming
b)
Very Basic Applications d)
Visual Basic Applied
3.
3.What is a macro used for?
a)
To access programs in Excel
c) To create buttons and forms in Excel
b)
To automatically complete a series of Excel steps d)
To link Excel files together
4. 4.
What does a VBA macro consist of?
a)
Excel functions
b)
User instructions and Excel functions
c)
Computer code that performs some actions on or with objects
d)
Macro instructions that direct the user application and provide help to
the user
5. 5.
Which of the following VBA windows shows the code of the active object?
a)
Explorer Window b) Properties window c) Immediate window d)
Code window
6.
6.What stores Excel data?
a)
Compartment b) Macro c)
Variable d) Field
7.
7.In VB a variable name cannot be more than _____ characters.
a)
255 b) 300 c) 455 d)
400
8. 8.
__ are the programming elements whose value can be
changed during the execution of program.
a) Constant b) Variable c) Fixed d) Change
9.
___ Bytes are required for the byte data type in
VBA.
a) 1 b) 2 c)
4 d)
8
10.
___ Bytes are required for the integer data types
in VBA.
a)
1 b)2 c) 4 d) 8
11.
___ Bytes are required for the long data types in
VBA.
a) 1 b)2 c) 4 d) 8
12.
___ Bytes are required for the Boolean data types
in VBA.
a)
1 b)2 c) 4 d) 8
13.
___ Bytes are required for the single data types in
VBA.
a)
1 b)2 c) 4 d) 8
14.
___ Bytes are required for the double data types in
VBA.
a) 16 b)2 c) 8 d) 4
15.
___ Bytes are required for the decimal data types
in VBA.
a ) 16 b)14 c) 8 d) 32
16.
___ Bytes are required for the currency data types
in VBA.
a) 16 b)2 c) 8 d) 4
17.
___ Bytes are required for the date data types in
VBA.
a) 16 b)2 c) 8 d) 4
18.
___ Bytes are required for the object data types in
VBA.
a)
16 b)2 c) 8 d) 4
19.
Which is not a Data type of VBA
a)
Currency b)Text c) Date d)
Time
20.
___ function returns the current system date only
in VBA
a)
Date b)Time c)
Now d) After
21.
___ function returns the current date and time in
VBA
a)
Currency b)Now c)
Date d) Time
22.
___ function returns the current system time only in VBA
a)
Date b)Time c)
Now d) After
23.
___ Function
in VBA returns the difference between two dates.
a)
Date() b)Time() c)
Datediff() d) timediff()
24.
___ Function in VBA returns the date after which a
certain date time has been added.
a)
Date() b)Time() c) Datediff() d) dateadd()
25.
___ Function returns the square root of any number
in VBA.
a)
Sqr() b)sqrt() c)
root() d) dateadd()
26.
__ Function returns the integer part of any number
in VBA.
a)
Integer () b)sqrt() c)
int() d) number()
27.
___ is the syntax used to create a message box in
VBA
a)
“Message”,icon+button,”Title” c) “Message”,Title +button,”Title”
b)
“Message”,button+button,”Title” d) “Message”,icon+button,”icon”
28.
In message box of VBA the YES button represents the
value __
a)
9 b) 10 c)
1 d) 5
29.
In message box of VBA the OK button represents the
value of ___
a)
1 b) 10 c)
10 d) 5
30.
A small rectangular window comes for taking input
value is known as __ in VBA.
a) Input box b) message box c) error
box d)display box
You idiot where is answer
ReplyDeleteYou are brilliant then find the answer
Delete