Page 205 - IT_V1.0_Class10
P. 205
4. ............................. enables users to collaborate and review documents efficiently.
i. Merging data ii. Sharing a spreadsheet
iii. Comparing data iv. Consoidate data
B. State whether the following statements are true or false:
1. File menu is used to Record Changes for the spreadsheet. ............................
2. Comments are once added cannot be deleted from the sheet. ............................
3. Comments appear only when mouse pointer is hovered over the Sheet tab. ............................
4. Formatting comment can be used to change the font colour of the comment. ............................
5. You can add a note or suggestion in the spreadsheet using Insert Comment. ............................
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): The “Record Changes” feature in spreadsheet software allows multiple authors to make changes
to a document, which can be tracked and reviewed by other users before being accepted or rejected.
Reason (R): This feature highlights the edited cells with a colored border, providing details about the changes,
such as the author’s name, date, time, and type of change.
Section B (Subjective Type Questions)
A. Answer the following questions:
1. What is the purpose of sharing a spreadsheet?
2. Write the steps to edit a comment.
3. Write the procedure to merge different version of a spreadsheet.
4. Explain the different situations may occur when saving a shared spreadsheet.
21 st
Century #Critical Thinking
B. Application-based question. Skills
Devesh is working on a shared spreadsheet in LibreOffice Calc with his team. He wants to track all the changes made
by his team members. Which feature in LibreOffice Calc will help Devesh monitor?
Share and Review a Spreadsheet 203

