Test Yourself

 

1. Which of the following is true about Macros?

(Select all correct answers)
a. Macros record actions as you complete a task
b. The user must specify the start and stop to a macro recording
c. Macros will record mistakes
Tip: Advanced Excel, page 248, 252, 253

2. Which Ribbon has the command for Macros?
a. Home
b. Review
c. Developer
d. Tools
Tip: Advanced Excel, 250

3. Office 2010 allows users to do what with Macros?

(Select all correct answers)
a. Add macros to the Ribbon
b. Create a new group to put a user created macro into
c. Use a custom icon for a user created macro
Tip: Advanced Excel, page 263, 264, 265

4. Which of the following is true about Macro Security?
a. Macros are disabled by default because they are a security risk
b. Macros can be permanently enabled in a spreadsheet
c. Macros can be temporarily enabled in a spreadsheet for only the current session
d. The settings for Macros are found in the Trust Center
Tip: Advanced Excel, page 271, 272, 274

5. Which of the following can be customized in Excel 2010? (Select all correct answers)
a. Ribbons
b. Quick Access Toolbar
c. Document Properties
Tip: Advanced Excel, page 268