Chapter 1

Question 1

standard VBA line continuation character sequence

Answer 1

a space followed by an underscore character

Question 2

location to set macro security properties

Answer 2

File->Options->Trust Center->Trust Center Settings

Question 3

Recommended security setting for macros

Answer 3

Disable all macros with notification

Question 4

other locations of VBA

Answer 4

other members of Microsoft Office

Question 5

VBA is these two types of languages

Answer 5

programming language

macro language

Question 6

macro word origin

Answer 6

Greek makros

means large

Question 7

You can customize your ____ _____ _____ with your own buttons that execute the macros you write.

Answer 7

Quick Access toolbar

Question 8

Buttons for executing macros can also be added to this

Answer 8

the Ribbon

Question 9

VBA can be used to create custom versions of these

Answer 9

worksheet functions

Question 10

You can use VBA to develop your own special-purpose ___-____.

Answer 10

add-ins

Question 11

VBA consists of these two types of procedures

Answer 11

Sub procedures

Function procedures

Question 12

Function procedures return this

Answer 12

a single value

Example:

Function AddTwo (arg1,arg2)

AddTwo=arg1+arg2

End Function

Question 13

VBA manipulates these

Answer 13

objects

Question 14

Objects can act as ____ for other objects.

Answer 14

containers

Question 15

object model refers to

Answer 15

the arrangement of objects

Question 16

Objects of the same type form this

Answer 16

a collection

Question 17

Collections are themselves _____.

Answer 17

objects

Question 18

You refer to an object by specifying its position in the object hierarchy with this

Answer 18

a dot separator

Question 19

Objects have these which you can use VBA code to change or determine.

Answer 19

properties

Question 20

How do you refer to an object’s property

Answer 20

Combine the object name with the property name separated by a dot.

Example:

Worksheets(“Sheet1”).Range(“A1”).Value

Question 21

Use these in VBA code to store values, text and property settings

Answer 21

variables

Example:

Interest = Worksheets(“Sheet1”).Range(“A1”).Value

Question 22

A ____ is an action Excel performs with an object.

Answer 22

method

Question 23

Specify a method by doing this

Answer 23

Combining the object name with the method, separated by a dot

Example:

Worksheets(“Sheet1”).Range(“A1”).ClearContents

Question 24

VBA includes all of these three constructs of modern programming languages

Answer 24

variables

arrays

looping

Question 25

First version of Excel and when it appeared

Answer 25

Excel 2

1987

Question 26

First Excel version to use VBA, and year of release

Answer 26

Excel 5

1994

Question 27

First version of Excel to support a million rows

Answer 27

Excel 2007

Question 28

Excel 2016 online and mobile device versions do not support this

Answer 28

VBA