Excel Unit I

Question 1

Is a named set of instructions you can create that performs tasks automatically, in an order you specify?

Answer 1

Macro

Question 2

A special workbook used only for macro storage?

Answer 2

Personal Macro Workbook

Question 3

A destructive software that can damage your computer files- the default security setting in Excel disables macros from running?

Answer 3

Virus

Question 4

You can run a macro using the Macros button in the code group of the DEVELOPER tab?

Answer 4

Run

Question 5

Indicating that the macro is outside the active workbook?

Answer 5

External reference indicator

Question 6

When you use the Macro Recorder to create a macro, the program instructions, called?

Answer 6

Program code

Question 7

Program code, are recorded automatically for programming language?

Answer 7

Visual Basic for Applications

Question 8

Or program code container, attached to the workbook?

Answer 8

Module

Question 9

A program that lets you display and edit you macro code?

Answer 9

Visual Basic Editor

Question 10

Which is not a location in which you can choose to store a new macro

Answer 10

The Global Workbook

Question 11

Which of the following would not be a valid macro name

Answer 11

123PrintIt

Question 12

A macro enabled workbook has an extension of

Answer 12

Xlsm

Question 13

You can display the developer tab on the ribbon using the what dialog box

Answer 13

Excel Options

Question 14

To stop macro recording

Answer 14

Click the stop recording button on the status bar

Question 15

the easiest way to create a macro is to use Excel’s

Answer 15

Macro Recorder

Question 16

To create a macro that will automatically run when a workbook is opened, you need to name it

Answer 16

Auto_Open

Question 17

If you need to make minor adjustments to a macro, Excel allows you to edit the

Answer 17

Macro code

Question 18

The default excel shortcut key combination for a new macro is

Answer 18

(Ctrl)

Question 19

Excel automatically designates the personal macro workbook as a

Answer 19

Hidden file

Question 20

You can create a button for a macro by clicking the

Answer 20

Insert tab