A. Multiple Choice Questions (with answers)
1. Sharing allows to edit the spreadsheet by
(a) single user
(b) different users simultaneously
(c) one by one users
(d) one after other users
Answer: (b) different users simultaneously
2. Sharing spreadsheet feature allows to save the changes in
(a) multiple sheets
(b) user’s sheet
(c) in a same sheet
(d) in different sheet
Answer: (a) multiple sheets
3. The Recording Changes feature of LibreOffice Calc provides different ways to record the changes made by __________ in the spreadsheet.
(a) one user
(b) other user
(c) the user
(d) one or other users
Answer: (d) one or other users
4. In Calc, the comments are added
(a) automatically
(b) by author
(c) by reviewer
(d) all of above
Answer: (d) all of above
5. The changes by team members in the spreadsheet can be accepted or rejected by
(a) the team members
(b) any of the user
(c) owner
(d) other users
Answer: (c) owner
B. State True or False (with questions)
1. Spreadsheet cannot be shared to work with more than one user.
Answer: False
2. Some of the features become unavailable when the spreadsheet is in shared mode.
Answer: True
3. You can record changes in the spreadsheet when the spreadsheet is opened in shared mode.
Answer: False
4. File menu is used to Record changes for the spreadsheet.
Answer: False
5. You can add a note or suggestion in the spreadsheet using Insert Comment.
Answer: True
6. Formatting comment can be used to change the font colour of the comment.
Answer: True
C. Fill in the blanks (with answers)
1. The title bar of the document shows __________________ along with the filename for the shared mode of the spreadsheet.
Answer: (shared)
2. The shared mode spreadsheet allows __________ users to access and edit the spreadsheet at the same time.
Answer: multiple
3. Recording changes automatically ____________ the shared mode of a spreadsheet.
Answer: turn-off
4. Click on Edit menu, Track Changes and then select ____________ to record the changes in the spreadsheet.
Answer: Record
5. The border color of the changed cell will be ______________.
Answer: red
6. ____________ is used to add notes or suggestions to a cell in a spreadsheet.
Answer: Comment
7. The comment box can be formatted just like formatting the __________ (cell contents).
Answer: cell contents
D. Answer the following questions (with complete answers)
1. Define the terms:
(a) Sharing Spreadsheet
Sharing a spreadsheet means allowing multiple users to open, edit, and save the same spreadsheet simultaneously.
(b) Record Changes
Record Changes is a feature that tracks and highlights modifications made by users, showing details such as who made the change, the date, and what was changed.
2. Write the commands to perform:
(a) Sharing Spreadsheet
Tools → Share Spreadsheet
(b) Record Changes
Edit → Track Changes → Record
3. Which menu is used to perform the functions:
(a) Track Changes
Answer: Edit menu
(b) Saving Spreadsheet
Answer: File menu
4. What do you understand by reviewing the changes in the spreadsheet?
Reviewing changes means checking all the edits recorded in the spreadsheet and then accepting or rejecting each change to finalize the document.
5. Differentiate between Merging and Comparing Spreadsheet
| Merging Spreadsheet | Comparing Spreadsheet |
| Combines changes from multiple edited copies into a final version. | Shows differences between two versions of a spreadsheet. |
| Used when many users edit copies of the same file. | Used when comparing old and new versions of a file. |
| Produces a single unified file. | Produces a comparison report. |