Exam 20: Creating and Using Macros

The Assign Macro dialog box allows you to select the macro you want assigned to a button.

To begin recording a macro, click the ____ button in the Code group on the Developer tab.

The Macros button is found in the Code group on the ____ tab.

If the Developer tab is not displayed on the Ribbon, you can add it to the Ribbon.

When a macro is being recorded, all of the selections you make are translated into code .

When you create a macro, Excel records your menu selections and keystrokes.

A ____ simply records a series of steps that you do frequently, such as formatting text.

Macro settings can be viewed by clicking the ____ tab on the Ribbon, and then clicking the Macro Security button in the Code group.

You can save an ordinary Excel workbook as a macro-enabled workbook using the ____ command.

You can use a shortcut key combination to run a macro.

Case EX 14-1 Lynda is responsible for creating a weekly update report in Excel for her boss detailing the performance of the ice cream store where she works. For each report, Lynda has to carry out the same formatting steps for the heading. Lynda wants to protect her computer and data from a potential virus attack. She should check to make sure that the ____ level in Excel is set to Disable all macros with notification or Disable all macros except digitally signed macros.

As a best practice, you should set the security level in Excel to Enable all macros.

The user cannot change the macro security level in Excel.

Visual Basic for Applications is a ____.

The macro name and the shortcut key assigned to the macro is entered in the Macro Settings dialog box.

To select a button with an assigned macro, you left-click the button.

If you want to save a workbook that has a macro, you will need to save it with the ____ file extension in the Save dialog box.

Modifying code is similar to modifying text in a Microsoft Word document.

Case EX 14-2 Joe works as the manager of an auto repair shop. To help him with his work, Joe has created a macro for creating a table with a set number of columns. He needs to regularly create these tables in his worksheets. To make it easier to run the macro, Joe decides to assign the macro to a ____.