Font size
WorksheetsMacros in libre office calc
Total questions: 40
Worksheet time: 21mins
·Which of the following is an valid Macro Name?
1formatword
format word
format*word
Format_word
What is the primary purpose of using Macros in software applications?
to automate repetitive tasks
to create complex graphics
to enhance security features
to manage user permissions
How can Macros improve efficiency in data processing?
By slowing down processing time
By increasing the size of data
By reducing manual input errors
By complicating the workflow
Macro Recordings can be enabled from the ________ option in the menu bar.
Sheet
Data
Tools
Window
Identify which of the following is a programming Language?
Calc
BASIC
Writer
Macro.
The Module can be executed from the IDE by pressing _________________. (a) (b) (c) (d)
F3
F4
F5
F6
Which of the following is the default name of the Macro _______________.
Default
Main
Macro1
Macro
Once created, Macro can be used any number of times.
True
False
Macro is a group of instructions executing a single instruction.
False
True
By default, the Macro recording feature is turned on.
True
False
It is not possible to stop recording of a Macro
True
False
A macro once created can be edited later.
True
False
IDE stands for (a) .
Which menu path enables macro recording?
Tools > Macro > Enable
Tools > Options > LibreOffice > Advanced
File > Options > LibreOffice > Advanced
Edit > Options > Enable Macro
Actions not recorded by a macro include:
Typing
Opening windows
Keystrokes
Formatting
What is the shortcut to stop recording a macro?
Alt + S
Click "Stop Recording"
Ctrl + Z
Right-click > Stop Recording
In which applications does the macro recorder work?
Calc and Writer
Calc and Impress
Base and Draw
Writer and Base
Where are macros saved by default?
Untitled Library
Standard Library in Module1
My Library in Module2
System Folder
What is the default name for a new macro?
Main
FormatHeading
Module1
MyMacros
Which menu option is used to run a macro?
File > Run Macro
Tools > Macros > Run Macro
Edit > Macros > Execute Macro
Tools > Execute > Macro
What does a macro consist of?
A collection of formulas
A single command
A sequence of commands or keystrokes
A set of formatting styles
Which of the following is NOT a benefit of using macros?
Standardization of tasks
Increased complexity of tasks
Reduction of manual errors
Time-saving on repetitive tasks
In the context of macros, what does 'recording' refer to?
Saving a document
Capturing a sequence of actions
Formatting cells
Creating a new spreadsheet
What does the term 'keystrokes' refer to in the context of macros?
Keyboard inputs
Screen touches
Mouse clicks
Voice commands
What is the significance of the 'Optional Features' section in the macro settings?
It provides help documentation
It shows available templates
It lists all installed macros
It allows customization of macro settings
Which actions are NOT recorded by the macro recorder?
Keyboard selections
Switching of windows
Applying formulas
Applying formatting features
What happens if all macros are given the same name?
They will be ignored
They will run simultaneously
They will be saved in different libraries
They will overwrite the previous macro
What is a Library in the context of macros?
A collection of users
A collection of spreadsheets
A collection of modules
A collection of data entries
What is one of the rules for naming a Macro, Module, or Library?
It must contain numbers
It should begin with a letter
It can contain spaces
It must end with a number
What does the 'My Macros' section contain?
Pre-recorded macros from LibreOffice
Macros that users write or add
Macros that cannot be modified
Macros for formatting only
Which library contains pre-recorded macros provided by LibreOffice?
My Macros
Untitled1
LibreOffice Macros library
User Macros
Which character is allowed in the name of a Macro, Module, or Library?
Underscore
Space
Dash
Period
What does the code of a macro begin with?
Begin
Start
Sub
Function
What is the first step to organize a macro in LibreOffice?
Click on Tools > Macros > Organize Macros > LibreOffice Basic
Create a new library
Open the Basic Macro Organizer dialog
Select a module
Which option do you select to create a new library for macros?
Tools > Macros > New Library
Library > New
File > New > Library
Edit > Library >Create
What is the purpose of creating a library in LibreOffice?
To run calculations
To store macros
To edit documents
To format text
What does the command 'Print' do in the context of the macro?
Prints the document
Saves the macro
Displays text in a dialog box
Closes the program
What does the term 'Sub Main' refer to in the macro code?
A variable
A module
A command
A function
What is the role of the IDE in relation to macros?
To run and edit macros
To format cells
To create spreadsheets
To view data
What is the first keyword used to define a function in LibreOffice Basic?
Define
Function
Sub
Macro
