Multiple Choice

1. Macros must be saved in an Excel workbook with this extension.
   1. .xlsx
   2. .htlm
   3. .xlsm
   4. .vba
   5. .xltm
2. You can check a workbook’s macro security settings in the:
   1. Backstage view.
   2. Trust Center.
   3. Excel Options window.
   4. Review tab.
   5. Developer tab.
3. The security warning bar does not open when you open a workbook with macros if you choose:
   1. Open special.
   2. Enable Macros.
   3. Edit anyway.
   4. Trust this document.
   5. Disable all macros with notification.
4. Instead of typing the code or instructions to create a macro program, you:
   1. Record it.
   2. Insert it.
   3. Copy it.
   4. Import it.
   5. Script it.
5. The Personal Macro Workbook is a choice in the:
   1. Status bar.
   2. Record Macro dialog box.
   3. Personal group in the Backstage view.
   4. Code group of the Developer tab.
   5. Edit mode.
6. The first key in a macro shortcut is always:
   1. Shift
   2. Ctrl.
   3. Alt
   4. Equals sign (=)
   5. Tab
7. As you record a macro, Excel converts your keystrokes into:
   1. Formulas.
   2. Hyperlinks.
   3. VBA code.
   4. Shortcuts.
   5. Text.
8. A single workbook is called an object while the term for a grouping of similar objects is a:
   1. Coda.
   2. Gallery.
   3. Collection.
   4. Volume.
   5. Set.
9. In Visual Basic, each line preceded by an apostrophe and shown in green is a:
   1. Macro.
   2. Tag.
   3. Sub.
   4. Comment.
   5. Command.
10. You can tell when an Excel template is macro-enabled by looking at its:
    1. Extension.
    2. Name.
    3. Tabs.
    4. Layout.
    5. Ribbon.
11. To run a macro that was recorded with relative references, you must first:
    1. Save it.
    2. Select the first reference.
    3. Enable it.
    4. Select it.
    5. Select the starting cell.
12. When you create a workbook from an Excel macro-enabled template, to use the macro you must first click:
    1. Open Normally.
    2. Enable Content.
    3. Edit Anyway.
    4. Open in Safe Mode.
    5. Use Relative References.
13. To run a macro with a single click, assign a:
    1. User.
    2. Shortcut.
    3. Key code.
    4. Special character.
    5. Button.
14. To open the Visual Basic Editor with a keyboard shortcut, press:
    1. Alt+0.
    2. Windows.
    3. Shift+Enter.
    4. Alt+F11.
    5. CTRL+E.
15. You can find a button which toggles between Record Macro and Stop Recording in the:
    1. Error alert.
    2. Validation setting.
    3. Note.
    4. Input message.
    5. Comment.