Excel Unit I Flashcards
Macro
Is a named set of instructions you can create that performs tasks automatically, in an order you specify?
Macro
A special workbook used only for macro storage?
Personal Macro Workbook
A destructive software that can damage your computer files- the default security setting in Excel disables macros from running?
Virus
You can run a macro using the Macros button in the code group of the DEVELOPER tab?
Run
Indicating that the macro is outside the active workbook?
External reference indicator
When you use the Macro Recorder to create a macro, the program instructions, called?
Program code
Program code, are recorded automatically for programming language?
Visual Basic for Applications
Or program code container, attached to the workbook?
Module
A program that lets you display and edit you macro code?
Visual Basic Editor
Which is not a location in which you can choose to store a new macro
The Global Workbook
Which of the following would not be a valid macro name
123PrintIt
A macro enabled workbook has an extension of
Xlsm
You can display the developer tab on the ribbon using the what dialog box
Excel Options
To stop macro recording
Click the stop recording button on the status bar
the easiest way to create a macro is to use Excel’s
Macro Recorder
To create a macro that will automatically run when a workbook is opened, you need to name it
Auto_Open
If you need to make minor adjustments to a macro, Excel allows you to edit the
Macro code
The default excel shortcut key combination for a new macro is
(Ctrl)
Excel automatically designates the personal macro workbook as a
Hidden file
You can create a button for a macro by clicking the
Insert tab
