Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)

1
Macros must be saved in an Excel workbook with this extension:
A).xlsx
B).htm
C).xlsm
D).vba
2
You can check a workbook's macro security settings in:
A)The Backstage view.
B)The Trust Center.
C)The Excel Options window.
D)The Review tab.
3
The security warning bar does not open when you open a workbook with macros if you choose:
A)Open special.
B)Enable all macros.
C)Edit anyway.
D)Trust this document.
4
Instead of typing the code or instructions in a macro program, you:
A)Record it.
B)Insert it.
C)Copy it.
D)Import it.
5
To activate a file in a Personal Macro workbook, you must first:
A)Save it.
B)Record a practice macro.
C)Import your macros.
D)Add a VBA command.
6
The first key in a macro shortcut is always:
A)Shift
B)Ctrl
C)Alt
D)Equals sign (=)
7
As you record a macro, Excel converts your keystrokes into:
A)Formulas.
B)Hyperlinks.
C)VBA code.
D)Shortcuts.
8
A single workbook is called an object while more than one workbooks are called:
A)A collection.
B)A gallery.
C)A coda.
D)A volume.
9
In Visual Basic, each line preceded by an apostrophe and shown in green is a:
A)Macro.
B)Tag.
C)Sub.
D)Comment.
10
You can tell when an Excel template is macro-enabled by looking at its:
A)Extension.
B)Name.
C)Tabs.
D)Layout.
11
To run a macro that was recorded with relative references, you must first:
A)Save it.
B)Select it.
C)Enable it.
D)Activate a cell.
12
When you create a workbook from an Excel macro-enabled template, you must first click:
A)Open Normally.
B)Enable Content.
C)Edit Anyway.
D)Open in Safe Mode.
13
To run a macro with a single click, assign a:
A)Button.
B)Shortcut.
C)Key code.
D)Special character.
14
To open the Visual Basic Editor with a key stroke, press:
A)Alt+0.
B)Windows.
C)Shift+Enter.
D)F11.
15
You can find a button which toggles between Record Macro and Stop Recording in the:
A)Backstage view.
B)Macro editor.
C)Status bar.
D)View menu.





To learn more about the book this website supports, please visit its Information Center.
Copyright (c)2014 McGraw-Hill Education .
Any use is subject to the Terms of Use and Privacy Notice | Report Piracy


Nordell, 1eOnline Learning Center

Home > Excel > Chapter 9 > Ch 9: Multiple Choice Quiz