What are macros in sheet?CBSE SOLUTIONS-2025-26CLASS-10-PART-Bunit-2 electronic spreadsheet using libreoffice calcchapter- 2 Using macros in Spreadsheet
Section A – Fill in the blanks
1.Sorting means arranging the data in an ascending or ______ order.
Answer: Descending
2.Sort option is available in ______ tab.
Answer: Data
3.The option to ______ in Labour Office Calc allows you to automate actions by capturing your actions step by step.
Answer: Record Macro
4.When passing argument to a macro, the original variable can be modified by the macro if passed by ______.
Answer: ByRef
5.You can use the ______ macro option to automate tasks in Labour Office Calc.
Answer: Run Macro
Section B – True or False
1.Arguments passed by Value means the data is passed to the macro leaving the original data unchanged.
Answer: True
2.To access and edit existing macros, you can navigate to Tools > Macros > Organize Macros in Labour Office Calc.
Answer: True
3.The macros feature in Labour Office Calc is used to arrange data in a specific order based on the values in columns.
Answer: False
4.While writing a macro, the keyword ByRef is used to pass a reference to the original variable allowing the macro to modify its value.
Answer: True
5.A recorded macro can be modified in the Macro Editor after it has been created.
Answer: True
