1. Macro Recordings can be enabled from the ________ option in the menu bar.
(a) Sheet
(b) Data
(c) Tools
(d) Window
✅ Answer: (c) Tools
2. Which of the following is a valid Macro Name?
(a) 1formatword
(b) format word
(c) formatword
(d) Format_word
✅ Answer: (c) formatword
3. Which of the following Libraries contains modules with prerecorded macros and should not be changed?
(a) My Macros
(b) LibreOfficeMacros
(c) Untitled1
(d) Test
✅ Answer: (b) LibreOfficeMacros
4. Identify which of the following is a programming language?
(a) Calc
(b) BASIC
(c) Writer
(d) Macro
✅ Answer: (b) BASIC
5. The Module can be executed from the IDE by pressing __________.
(a) F3
(b) F4
(c) F5
(d) F6
✅ Answer: (c) F5
6. Which of the following is the default name of the Macro?
(a) Default
(b) Main
(c) Macro1
(d) Main_Macro
✅ Answer: (b) Main
✅ B. FILL IN THE BLANKS
- Standard library is automatically loaded when the document is opened.
- IDE stands for Integrated Development Environment.
- Macro as a function is capable of accepting arguments and returning a value.
- Macro Organizer allows us to add, delete a module.
- The code of macro begins with Sub followed by the name of the macro and ends with End Sub.
- By default, a macro is saved in the Standard Library of My Macros.
✅ C. TRUE / FALSE
- Macro is a group of instructions executing a single instruction.
✅ False
(A macro executes multiple steps automatically.) - Once created, Macro can be used any number of times.
✅ True - By default, the Macro recording feature is turned on.
✅ False
(It must be enabled manually from Tools → Options.) - It is not possible to stop recording of a Macro.
✅ False
(You stop it with “Stop Recording” button.) - Every Macro should be given a unique name.
✅ True - A macro once created can be edited later.
✅ True
✅ D. ANSWER THE FOLLOWING QUESTIONS
1. What is a Macro? List any two real-life situations where they can be used.
A Macro is a set of recorded steps that allows repeated tasks to be done automatically with one command.
In other words we can say that a macro is a single instruction that executes a set of instructions.
Examples where macros are useful:
✅ When you have to format several sheets in the same style.
✅ When you repeatedly calculate the same type of report, like total sales every day.
2. List the actions that are NOT recorded by a macro.
Macros cannot record the following actions:
❌ Mouse movements
❌ Changing the macro recorder window
❌ Scrolling
❌ Window resizing
❌ Changes in dialog boxes
❌ Switching between applications
❌ Opening or saving a file
3. How is LibreOffice Macros Library different from My Macros?
| LibreOfficeMacros | My Macros |
| Contains system macros. | Contains user-created macros. |
| Should NOT be changed or edited. | User can add, delete or edit macros. |
4. Difference between predefined function in Calc and Macros as a function
| Predefined Function (e.g., SUM) | Macro as a Function |
| Already available in Calc. | Created by user using BASIC language. |
| Limited to existing features. | Can perform customized or complex tasks. |
| Fast and error-free. | Depends on user coding. |
5. Rules to keep in mind while naming a Macro
✅ Should begin with a letter
✅ No spaces allowed
✅ No special symbols except underscore (_)
✅ Should be unique
✅ Cannot start with a number
✅ Should be meaningful and readable
6. Give any one advantage of Macros.
✅ Macros save time by performing repeated tasks automatically.
They also reduce errors because steps are repeated exactly the same way each time.