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

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
A VBA unit is called a _____.
A)Subroutine
B)Routine
C)Macro
D)Program
3
What does VBA stand for?
A)Visual Basic for Applications
B)Virtual Basic for Advanced programming
C)Very Basic Applications
D)Visual Basic Applied
4
What is a macro used for?
A)To access programs in Excel
B)To create buttons and forms in Excel
C)To automatically complete a series of Excel steps
D)To link Excel files together
5
What Excel tool allows you to view and edit macros?
A)Scenario
B)Visual Basic Editor
C)Solver
D)Data analysis
6
What inside a VBA macro?
A)Excel functions
B)User and Excel instructions
C)Macro instructions
D)Computer code
7
What stores Excel data?
A)Compartment
B)Variable
C)Macro
D)Field
8
Which of the following would NOT be a good use for a macro?
A)Inserting a logo on all spreadsheets
B)Creating a custom button
C)Perform the same calculation on multiple workbooks
D)Computing statistical calculations on data
9
A piece of a macro that completes some sub task is called a(n) _____ procedure.
A)function
B)sub
C)visual
D)sub macro
10
What a macro can have multiple input parameters but returns a single value?
A)Function procedure
B)Sub procedure
C)Object
D)Sub macro







Haag MIS 7eOnline Learning Center

Home > Module M > Multiple Choice Quiz