Site MapHelpFeedbackLesson 21 - Working with Macros
Lesson 21 - Working with Macros
(See related pages)

1
What would the code .Name="Calibri" do in a macro?
A)Display the Font dialog box
B)Set the font to Calibri
C)Set the font from Calibri to the next one in the list
D)Display a font list with Calibri selected
2
Which of these keyboard shortcuts should probably not be used for a macro?
A)[Ctrl]+[Q]
B)[Ctrl]+[Shift]+[Q]
C)[Ctrl]+[S]
D)[Ctrl]+[Shift]+[S]
3
What does the acronym VBA represent?
A)Visual Basic for All
B)Visual Basic for Applications
C)Visual Basic Analysis
D)Virtual Basic for Applications
4
Which of these statements about 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.
5
If Excel disables and notifies you about a macro, how can you enable the macro?
A)Click the option on the View tab.
B)Click the Macros button on the Developer tab.
C)Click the option in the security message panel.
D)Close and reopen the workbook exclusively.
6
What dialog box opens after you draw a button control?
A)Assign Button
B)Assign Macro
C)Insert Macro
D)Insert Code
7
Which line in this macro positions the insertion point?

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0073519197/537089/21_07.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (25.0K)</a>
A)Line 2
B)Line 4
C)Line 6
D)Line 8
8
On which command tab is the Macros button located?
A)Home
B)Insert
C)View
D)Review
9
What is a button?
A)A sequence of commands and/or keystrokes when clicked
B)A form control that performs a task when clicked
C)A property setting in the macro code
D)A worksheet object that calculates a result when clicked
10
How many lines in this macro are comments?

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0073519197/537089/21_10.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (19.0K)</a>
A)2
B)4
C)6
D)8







PASOnline Learning Center

Home > Excel > Lesson 21 Quiz