1. What is a macro in Excel?
(A) A type of chart
(B) A recorded sequence of steps to automate tasks
(C) A formula for calculations
(D) A cell formatting tool
2. Which language is primarily used to write macros in Excel?
(A) SQL
(B) JavaScript
(C) VBA (Visual Basic for Applications)
(D) HTML
3. Where is the “Record Macro” option located in Excel?
(A) Insert Tab
(B) View Tab → Macros group
(C) Review Tab
(D) Page Layout Tab
4. Which file extension supports saving macros in Excel?
(A) xlsx
(B) docx
(C) csv
(D) xlsm
5. The shortcut key to open the VBA editor is:
(A) Alt + F11
(B) Alt + F8
(C) Ctrl + F1
(D) Shift + F12
6. The Macro dialog box in Excel can be opened by pressing:
(A) Alt + F11
(B) Ctrl + Shift + M
(C) Ctrl + M
(D) Alt + F8
7. Which tab in Excel must be enabled to access advanced macro tools?
(A) Data Tab
(B) Developer Tab
(C) Review Tab
(D) Insert Tab
8. What does the “Use Relative References” option in macros do?
(A) Ensures cell references are fixed
(B) Protects macros with a password
(C) Allows macros to work with different cells dynamically
(D) Hides formulas from users
9. Macros can be stored in which of the following?
(A) Personal Macro Workbook
(B) Templates
(C) Specific Workbooks
(D) All of the above
10. Which of the following is NOT true about macros?
(A) They always damage original data
(B) They can be assigned to buttons or shortcuts
(C) They are written in VBA
(D) They can automate repetitive tasks