Exam 20: Creating and Using Macros

FIGURE EX 14-1 Based on Figure EX 14-1 above, the macro will apply the ____ format to a selected cell.

Selecting a macro from the Macro dialog box and clicking the ____________________ button will open the macro code in the Microsoft Visual Basic for Applications window.

You can click a button to select it without running the macro assigned to it.

Spaces can be used to separate words in macro names.

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. To take care of the repetitive task of applying the same formats to the headings of all the reports, Lynda can create a ____.

After you have created a macro, you cannot make changes to it.

A(n) ____________________ workbook lets you save the macro in the workbook and then run the macro.

To ____ a macro means to have the macro perform the automated task.

Excel has many types of Form Controls that allow you to create items that would go on a form, such as a check box, scroll bar, and button.

Explain the possible dangers with macros and why it is important to be aware of the macro security levels in Excel.

FIGURE EX 14-1 Based on Figure EX 14-1 above, pressing ____ would run the macro.

A workbook that is saved in Excel is saved with the file extension ____.

When you right-click a button, a(n) ____________________ menu appears.

You can edit macros by working with the code in ____.

To edit button text, you must ____ the button and choose ____.

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. Due to some changes in the information that needs to be entered into the worksheet, Joe realizes that he needs to add another column to the table being created by the macro. To make this change, Joe would need to edit the ____ of the macro.

The code words ____ signal the end of a macro.

The first character of a macro name must be a(n) ____.

A macro is a simple way to automate some of the common, repetitive tasks you perform in Excel.

The ____ tab has options that let you make changes to buttons.