Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)

1
VBA is:
A)a Microsoft programming language used to extend Excel functions.
B)a statistical tool developed by Microsoft for financial analysts.
C)an open-source programming environment.
D)a Microsoft programming environment that replaces Excel.
2
A unit of VBA code is called a _____.
A)subroutine
B)routine
C)macro
D)program
3
Which of the following is a programming language that includes built-in commands that mimic the functionality available from menus and dialog boxes within an application?
A)Macro language
B)HTML
C)FrontPage
D)Query-by-example tool
4
Which of the following refers to computer code, in VBA, that performs some action on or with objects?
A)Excel function
B)Sub procedure
C)Primary key
D)Integrity constrain
5
In VBA, which of the following is a place to store a piece of information?
A)Compartment
B)Variable
C)Macro
D)Field
6
Which of the following VBE tools displays a tree diagram that consists of every workbook currently open in Excel?
A)Menu bar
B)Code window
C)Immediate window
D)Project Explorer window
7
Which of the following is most useful for executing VBA statements directly and for debugging your code?
A)Properties window
B)Immediate window
C)Project Explorer window
D)Code window
8
Function procedure differs from Sub procedure in that Function procedure:
A)refers to a set of programming instructions that performs some action.
B)is an information statement that you provide to VBA.
C)is a set of programming instructions that returns a single value.
D)is a code in a VBA module.
9
Which of the following would you use to declare a variable explicitly?
A)Dim statement
B)Operator
C)Do-While loop
D)Comment tool
10
Which of the following structures is useful for decisions involving three or more options?
A)For-Next
B)ElseIf
C)If-Then
D)Select Case





To learn more about the book this website supports, please visit its Information Center.
Copyright (c)2013 McGraw-Hill Education .
Any use is subject to the Terms of Use and Privacy Notice | Report Piracy


Management Information SystemsOnline Learning Center

Home > Module M > Multiple Choice Quiz