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
   170   171   172   173   174   175   176   177   178   179   180