Deck 12: Expanding Excel With Visual Basic for Applications

Question 1

When you hide screen elements that are part of the worksheet,they will be hidden in that worksheet only.

Answer 1

True

Question 2

The window in the accompanying figure displays each property's name in the right column and its value in the left column.

Answer 2

False

Question 3

The macro recorder writes the most efficient code and records only those commands and actions you want in the finished project.

Answer 3

False

Question 4

The VBA code "SUM(A1:A4)".Formula = Range("A5")changes the formula of cell A5 to sum up the values in the range A1:A4.

Question 5

A project cannot contain more than one module.

Question 6

Unlike Windows Explorer,Project Explorer does not allow you to view your project components hierarchically.

Question 7

The MsgBox function is similar to the InputBox function except that the MsgBox function does not contain a text box for the user to enter values.

Question 8

The And operator requires only one of two combined logical expressions to be true.

Question 9

In the window in the accompanying figure,to view the list of properties in alphabetical order and by category,you can click the tabs at the top of the window.

Question 10

Since Visual Basic for Applications is an application-specific language,Excel and Access use different variations of VBA.

Question 11

VBA allows you to create custom dialog boxes.

Question 12

All objects have properties.

Question 13

One important use of the Visual Basic Editor is to manage your projects.

Question 14

The VBA code Set WBook = Workbooks("Smith")stores the WBook variable in the Smith workbook.

Question 15

The VBA method ActiveWorkbook.SaveAs saves the current workbook.

Question 16

In VBA,a project consists of a single macro in one worksheet.

Question 17

You can quickly switch to the Visual Basic Editor by pressing the Shift+Alt keys.

Question 18

The Excel macro recorder is the fastest way to create macros.

Question 19

Macro buttons on the Quick Access Toolbar can be customized to display unique icons.

Question 20

To open the Visual Basic Editor you must first click the Macros button in the Code group on the Developer tab.

Question 21

All procedures are considered public unless specified as Private._________________________

Question 22

The Project Explorer window is dockable._________________________

Question 23

Logical operators are used to combine expressions within a(n)condition._________________________

Question 24

Attributes such as name,size,or color are known as properties._________________________

Question 25

When the Visual Basic Editor opens,it usually displays three windows: the Project Explorer window,the Project window,and the Code window._________________________

Question 26

In Excel,ChartObject refers to a chart embedded within a worksheet._________________________

Question 27

Hold down the Ctrl Key and press the Home key to go to cell A1 in the worksheet._________________________

Question 28

The Display property of the Worksheet object determines if a worksheet is hidden._________________________

Question 29

To quickly switch to the Visual Basic Editor,press ____ on your keyboard.

A) Esc + F1
B) Ctrl + F7
C) Alt + F11
D) Enter + F12

Question 30

The application shown in the accompanying figure is the Visual Basic ____.

A) Manager
B) Explorer
C) Writer
D) Editor

Question 31

As you enter a command in the Project window shown in the accompanying figure,its effects are immediately applied to that workbook._________________________

Question 32

To determine whether an expression used in a condition is true or false,the expression needs to contain a(n)condition operator._________________________

Question 33

Property values containing text strings and numeric values do not need to be placed within quotation marks._________________________

Question 34

VBA is a(n)object-linked programming language._________________________

Question 35

In the function user = InputBox("Enter your username" ,"Log In"),"user" is the prompt._________________________

Question 36

A project might contain several different modules._________________________

Question 37

To go to cell A1 in a worksheet,hold down the ____ key and press the Home key.

A) Alt
B) Enter
C) Ctrl
D) Esc

Question 38

Excel macros are written in the programming language ____.

A) Perl
B) JavaScript
C) HTML
D) VBA

Question 39

To edit a VBA macro,you need to use the Visual Basic ____.

A) Manager
B) Explorer
C) Writer
D) Editor

Question 40

The VBA code Worksheets("Raw Data").Change = "Sample Data" changes the name of the "Raw Data" worksheet to "Sample Data"._________________________

Question 41

A(n)____ is a collection of macros,worksheets,data entry forms,and other items that make up a customized application.

A) window
B) project
C) object
D) applet

Question 42

Within each project are various items called ____.

A) keys
B) variants
C) sources
D) objects

Question 43

The item marked 1 in the accompanying figure is the ____.

A) Project Explorer
B) Code window
C) Properties window
D) VBA Manager

Question 44

When the Visual Basic Editor opens it usually displays ____ windows.

A) three
B) six
C) seven
D) eight

Question 45

The following is a type of procedure supported by Visual Basic: ____.

A) function procedure
B) attribute procedure
C) formula procedure
D) settings procedure

Question 46

The item marked 4 in the accompanying figure is the ____.

A) Project Explorer
B) Code window
C) Properties window
D) VBA Manager

Question 47

A(n)____ is any element within the Excel working environment,such as a worksheet,macro,or workbook.

A) source
B) component
C) object
D) window

Question 48

The ____ is a Visual Basic Editor window.

A) Code Explorer
B) Properties window
C) Project window
D) Code Preview

Question 49

To open the window in the accompanying figure,first click ____ on the menu bar.

A) Display
B) VBA
C) View
D) Code

Question 50

Formatting a cell or displaying a chart are examples of ____ procedures in Visual Basic.

A) sub
B) function
C) property
D) attribute

Question 51

When you enter the name and description of a project,you are actually modifying two of its ____.

A) keys
B) properties
C) links
D) objects

Question 52

When you want to view the VBA macro code associated with any item in Project Explorer,you use the ____ window.

A) Macro
B) Module
C) Code
D) Project

Question 53

The Project ____ is a window in the Visual Basic Editor that displays a hierarchical list of all currently opened projects and their contents.

A) Manager
B) Browser
C) Explorer
D) Editor

Question 54

A ____ procedure returns a value.

A) sub
B) function
C) property
D) calculation

Question 55

Visual Basic supports ____ kinds of procedures.

A) two
B) three
C) six
D) eleven

Question 56

All of the following are attributes of an object except ____.

A) name
B) size
C) location on the screen
D) name of creator

Question 57

The default project name given to new projects is ____.

A) VBObject
B) NewProject
C) Project
D) VBAProject

Question 58

To create sub procedures without using the macro recorder,you need to know some rules of VBA ____.

A) formulas
B) statistics
C) metrics
D) syntax

Question 59

The item marked 3 in the accompanying figure is the ____ code.

A) Perl
B) VBA
C) Java
D) JavaScript

Question 60

A(n)____ is a collection of VBA macros.

A) aggregate
B) module
C) object
D) component

Question 61

To step through a sub procedure one line at a time,click in the sub procedure code and then repeatedly press the ____ key.

A) F7
B) F8
C) Alt
D) Shift

Question 62

Procedure names cannot contain ____.

A) spaces
B) numbers
C) letters
D) any of the above

Question 63

The Excel object you will use to create VBA programs and refer to a defined name in a workbook is ____.

A) Name
B) Range
C) Chart
D) Workname

Question 64

The VBA code ____ refers to the collection of cells in the cell range,A1:B10.

A) Objects(A1:B10)
B) Names(A1:B10)
C) (A1:B10)
D) Range("A1:B10")

Question 65

To run an entire sub procedure,press the ____ key.

A) Alt
B) F5
C) F6
D) Shift

Question 66

To dock and undock the window in the accompanying figure,right-click the window and then click the ____ on the shortcut menu.

A) Location
B) Stationary
C) Dockable
D) Movement

Question 67

The object name ____ refers to the worksheet currently being displayed in the workbook.

A) "DisplaySheet"
B) "ActiveSheet"
C) "ThisSheet"
D) "SheetDisplayed"

Question 68

All of the following are properties of the Range object EXCEPT ____.

A) Address
B) Formula
C) Comment
D) Name

Question 69

Click ____ on the menu bar and then click Immediate Window to open the window in the accompanying figure.

A) View
B) Code
C) Display
D) Options

Question 70

The cell reference of a range is located in the ____ property of the Range object.

A) Where
B) CellRef
C) Reference
D) Address

Question 71

The Excel object you will use to create VBA programs and refer to a range in a worksheet is ____.

A) Cell
B) Range
C) Chart
D) Name

Question 72

To open the Code window to the contents of a specific module,select the module in the Project Explorer window and then press the ____ key.

A) Esc
B) F7
C) F8
D) Shift

Question 73

Procedure names can be up to ____ characters in length.

A) 125
B) 126
C) 255
D) 256

Question 74

You can open the Immediate window in the accompanying figure by pressing the ____ keys in the Visual Basic Editor.

A) Ctrl+A
B) Ctrl+G
C) Shift+A
D) Alt+I

Question 75

The Excel object you will use to create VBA programs and refer to a chart embedded within a worksheet is ____.

A) EmbedChart
B) ChartEmbed
C) ChartObject
D) Application

Question 76

The object name ____ refers to the workbook containing the macro code that is currently running.

A) ThisCell
B) ThisWorkbook
C) ActiveWindow
D) ActiveWorkbook

Question 77

The ____ command is always the last line in a sub procedure and tells Excel to stop running the macro.

A) End
B) Quit Sub
C) End Sub
D) Stop Sub

Question 78

Comments are usually displayed by the editor in ____ font.

A) italicized
B) green
C) red
D) bold

Question 79

Comments must begin with a(n)____.

A) apostrophe
B) comma
C) period
D) double quotation mark

Question 80

The object name ____ refers to the cell from which a custom function is being run.

A) ThisWorkbook
B) ThisCell
C) ActiveCell
D) FunctionCell