Skip to main content

Posts

Showing posts from May, 2018

Excel with VBA MCQ with Answers

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 inte

MCQ Excel with VBA

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