Page 192 - IT_V1.0_Class10
P. 192
3. By default, every spreadsheet contains ............................. sheet(s).
4. An ............................. hyperlink contains the full address, including the protocol and domain name.
C. State whether the following statements are true or false:
1. Mail hyperlink opens an email message that is pre-addressed to a particular recipient. .............................
2. Hyperlinks cannot move to a certain location within the current spreadsheet. .............................
3. If ‘sales’ sheet has a reference to ‘cost’ sheet, then any changes made to ‘cost’ sheet will be
reflected in the sales sheet as well. .............................
4. It is not possible to link a sheet as a reference in another sheet. .............................
21 st
D. Assertion and reasoning question. Century #Critical Thinking
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): Cell references in LibreOffice Calc can be used to link data across multiple sheets.
Reason (R): Using relative cell references ensures the linked data updates dynamically.
Section B (Subjective Type Questions)
A. Answer the following questions:
1. Differentiate between Relative and Absolute hyperlink. [NCERT]
2. Write the steps to create a hyperlink in a sheet.
3. Write the steps to reference other sheet by using keyboard.
4. Write the steps to edit a hyperlink.
21 st
Century #Critical Thinking
B. Application-based questions. Skills
1. Priya needs to create a hyperlink in her spreadsheet that redirects to an external data source for updated prices.
Which feature will allow her to do this?
2. Rohan is working on a financial report in LibreOffice Calc. He needs to refer to data from the “Q1” sheet in the
“Q2” sheet. He wants the data to update automatically if it changes in the “Q1” sheet. Which feature should Rohan
use to achieve this?
190 Information Technology Play (Ver 1.0)-X

