Site MapHelpFeedbackLesson 16 Quiz
Lesson 16 Quiz
(See related pages)

1
Which of the following statements about opening an Excel workbook with a macro is true?
A)The workbook opens in Protected View and macros are prohibited.
B)The Ribbon is collapsed, and no commands are available.
C)A security message panel opens and macros are disabled.
D)There is no Close button for the workbook.
2
Which of the following statements best describes an Excel macro?
A)It is a series of command buttons that run as a file is opened.
B)It is a sequence of commands and keystrokes that perform a task.
C)It is a sequence of labels coded in Visual Basic.
D)It is a series of formatting tasks performed automatically.
3
Which of the following file names represents the Personal Macro Workbook for Excel?
A)Personal.xlst
B)Personal.xlsm
C)Personal.xlsb
D)Personal.xlsx
4
Which of the following statements describes a button form control in an Excel worksheet?
A)A hidden sequence of commands and/or keystrokes
B)An object that performs a task or command when clicked
C)A property setting in the macro code window
D)A worksheet object that calculates a result when clicked
5
In an Excel workbook, which of the following keyboard commands opens the Visual Basic Editor?
A)[Alt]+[F3]
B)[Alt]+[F7]
C)[Alt]+[F11]
D)[Alt]+[F12]
6
Which of the following statements indicates why you should not use [Ctrl]+[P] as an Excel macro keyboard shortcut?
A)It would override using an uppercase "P" in a label.
B)It would override the Print command shortcut.
C)It would only print the macro.
D)It would open a dialog box first for confirmation.
7
Which of the following statements specifies a reason for monitoring macro security settings for Excel workbooks?
A)Macro-enabled workbooks have longer file names and extensions.
B)Macro-enabled workbooks might contain viruses.
C)Macro-enabled workbooks might contain button form controls.
D)Macro-enabled workbooks have excessive opening times.
8
Which of the following attributes applies to the Personal Macro Workbook?
A)It is not macro-enabled.
B)It is hidden.
C)It has an xlsm file name extension.
D)It is stored in the Documents folder.
9
If you plan to develop and write sophisticated Excel macros, which of the following programming languages is most likely to help?
A)C++
B)Pascal
C)Structured Reference
D)Visual Basic
10
Which of the following statements about Excel macros is false?
A)A macro is a sequence of commands.
B)A macro is stored in a macro-enabled workbook.
C)A macro can contain viruses or malicious code.
D)A macro name can include alphabetic and special characters.







Hinkle, Microsoft2010 CompleteOnline Learning Center

Home > Excel > Lesson 16 Quiz