CBSE 10th class Unit 2: Chapter 4 SHARE AND REVIEW A SPREADSHEET

 

Unit 2: 
Chapter 4

SHARE AND REVIEW A SPREADSHEET

A. Multiple Choice Questions

1. (b) different users simultaneously
2. (a) in a same sheet
3. (d) one or other users
4. (b) by author
5. (c) owner

B. State whether the following statements are True or False

1. False
2. True
3. True
4. False
5. True
6. True

C. Fill in the blanks

1. The title bar of the document shows [Shared] along with the filename for the shared mode of the spreadsheet.
2. The shared mode spreadsheet allows multiple users to access and edit the spreadsheet at the same time.
3. Recording changes automatically tracks the shared mode of a spreadsheet.
4. Click on Edit menu, Track Changes and then select Record Changes to record the changes in the spreadsheet.
5. The border color of the changed cell will be green.
6. Comment is used to add notes or suggestions to a cell in a spreadsheet.
7. The comment box can be formatted just like formatting the cell contents.

D. Answer the following questions

1. Define the terms
• (a) Sharing Spreadsheet: Sharing a spreadsheet allows multiple users to access and edit the same document simultaneously.
• (b) Record Changes: This feature tracks changes made to a spreadsheet, allowing you to review and accept or reject changes.
2. Write the commands to perform
• (a) Sharing Spreadsheet:
• In LibreOffice Calc, go to File -> Share.
• Follow the on-screen instructions to share the spreadsheet with other users.
• (b) Record Changes:
• Go to Tools -> Track Changes -> Record Changes.
3. Which menu is used to perform the functions
• (a) Track Changes: Edit menu
• (b) Saving Spreadsheet: File menu
4. What do you understand by reviewing the changes in the spreadsheet?
• Reviewing changes in a spreadsheet involves examining the modifications made by different users. You can accept or reject changes, add comments, and resolve conflicts.
5. Differentiate between Merging and Comparing Spreadsheets.
• Merging Spreadsheets: This involves combining data from multiple spreadsheets into a single spreadsheet.
• Comparing Spreadsheets: This involves identifying differences between two or more versions of a spreadsheet. You can compare cell values, formulas, and formatting.

Lab Exercise

To enable collaboration and track changes for the class assignment spreadsheet:

1. Enable Track Changes:
• Go to Tools -> Track Changes -> Record Changes.
2. Add comment to show the date on which the assignment has been submitted:
• Right-click on the cell where the assignment is submitted.
• Select Insert Comment.
• Type the date and any other relevant comments.
3. Share the document with the class teacher:
• Go to File -> Share.
• Follow the on-screen instructions to share the spreadsheet with the class teacher.