Back to lesson
1. Where are the commands for recording and playing macros located?
In a hidden window that can only be access with a password.
On the Developer tab.
On the Excel status bar (at the bottom of the Excel window).
2. Suppose you begin recording a macro and make a mistake. What are the implications?
You need to stop recording the macro immediately and try it again.
The mistake is recorded in the macro and will be played back each time you run the macro.
You need to click Undo to back up one step and remove the mistake.
3. Which types of situation are most suited to recording an Excel macro?
Where the data-processing steps are repeated relatively infrequently but the steps are identical every time the macro runs.
Where changes in the data affect the outcome of how the macro runs.
Where the data-processing steps are repeated frequently and are identical every time the macro runs.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement