Automating Reports in Excel Using Macros MCQs

1. What is the main purpose of using Macros in Excel?
(A) To format fonts automatically
(B) To automate repetitive tasks and reports
(C) To insert charts quickly
(D) To create hyperlinks

2. In Excel, Macros are usually written in which programming language?
(A) Java
(B) Python
(C) VBA (Visual Basic for Applications)
(D) C++

3. Where can you find the option to record a Macro in Excel?
(A) Home Tab → Editing Group
(B) View Tab → Window Group
(C) Insert Tab → Symbols Group
(D) Developer Tab → Code Group

4. When recording a Macro, Excel saves the steps as:
(A) Formulas
(B) VBA Code
(C) Templates
(D) Charts

5. If you want a Macro to be available every time you open Excel, you should save it in:
(A) Personal Macro Workbook
(B) Current Worksheet Only
(C) Add-ins Folder
(D) Template File

6. Which shortcut is commonly used to run a Macro after assigning it?
(A) Ctrl + M
(B) Alt + Tab
(C) Ctrl + Shift + [Assigned Key]
(D) Ctrl + Alt + Del

7. To automate monthly sales reports with charts and formatting, which Excel feature is best?
(A) Mail Merge
(B) Macros with VBA
(C) Conditional Formatting
(D) Data Validation

8. Which security feature in Excel prevents potentially harmful macros from running automatically?
(A) Macro Recorder
(B) Compatibility Checker
(C) Protected View for Templates
(D) Trust Center Macro Settings

9. What happens when you assign a Macro to a button in Excel?
(A) Clicking the button runs the Macro automatically
(B) The button changes cell formatting
(C) The button applies conditional formatting
(D) The button enables formulas