Module M Programming in Excel with VBA Answer Key
Multiple Choice Questions
1.
VBA is:
Topic: Introduction
2.
Which of the following Excel tools allows you to automate the building and
running of complex calculations that are not included in the standard set of
Excel functions?
3.
Units of VBA code are often referred to as ____.
4.
Which of the following Excel tools allows you to record a sequence of
commands in Excel and save them?
5.
Which of the following is a programming language that includes build-in
commands that mimic the functionality available from menus and dialog
boxes within an application?
6.
Which of the following is a set of Excel actions recorded or written by a
user?
7.
Mr. Joseph is the CEO of a leading manufacturing concern. He wanted his
name and designation to appear in italics on all the spreadsheets of the
company’s annual report. Which of the following Excel action should he use
to achieve this?
8.
Dan was making a science project. He wanted to automate the two steps of
adding a background theme to the cells and then printing the worksheet.
Which of the following Excel actions can help Dan achieve this?
9.
Which of the following statements is true about a macro in Excel?
10.
Which of the following is a built-in function in Excel and does not require a
macro?
11.
Which of the following tools enables users to view and edit a VBA macro?
12.
Which of the following is a component of a macro that performs some
action on or with objects?
13.
Which of the following is a VBA macro that returns a single value?
14.
Which of the following is true about Function procedures?
15.
Which of the following VBA macros can be used in a worksheet formula?
16.
Which of the following does a VBA macro manipulate?
17.
A(n) _____ in VBA is an item available for you to control in your code.
18.
Which of the following refers to a place used to store a piece of information
in Excel?
19.
Which of the following keys will you press to activate the VBE when Excel is
active?
20.
When working on a worksheet, Ben was editing his macros using the Visual
Basic Editor (VBE). After a while he wanted to go back to the Excel
application interface. Which of the following key(s) should Ben use to toggle
between the Excel application interface and the VBE?
21.
Which of the following VBA windows shows every workbook that is currently
open in Excel?
22.
Which of the following key(s) will display the Project Explorer window if it is
not visible on the VBE Program Window?