VBA Quizz

1. The programming environment which permits coding, compilation, running and debugging from a single window is called

• Integrated Development Environment (IDE)

• Editor

• Highlighter

• Compiler

2. The IDE of VBA supports since it permits drag and drop approach for design of user interface.

• Procedural Approach

• reverse approach

• Rapid Application Development (RAD)

• postfix approach

3. VBA permits of data from spreadsheets.

• reading

• writing

• both reading and writing

• neither reading nor writing

4. VBA supports ready made user interface components like .

• UserForm, CommandButton

• Label, TextBox, ComboBox, ListBox

• TabStrip, OptionButton, ToggleButton

• all of them

5. VBA supports through class module.

• Object Oriented Programming System (OOPS)

• Procedural programming

• Functional programming

• property based model

6. VBA can be used to automate carried out through MS Excel.

• data processing

• graphing

• accessing cell values

• all of them

7. VBA code is compiled into an intermediate code called code.

• P-Code

• MicroSoft Intermediate Code (MSIL)

• Java Virtual Machine (JVM) code

• Android Virtual Device (AVD) code

8. MS Excel creates to execute VBA code.

• real time computer

• mobile computer

• tablet computer

• virual machine

9. ____is the shortcut to open VBA IDE from MS Excel.

• Alt+F11  

• Alt+F8 

• Ctrl+Break  

• Ctrl+G

10._______ is the shortcut to open immediate window in VBA IDE.

• Alt+F11

• Alt+F8                   

       

• Ctrl+Break       

• Ctrl+G