BYSEX21C13SA
Macros allow you to repeat a series of recorded actions with one click.
True
False
Correct!
Review the section "Introducing Macros."
After recording a macro, you must save the file with a new name and as a macro-enabled workbook.
True
False
Correct!
Review the section "Saving a Workbook Containing Macros."
While recording a macro, you must use the mouse to select a cell or range because the macro can’t record keyboard actions.
True
False
Correct!
Review the section "Recording the Macro Steps."
If you want to create a macro that can be used in other Excel workbooks, be sure to save the macro in the Personal Macro Workbook folder.
True
False
Correct!
Review the section "Storing and Sharing Macros."
What is the default and recommended option for macro security?
Disable all macros without notification.
Disable all macros with notification.
Disable all macros except digitally signed macros.
Enable all macros.
Correct!
Review the section "Changing Macro Security."
To run a macro, you can use any of these EXCEPT:
the macro dialog box
the assigned keyboard shortcut
the status bar
the assigned button
Correct!
Review the section "Running and Assigning a Macro."
Cheryl recorded several macros and wants to be able to quickly run them without using the Ribbon. What should she do?
Create buttons and assign the macros to them.
Enable all macros so they are available everywhere.
Save the file as a macro-enabled workbook.
Add the macros to the status bar.
Correct!
Review the section "Running and Assigning a Macro."
You created a macro and set its keyboard shortcut to [Ctrl]+[I]. Which statement is true?
The macro is modified to include the default action for the shortcut (applying italics).
The macro shortcut is automatically saved as [Ctrl]+[Shift]+[I].
The macro is not saved because the shortcut is already used to apply italics.
The macro action replaces the default action for the shortcut, which is to apply italics.
Correct!
Review the section "Running and Assigning a Macro."
From the Macro dialog box, you can do all of these except _____ a macro.
run
edit
delete
copy
Correct!
Review the section "Copying Macros Between Workbooks."