Page 176 - IT_V1.0_Class10
P. 176
5. What does sorting data in a spreadsheet using a macro help with?
i. Reorganising data in a particular order ii. Removing duplicates from the data
iii. Highlighting cells with certain values iv. Changing the font style of the data
B. Fill in the blanks.
1. The only special character allowed in a macro name is ..............................
2. Each macro starts with the keyword ............................. and ends with the keyword End Sub.
3. The actions recorded by macro are recorded as instructions in a programming language called ..............................
4. Arguments passed to a macro can be passed by ..............................
5. A ............................. is a set of instructions to automate repetitive tasks.
21 st
Century #Critical Thinking
C. Assertion and reasoning question. Skills
The following question consists of two statements – Assertion (A) and Reason (R). Answer the question by
selecting the appropriate option given below:
i. Both A and R are true and R is the correct explanation of A.
ii. Both A and R are true but R is not the correct explanation of A.
iii. A is true but R is false.
iv. A is false but R is true.
Assertion (A): Macros help in automating repetitive tasks in spreadsheets.
Reason (R): Macros are created by recording actions or writing custom scripts.
21 st
Century #Critical Thinking
D. Statement-based question. Skills
In the following question, two statements are given. Statement 1 and Statement 2. Examine the statements
and mark the correct option:
i. Statement 1 is true , Statement 2 is true
ii. Statement 1 is false , Statement 2 is false
iii. Statement 1 is true , Statement 2 is false
iv. Statement 1 is false , Statement 2 is true
Statement 1: Macros can only be used in LibreOffice Calc and cannot be exported to other spreadsheet software.
Statement 2: Macros are stored within the spreadsheet file and can be accessed by any user opening the file.
Section B (Subjective Type Questions)
A. Answer the following questions:
1. Write the steps to create a macro that works as a function and displays ‘Hello World‘ when executed.
2. What are the key points to consider when organising macros in Calc to ensure efficiency and ease of use?
3. Explain the process of recording a macro using the Macro Recorder.
4. Describe the steps to view a stored macro in LibreOffice Calc.
5. Distinguish between predefined functions in Calc and macros as functions.
21 st
Century #Critical Thinking
B. Application-based question. Skills
Shweta is frequently entering data into a spreadsheet, and she wants to simplify this process by creating a custom function
to calculate the sum of certain cells. How can she accomplish this using Macros?
174 Information Technology Play (Ver 1.0)-X

