Deck 20: Creating and Using Macros

Question 1

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

Answer 1

True

Question 2

The user cannot change the macro security level in Excel.

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

A) switch
B) open
C) display
D) run

Question 5

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.

Question 6

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

Question 7

Visual Basic for Applications is a ____.

A) programming language
B) template
C) virus
D) macro

Question 8

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

A) virus
B) button
C) macro
D) tab

Question 9

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

Question 10

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

A) Start Macro
B) Record Macro
C) New Macro
D) Code Macro

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

A) Home
B) View
C) Review
D) Developer

Question 20

Spaces can be used to separate words in macro names.

Question 21

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

A) .xlsm
B) .xlts
C) .xlsx
D) .xlmn

Question 22

The code word ____ indicates the start of a macro.

A) Start
B) Begin
C) New
D) Sub

Question 23

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

A) right-click, Edit Text
B) right-click, Format Text
C) left-click, Edit Text
D) left-click, Format Text

Question 24

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.

A) .xlsm
B) .xlts
C) .xlsx
D) .xlmn

Question 25

A ____ is called a control because it controls the actions that are assigned to it.

A) button
B) scroll bar
C) tab
D) check box

Question 26

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 ____.

A) scroll bar
B) window
C) button
D) check box

Question 27

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 ____.

A) button
B) table
C) macro
D) virus

Question 28

The code words ____ signal the end of a macro.

A) End Sub
B) Close Macro
C) Stop Macro
D) End Macro

Question 29

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.

Question 30

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

A) Page Layout
B) Developer
C) View
D) Format

Question 31

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

A) Home
B) Developer
C) Data
D) View

Question 32

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.

A) surface
B) code
C) button
D) format

Question 33

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

A) center
B) left-aligned
C) bold
D) right-aligned

Question 34

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

A) Ctrl+q
B) * : Ctrl+q
C) Sub
D) End Sub

Question 35

The code word ____ appears at the top of a macro.

A) Start
B) Sub
C) New
D) Macro

Question 36

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

A) Macro
B) Save As
C) Change
D) Enable

Question 37

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

A) HTTP
B) HTML
C) JPS
D) VBA

Question 38

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.

A) button notification
B) macro security
C) button opening
D) virus security

Question 39

The ____ dialog box is used to change the color of the text of a button.

A) Format Control
B) Button Format
C) Button Text
D) Text Color

Question 40

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

A) lower-case letter
B) upper-case letter
C) letter
D) number

Question 42

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

Question 43

When you open a workbook with macros, a security warning appears on the ____________________.

Question 44

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

Question 45

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

Question 46

You create a button by first choosing the ____________________ form control and then drawing the button where you want it to appear in the worksheet.