Quiz › Macros & VBA › Macros and VBA
Macros and VBA: Excel Quiz
5 quick questions. Pick an answer to see if you are right.
- You do the same 10 steps every morning. Which Excel feature repeats them with one click?
- A. A chart
- B. A PivotTable
- C. A filter
- D. A macro
Show the answer
D — A macro. Record the steps once as a macro. Then run it any time. - You record a macro and save the file as .xlsx. What happens to the macro?
- A. It is kept
- B. It runs by itself
- C. It becomes a formula
- D. It is removed
Show the answer
D — It is removed. Only .xlsm files keep macros. - You press Alt + F8. What opens?
- A. The list of macros
- B. Print
- C. The VBA editor
- D. Save As
Show the answer
A — The list of macros. Alt + F8 lists your macros so you can run one. - You press Alt + F11. What opens?
- A. Format Cells
- B. The VBA editor
- C. The list of macros
- D. Find
Show the answer
B — The VBA editor. Alt + F11 opens the editor where the macro code lives. - What does this line of VBA do?
Range("A1").Value = 10- A. Reads cell A1
- B. Selects 10 cells
- C. Deletes cell A1
- D. Puts 10 in cell A1
Show the answer
D — Puts 10 in cell A1. It sets the value of cell A1 to 10.
Want to learn this? Read the Macros & VBA lessons →
← More Macros & VBA topics · All quiz categories
