Excel

Question 1

To enter and edit VBA code, you work in the?

Answer 1

Visual Basic Editor

Question 2

In VBA macro code, a sequence of VBA statements is called a?

Answer 2

Procedure

Question 3

The first line of a procedure, called the?

Answer 3

Procedure header

Question 4

Are variables used by other procedures that the main procedure might run.

Answer 4

Arguments

Question 5

Items that appear in blue are?

Answer 5

Keywords

Question 6

The keyword sub in the procedure header indicates that this is a?

Answer 6

Sub procedure

Question 7

Is the Visual Basic equivalent of a worksheet.

Answer 7

Module

Question 8

Is the collection of all procedures in a workbook.

Answer 8

Project

Question 9

Displays a list of all open projects?

Answer 9

Project Explorer

Question 10

Displays the selected module’s procedures?

Answer 10

Code Window

Question 11

Displays a list of characteristics associated with the module?

Answer 11

Properties Window

Question 12

Every Excel element, including a range, is considered an?

Answer 12

Object

Question 13

Represents a cell or a range of cells.

Answer 13

Range object

Question 14

Notice that several times in the procedure, a line of code?

Answer 14

Statement

Question 15

Is an attribute of an object that defines one of the object’s characteristics or an aspect of it’s behavior?

Answer 15

Property

Question 16

The last line, End sub, indicates the end of the sub procedure and is also referred to as the?

Answer 16

Procedure footer

Question 17

When writing Visual Basic code for excel, you must follow the formatting rules, of VBA programming language?

Answer 17

Syntax

Question 18

A list of words that can be used in the macro statement and match what you type.

Answer 18

AutoComplete

Question 19

One way of adding this type of conditional statement in visual basic is to use an?

Answer 19

If Then Else Statement

Question 20

Is a predefined procedure that returns (creates and displays) a value; in this case the value returned is the information the user enters.

Answer 20

Function

Question 21

The first part of the code, Dim left footer text as string or defines, left footer text as a text string variable?

Answer 21

Declares

Question 22

Is a location in memory in which you can temporarily store on item of information.

Answer 22

Variable

Question 23

When a macro procedure does not run properly, it can be due to an error, referred to as a?

Answer 23

Bug

Question 24

when you locate the error, you can then correct, or?

Answer 24

Debug

Question 25

The resulting procedure, which process (or runs) multiple procedures in sequence, is referred to as the?

Answer 25

Main procedure

Question 26

To create a main procedure, you type a blank for each procedure you want to run

Answer 26

Call statement