Page 175 - IT_V1.0_Class10
P. 175
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
Skills
Complete the following activities and tick the circle.
Create a Macro that performs ‘Paste Special’ with Subtract.
Create your own Macro function to return the number 10.
Recap Zone
Macros are a set of stored functions or actions that can be used to automate processes that are repeated
often.
Macro recording refers to the process of recording a sequence of actions or commands to automate
repetitive tasks.
Organising a macro in LibreOffice Calc involves breaking it down into manageable sections, using clear
names, adding comments, handling errors, and testing regularly to ensure it works effectively.
Argument is a way to provide more information to the macro. We can pass arguments to a macro.
Arguments passed by value copy the argument’s value into the function, where changes affect only the
function’s scope and not the calling function, and in Calc macros, arguments are always passed by value
without knowing the referenced cells.
Exercise
Section A (Objective Type Questions)
A. Multiple choice questions.
1. Which of the following is NOT allowed when naming a macro?
i. Starting with a letter ii. Including an underscore (_)
iii. Using spaces iv. Uppercase case characters
2. Which option is used to start recording a macro in a spreadsheet?
i. Record Macro option in the Tools menu ii. Paste Special option in the Edit menu
iii. New Module option in the Library iv. Stop Recording option
3. Which of the following is an advantage of a macro?
i. It saves user’s time
ii. It allows to repeat a number of commands in just one click
iii. It allows a user to record numerous formatting commands or formulas on a single sheet
iv. All of these
4. What is the purpose of arguments in a macro function?
i. To store intermediate results of the macro
ii. To provide additional information to the macro for processing
iii. To define the name of the macro
iv. To terminate the execution of the macro
Using Macros in Spreadsheet 173

