Explore BrainMass

Templates and macros in Excel

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)

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.