Click the button you would use to finish recording the macro.
|
Click a button.
|
0101011,(320,160,23,22)
|
|
That's it.
|
0101012,(319,184,28,23)
|
You haven't clicked the correct button. Try again.
|
In fact, it's the ^UStop Recording^u button.
|
The correct button is now indicated.
@@QUES 010102 SXY Q,302,458,328,398
The macro named Centurion was recorded with relative references. Recording began in cell A1, and cell A2 was selected before the address was typed in.
If you select cell B3 before running the macro Centurion, where do you think the address will be inserted?
|
Choose an option.
|
Cell A1
Cell A2
Cell B3
Cell B4
|
|
4
|
That's right.
|
That's not it. The correct option is now highlighted.
|
The correct option is now highlighted.
@@QUES 010103 GD1 T,33,364,288,233
Click the button that you think enables you to change the description of the macro, or the shortcut key assigned to it.
|
Click a button.
|
0101031,(343,334,90,28)
|
|
That's it.
|
0101032,(151,334,91,192)
|
You haven't clicked the correct button. Try again.
|
In fact, it's the ^UOptions^u button.
|
The correct button is now indicated.
@@QUES 010401 GD1 T,28,225,290,199
Click the button that you think enables you to make changes to the selected macro.
|
Click a button.
|
0104011,(247,335,89,33)
|
|
That's it.
|
0104012,(153,335,89,95),0104013,(280,335,90,94)
|
You haven't clicked the correct button. Try again.
|
In fact, it's the ^UEdit^u button.
|
The correct button is now indicated.
@@QUES 010101t T/F Q,151,391,333,304
If you make mistakes and corrections while recording a macro, only the correct are recorded in the macro.
|
2
|
10
|
Correct.
|
Incorrect. In fact, all the steps, including any mistakes and corrections, are recorded in the macro. The statement is false.
@@QUES 010102t SXY Q,185,406,250,350
Which menu provides the ^UMacro - Record New Macro^u option?
|
Choose an option.
|
^UEdit^u
^UInsert^u
^UData^u
^UTools^u
^UFormat^u
|
4
|
20
|
Correct.
|
Incorrect. The correct option is now highlighted.
@@QUES 010103t Y/N Q,157,370,303,280
Is it true that a number cannot be used as the first character in a macro name?
|
1
|
10
|
Correct.
|
Incorrect. The answer is Yes.
@@QUES 010104t MXY Q,175,443,275,415
Which of the following are allowed as characters (other than the first character) in a macro name?
|
Choose each appropriate item.
|
Letters
Spaces
Symbols
Underscores
Hyphens
Numbers
|
1,4,6
|
30
|
Correct.
|
5 per correct decision
|
Partly right. The correct options are now highlighted.
|
You have not made any correct choices. The correct options are now highlighted.
@@QUES 010105t SXY Q,0,0,350,350
Where should you store a macro if you wish all workbooks to have easy access to it?
|
Choose an option.
|
The current workbook
A new workbook
Your Personal Macro Workbook
|
3
|
15
|
Correct.
|
Incorrect. The correct option is now highlighted.
@@QUES 010106t T/F Q,145,414,340,329
You can record a macro with a mixture of relative and absolute references by clicking the ^URelative Reference^u button during the recording of the macro.
|
1
|
10
|
Correct.
|
Incorrect. The statement is true.
@@QUES 010107t MXY Q,145,429,350,382
Which of the following menu options or key combinations will open the Macro dialog box?
|
Choose each appropriate item.
|
^UShift+F8^u
^UTools - Macros^u
^UTools - Macro - Macros^u
^UTools - Run Macro^u
^UAlt+F8^u
^UCtrl+F8^u
|
3,5
|
30
|
Correct.
|
5 per correct decision
|
Partly right. The correct options are now highlighted.
|
You have not made any correct choices. The correct options are now highlighted.
@@QUES 010401t T/F Q,160,393,323,281
You can edit macros in Excel 97 without using the Visual Basic Editor.
|
2
|
10
|
Correct.
|
Incorrect. You can only edit macros in Excel 97 by using the VB Editor. The statement is false.
@@QUES 010402t SXY Q,145,429,350,383
Which key combination allows you to toggle between Excel and the VB Editor?
