Search for courses or lessons
Redeem a coupon
Start free trial
Where are the commands for recording and playing macros located?
On the Excel status bar (at the bottom of the Excel window)
In a hidden window that can only be accessed with a password
On the Developer tab
Suppose you begin recording a macro and make a mistake. What are the implications?
You need to click Undo to back up one step and remove the mistake
The mistake is recorded in the macro and will be played back each time you run the macro
You need to stop recording the macro immediately and try it again
Which types of situation are most suited to recording an Excel macro?
Where the data-processing steps are repeated frequently and 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 relatively infrequently but the steps are identical every time the macro runs
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement