VBA MCQ Questions and answers PDF Download free Basic MCQs for competitive exams (COPA, CCC, GATE etc.) and interview preparation. Visual Ba...
VBA MCQ Questions and answers PDF Download free Basic MCQs for competitive exams (COPA, CCC, GATE etc.) and interview preparation. Visual Basic for Application programming excel macros question.
VBA MCQ Questions and Answers
1. The programming environment which permits coding, compilation, running
and debugging from a single window is called
.(a) Integrated Development Environment (IDE)
(b) Editor
(c) Highlighter
(d) Compiler
Ans. a
2. The IDE of VBA supports since it permits drag and drop approach for
design of user interface.
(b) reverse approach
(c) Rapid Application Development (RAD)
(d) postfix approach
Ans. c
3. VBA permits of data from spreadsheets.
(a) reading
(b) writing
(c) both reading and writing
(d) neither reading nor writing
Ans. c
4. VBA supports ready made user interface components like .
(a) UserForm, CommandButton
(b) Label, TextBox, ComboBox, ListBox
(c) TabStrip, OptionButton, ToggleButton
(d) all of them
Ans. d
5. VBA supports through class module.
(a) Object Oriented Programming System (OOPS)
(b) Procedural programming
(c) Functional programming
(d) property based model
Ans. a
6. VBA can be used to automate carried out through MS Excel.
(a) data processing
(b) graphing
(c) accessing cell values
(d) all of them
Ans. d
7. VBA code is compiled into an intermediate code called code.
(a) P-Code
(b) MicroSoft Intermediate Code (MSIL)
(c) Java Virtual Machine (JVM) code
(d) Android Virtual Device (AVD) code
Ans. a
8. MS Excel creates to execute VBA code.
(a) real time computer
(b) mobile computer
(c) tablet computer
(d) virual machine
Ans. d
9. ____is the shortcut to open VBA IDE from MS Excel.
(a) Alt+F11
(b) Alt+F8
(c) Ctrl+Break
(d) Ctrl+G
Ans. a
10._______ is the shortcut to open immediate window in VBA IDE.
(a) Alt+F11
(b) Alt+F8
(c) Ctrl+Break
(d) Ctrl+G
Ans. d
11. _______is the shortcut to open list of macros.
(a) Alt+F11
(b) Alt+F8
(c) Ctrl+ Break
(d) Ctrl+ G
Ans. b
12. is the shortcut to stop execution of programs in VBA IDE.
(a) Alt+F11
(b) Alt+F8
(c) Ctrl+ Break
(d) Ctrl+ G
Ans. c
13. ______ is the shortcut to display information relating to selected
component in VBA IDE.
(a) Ctrl+I
(b) Ctrl+J
(c) Ctrl+R
(d) Ctrl+Shift+I
Ans. a
14. ______is the shortcut to properties and methods of a component in VBA
IDE.
(a) Ctrl+ I
(b) Ctrl+ J
(c) Ctrl+ R
(d) Ctrl+ Shift+ I
Ans. b
15._______ is the shortcut to display project explorer in VBA IDE.
(a) Ctrl+ I
(b) Ctrl+ J
(c) Ctrl+ R
(d) Ctrl+ Shift+ I
Ans. c
16. ______is the shortcut to display parameter information for selected
element in VBA IDE.
(a) Ctrl +I
(b) Ctrl+ J
(c) Ctrl+ R
(d) Ctrl+ Shift+ I
Ans. d
17. _______is the shortcut to add breakpoint in VBA IDE.
(a) F9
(b) F5
(c) F1
(d) F2
Ans. a
18. ______is the shortcut to display object browser in VBA IDE.
(a) F9
(b) F5
(c) F1
(d) F2
Ans. d
19. _______is the shortcut to display properties window in VBA IDE.
(a) F4
(b) F5
(c) F1
(d) F2
Ans. a
20.__________structure
is useful for decision involving three or more options.
a) Switch
b) Select case
c) Function
d) List
Ans.
b
21. VBA has a coding, compilation,
running and debugging environment called
(a) Integrated Development Environment (IDE)
(b) Editor
(c) Highlighter
(d) Compiler
Ans. a
22. In VBA, the function Asc converts given character value to numeric code
in______ system.
(a) American Standard Code for Information Interchange (ASCII)
(b) Double Byte Character Set (DBCS)
(c) Unicode
(d) none of them
Ans. a
23. In VBA, the function AscB converts given character value to numeric
code in ______system.
(a) American Standard Code for Information Interchange (ASCII)
(b) Double Byte Character Set (DBCS)
(c) Unicode
(d) none of them
Ans. b
24. In VBA, the function AscW converts given character value to numeric
code in ________system.
(a) American Standard Code for Information Interchange (ASCII)
(b) Double Byte Character Set (DBCS)
(c) Unicode
(d) none of them
Ans. c
25. In VBA, the function Chr converts given numeric value to character
value in _______system.
(a) American Standard Code for Information Interchange (ASCII)
(b) Double Byte Character Set (DBCS)
(c) Unicode
(d) none of them
Ans. a
26. In VBA, the function ChrB converts given numeric value to character
value in ______system.
(a) American Standard Code for Information Interchange (ASCII)
(b) Double Byte Character Set (DBCS)
(c) Unicode
(d) none of them
Ans. b
27. In VBA, the function ChrW converts given numeric value to character
value in _______system.
(a) American Standard Code for Information Interchange (ASCII)
(b) Double Byte Character Set (DBCS)
(c) Unicode System
(d) none of them
Ans. c
28. In VBA, Cstr function converts any data to_____ type.
(a) Integer
(b) Double
(c) Single
(d)
String
Ans. d
29. CDbl function converts String to _________type.
(a) Integer
(b) Double
(c) Single
(d)
String
Ans. b
30. In VBA, CInt function converts String to _______type.
(a) Integer
(b) Double
(c) Single
(d)
String
Ans. a
31. In VBA, Csng function converts String to _______type.
(a) Integer
(b) Double
(c) Single
(d)
String
Ans. c
32. In VBA, Val function converts String to _______type.
(a) number
(b) byte
(c) Currency
(d) Decimal
Ans. a
33. In VBA, CByte function converts String to ______type.
(a) number
(b) byte
(c) Currency
(d) Decimal
Ans. b
34. In VBA, CCur function converts String to _______type.
(a) number
(b) byte
(c) Currency
(d) Decimal
Ans. c
35. In VBA, CLng function converts String to_______ type.
(a) Long
(b) byte
(c) Currency
(d) Decimal
Ans. a
36. In VBA, CDec function converts String to_______ type.
(a) number
(b) byte
(c) Currency
(d) Decimal
Ans. d
37. ______function in VBA creates a custom
error message.
(a) Format
(b) CVErr
(c) InputBox
(d) MsgBox
Ans. b
38. ________function in VBA formats a number according to given text
strings containing 0, # and comma (,).
(a) Format
(b) CVErr
(c) InputBox
(d) MsgBox
Ans. a
39. Boolean data type in VBA has size of ______
(a) 1 byte
(b) 2 bytes
(c) 3 bytes
(d) 4 bytes
Ans. b
40. Byte data type in VBA has size of________
(a) 1 byte
(b) 2 bytes
(c) 3 bytes
(d) 4 bytes
Ans. a