Recall & Review
beginner
What is a macro in Excel?
A macro is a recorded set of actions or commands in Excel that you can run again to automate repetitive tasks.
Click to reveal answer
beginner
How do you start recording a macro in Excel?
Go to the View tab, click on Macros, then choose Record Macro to start recording your actions.
Click to reveal answer
beginner
What should you do before recording a macro?
Plan the steps you want to automate and make sure you perform them exactly as you want them repeated.
Click to reveal answer
beginner
How do you stop recording a macro?
Click on the Stop Recording button on the status bar or go to View > Macros > Stop Recording.
Click to reveal answer
intermediate
Why use absolute references when recording macros?
Absolute references make sure the macro always works on the exact same cells you recorded, not relative to where you start.
Click to reveal answer
What does recording a macro in Excel do?
✗ Incorrect
Recording a macro saves your actions so you can repeat them automatically.
Where do you find the option to record a macro in Excel?
✗ Incorrect
The Record Macro option is under the View tab in the Macros group.
What happens if you forget to stop recording a macro?
✗ Incorrect
Excel will continue recording every action until you stop it.
Which reference type makes a macro always use the same cells?
✗ Incorrect
Absolute references lock the macro to specific cells.
What is a good practice before recording a macro?
✗ Incorrect
Planning helps you record the exact steps you want to automate.
Explain how to record and stop a macro in Excel.
Think about the buttons you click to start and stop.
You got /5 concepts.
Describe the difference between absolute and relative references when recording macros.
Consider how the macro knows which cells to use.
You got /3 concepts.