COPA VBA MCQ top most important questions and answers for ITI Theory Exam paper Preparation NCVT/SCVT COPA VBA MCQ 1. VBA stands for_______...
COPA VBA MCQ top most important questions and answers for ITI Theory Exam paper Preparation NCVT/SCVT
COPA VBA MCQ
1. VBA
stands for_________
a)
video basic application
b)
visual basic application
c)
virtual basic application
d)
video basic
Ans. a
2. IDE stands for .
(a) Internal
Development Environment
(b) Integrated
Design Environment
(c) Integrated
Development Environment
(d) Integrated
Drafting Environment
Ans. c
3. MS Office records macros in
language.
(a) VBA
(b) C++
(c) C#
(d) Java
Ans. a
4. Excel file having VBA code is
saved using the extension .
(a) .xlsx
(b) .xlsm
(c) .xlst
(d) .xls
Ans. b
5. Characters should not be used in
VBA variable names.
(a) ' ', .
(b) @, &
(c) $, #
(d) all of them
Ans. d
6. ______ is the shortcut to run a program in VBA IDE.
(a) F9
(b) F5
(c) F1
(d) F2
Ans. b
7. _______function in VBA displays a message.
(a) Format
(b) CVErr
(c) InputBox
(d) MsgBox
Ans. d
8. _______function in VBA displays an input box.
(a) Format
(b) CVErr
(c) InputBox
(d)
MsgBox
Ans. c
9. _______data type in VBA stores
true or false values.
(a) Boolean
(b) Integer
(c) Byte
(d)
Long
Ans. a
10. IF condition in VBA ends with
_______ statement.
(a) ElseIf
(b) End If
(c) Else
(d)
Then
Ans. b
11. Which VBA built in function
returns location at the second string occurs within the first string?
A) Mid( )
B) Chr( )
C) ASC( )
D) Instr( )
Ans. d
12. Which keyword is used to declare the variables in project scope?
A Static
B Private
C Public
D Protect
Ans. c
13. In VBA, How many types of access specifiers available in VBA?
A 2
B 3
C 4
D 6
Ans. a
14. Which type of variable cannot be declared within a procedure in VBA?
A Project scope
B Local scope
C Global scope
D Module scope
Ans. d
15. Which variable recognized only within the procedure in which it is declared?
A Local scope
B Module scope
C Global scope
D Project scope
Ans. a
16. How many levels of variable scope available in VBA?
A 2
B 3
C 4
D 7
Ans. c
17. What will be the output of the
following VBA code? Debug.printformat(#1/1/2017#,”yyyy/mm/dd”)
A 1/1/2017
B Sun, Jan01, 2017
C 2017/01/01
D Sunday, January 01, 2017
Ans. c
18. Which function returns true if the expression is a valid date, otherwise it returns false in VBA?
A CDate( )
B IsDate( )
C Day( )
D Dateadd( )
Ans. b
19. Which function returns the day of the month (number from 1 to 31) given date value in VBA?
A Day( )
B Date( )
C Month( )
D Date part( )
Ans. a
20. Which color of dot indicate the breakpoint in VBA?
A Grey
B Yellow
C Maroon
D Red
Ans. d
21. Which shortcut key is used to set the properties of form while designing?
A F4
B Ctrl + F4
C Alt + F4
D Shift + F4
Ans. a
22. Which shortcut key is used to open code window in VBA?
A F7
B Alt + F7
C Ctrl + F7
D Shift + F7
Ans. a
23. Which
code is used to display a user form in VBA?
A Load user Form1
B User
Form1.Show
C User Form1.Show False
D User
Form1.Load
Ans. b
24. Which
character is to be suffixed for long data type in VBA?
A &
B !
C #
D
@
Ans. a
25. How many
numeric data types available in Excel VBA?
A 4
B 5
C 7
D 8
Ans. c
26. What is
the another name for keywords in VBA?
A Literals
B Variables
C User defined words
D Reserved words
Ans. d
27. Which
key word is used to declare the variable in VBA?
A Sub
B Declare
C Dim
D AS
Ans. c
28. Which
entitie hold data in VBA?
A Literals
B Constants
C Keywords
D Variables
Ans. d
29. Which
worksheet method is used to copy a sheet to another location in the workbook?
A Activate
B Copy
C Save AS
D
Select
Ans. b
30. Which
VBA worksheet property return or sets a string value that represents the object
name?
A Name
B Index
C Range
D
Cells
Ans. a
31. Which
method displays the data form associated with the worksheet in VBA?
A Copy
B Printout
C Show Data Form
D Select
Ans. c
32. .Which VBA property returns a range object that represents all the cells on the worksheet?
A Cells
B Rows
C Index
D Name
Ans. a
33. Which
object is member of the workbook?
A Sheets
B Workbook
C Worksheet
D
Range
Ans. c
34. Which
type of work book method cannot be modified in VBA?
A Close
B Save
C Save AS
D
Protect
Ans. d
35. Which
workbook property returns the name of the object including its path on disk in
VBA?
A Full name
B Name
C Path
D Worksheets
Ans. a
36. Which
type of list box enables one choice of adjacent choice in VBA?
A Drop down list
B Single
- selection list box
C Multiple - selection list box
D Extended
- selection list box
Ans. c
37. Which
button has three states in VBA?
A Option button
B Spin button
C Push button
D Command
button
Ans. a
38. Which
box groups related controls into one visual unit in a rectangle with an
optional label?
A Label box
B Group box
C List box
D Combo box
Ans. b
39. Where
does Excel come in object hierarchy of VBA?
A Range object
B Workbook
object
C Worksheet object
D Application
object
Ans. d
40. Which
shortcut key is used to open project explorer window in VBA?
A Ctrl + R
B Ctrl + P
C Ctrl + W
D
Ctrl + E
Ans. a
41. Which
shortcut key is used to open VBA Editor from the Excel worksheet?
A Ctrl + F11
B Alt + F11
C Ctrl + V
D Ctrl + F7
Ans. b
42. Which
shortcut key is used to step into line - by - line execution in VBA?
A F2
B F4
C F5
D F8
Ans. d
43. What is
called the set of commands bundled together under one name?
A Properties
B Macros
C Procedures
D Events
Ans. b
44. What is called the set of statement that are executed under one name?
A Macros
B Properties
C Procedures
D Events
Ans. c
45. Which one is attributes of an object in VBA?
A Procedures
B Events
C Macros
D Properties
Ans. d
46. What is called double clicking an object in VBA?
A Events
B Macros
C Procedures
D Methods
Ans. a
47. Which is used to type / edit the programming code in VBA?
A Form window
B Properties window
C Immediate window
D Visual basic editor
Ans. d
48. Which simplifies the work to be eliminating or rewriting
the code in VBA?
A Class
B Object
C Macros
D Functions
Ans. c
49. Which type of variable can be accessed or used by subroutines outside the
modules in VBA?
A Static
B Private
C Protect
D Public
Ans. d
50. Where there is no difference between dim and private in VBA?
A Local scope
B Module scope
C Global scope
D Project scope
Ans. b
51. Which method is used to pass the reference to the arguments?
A Ref
B Val
C Reference
D By Ref
Ans. d
52. Which function is used to check whether the given input is numeric or Not
in VBA?
A Numeric( )
B Isnumber( )
C Isnumeric( )
D Isnum( )
Ans. c
53. Which function returns specified part of a given date in VBA?
A Day( )
B Datevalue( )
C Datediff( )
D Datepart( )
Ans. d
54. What is the return type of CSng function in VBA?
A Boolean
B Variant
C Single
D String
Ans. c
55. Which is used to repeats the same steps in case of frequency needed actions
in VBA?
A Class
B Object
C Functions
D Macros
Ans. d
56. Which function returns the integer portion of a number in VBA?
A Int( )
B Format( )
C Abs( )
D Sign( )
Ans. a
57. Which mathematical function generates a random number in VBA?
A Random( )
B Rnd( )
C Rand( )
D Round( )
Ans. b
58. Which operators are concatenation operator in VBA?
A + and -
B & and -
C & and +
D & and *
Ans. c
59. Which type of words cannot use for any other purpose in
VBA?
A Literals
B Keywords
C Constants
D Variables
Ans. b
60. Which is a series of items where all items share the same
properties and methods in VBA?
A Arrays
B Groups
C Methods
D Collections
Ans. d
61. Which box has three states in VBA?
A List box
B Combo box
C Check box
D Group box
Ans. c
62. Which is a proper object hierarchy in VBA?
A Worksheet, Workbook, Application, Range
B Range, Application, Worksheet,
Workbook
C Range, Worksheet, Workbook, Application
D Application, Workbook, Worksheet,
Range
Ans. d
63. Which window displays the entire list of local variables
and their current values in VBA?
A Locals window
B Watch window
C Immediate window
D Debugging window
Ans. a
64. Which window is similar to the locals window, but it is
used to tracing the variables in VBA?
A Call stack window
B
Watch window
C Immediate window
D
Debugging window
Ans. b
65. Which shortcut key is used to open the immediate window?
A Ctrl + G
B Ctrl + L
C Alt + G
D Alt + L
Ans. a
66. What is the another name trigger for an action in VBA?
A Methods
B Modules
C Events
D Macros
Ans. c
67. Which shortcut key allows debugger to run the current
procedure and go line after line called the procedure in VBA?
A Ctrl + Shift + F6
B
Ctrl + Shift + F7
C Ctrl + Shift + F8
D
Ctrl + Shift + F9
Ans. c
68. Which
control is used to increase or decrease a value, such as a number time or date?
A Scroll Bar
B Spin Button
C Combo Box
D Toggle Button
Ans. b
69. Which VBA function
compares given strings and returns -1 if the first string is smaller than the
second string, returns 0 if both are equal and 1 if the first string is greater
than second string?
A Strcmp
B Strcomp
C Compare
D Scmp
Ans.
a
70. Which scope does the
variable declared with dim and remains in the existance only as long as the
procedure in which if is declared is running?
A Global scope
B Local scope
C Module scope
D Project scope
Ans. b
71. What will be the output
for the following VBA code?
Debug.print DateDiff(“yyyy”,”1/12/2016”,”31/1/2017”)
A 0
B 1
C 11
D 30
Ans.
b
72. What will be
the output of the following VBA code?
Sub test()
x = “institue”
Debug.print Format(x,”>”)
End sub
A Institute
B institute
C INSTITUTE
D
instiTUTE
Ans. c
73. What will be
the output of the following VBA code?
Sub test()
a = “ Computer operator”
Debug.Print left(a,10)
End sub
A Operator
B Computer o
C Computer
D
Computer operator
Ans. b
74. What is the full form of UDF in VBA?
A User Data Functions
B User Defined Functions
C Undefined Functions
D Used Data Functions
Ans. b
75. Which of the following is logical operator in VBA?
A +
B -
C *
D And
Ans. d
76. Which
is used to create user interface forms?
A C
B VBA
C HTML
D Javascript
Ans. b
77. What is the alternate name of Bugs?
A Errors
B Keywords
C Variables
D Constants
Ans. a