Explore BrainMass

Explore BrainMass

    Templates and macros in Excel

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    1. When viewing available templates, all of the following will appear EXCEPT
    templates you have created.
    themes you have created.
    recently-used templates.
    sample templates installed with the software.

    2. A macro button is used for frequently used macros and allows other users of the workbook to use the macro
    True or False

    3. You cannot delete a macro once it has been created and saved
    True or False

    4. There is no need to practice the steps of the macro before recording it
    True or False

    5. Macros should be broad enough to apply to a variety of situations or an action that is performed frequently in the workbook
    True or False

    6. Which of the following is NOT an Excel tool used to improve productivity in developing consistently-formatted workbooks?

    7. Which of the following is NOT a method for starting the Macro Recorder?
    Press CTRL+M to start the Macro Recorder.
    Click the View tab, click Macros, and click Record Macro.
    Click the Developer tab, if visible, and click Record Macro.
    Click the Macro Recording icon on the Status Bar if it has been added to the Status Bar.

    8. Which of the following file formats can NOT store macros?
    Excel Macro-Enabled Workbook (.xlsm)
    Excel Binary Workbook (.xlsb)
    Excel Macro-Enabled Template (.xltm)
    Excel Workbook (.xlsx)

    © BrainMass Inc. brainmass.com November 30, 2021, 6:33 am ad1c9bdddf

    Solution Preview

    1. Themes you have created
    This is clearly irrelevant to templates.

    2. True.

    3. False. It is possible to delete macros in the Macro popup ...

    Solution Summary

    8 Multiple Choice questions with annotated solutions regarding Excel macros.