Unit 2: Electronics Spreadsheet (Advanced) using LibreOffice Calc
Chapter 7. Share and Review a Spreadsheet
Check Your Progress
A. Multiple-choice questions.
Question 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
Question 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
Question 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
Question 4:
In Calc, the comments are added
(a) automatically
(b) by author
(c) by reviewer
(d) all of above
Answer: (d) all of above
Question 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 whether the following statements are True or False.
Question 1:
Spreadsheet cannot be shared to work with more than one user?
Answer: False
Question 2:
Some of the features become unavailable when the spreadsheet is in shared mode.
Answer: True
Question 3:
You can record changes in the spreadsheet when the spreadsheet is opened in shared mode.
Answer: False
Question 4:
File menu is used to Record changes for the spreadsheet.
Answer: False
Question 5:
You can add a note or suggestion in the spreadsheet using Insert Comment.
Answer: False
Question 6:
Formatting comments can be used to change the font colour of the comment.
Answer: True
C. Fill in the blanks.
Question 1:
The title bar of the document shows ______ along with the filename for the shared mode of the spreadsheet.
Answer: shared
Question 2:
The shared mode spreadsheet allows ________ users to access and edit the spreadsheet at the same time.
Answer: many
Question 3:
Recording changes automatically _______ the shared mode of a spreadsheet.
Answer: turn off
Question 4:
Click on Edit menu, Track Changes and then select _________ to record the changes in the spreadsheet.
Answer: record
Question 5:
The border color of the changed cell will be __________.
Answer: red
Question 6:
__________ is used to add notes or suggestions to a cell in a spreadsheet.
Answer: Comment
Question 7:
The comment box can be formatted just like formatting the ________ (cell contents).
Answer: cell contents
D. Answer the following questions.
Question 1:
Define the terms: (a) Sharing Spreadsheet (b) Record changes
Answer:
- (a) Sharing Spreadsheet: Sharing a spreadsheet is just like teamwork to work in collaboration with other users.
- (b) Record Changes: The Record Changes feature of LibreOffice Calc provides different ways to record the changes made by one or other users in the spreadsheet.
While recording the changes, the spreadsheet will turn off its shared feature.
Question 2:
Write the commands to perform: (a) Sharing Spreadsheet (b) Record changes
Answer:
- (a) Commands to perform Sharing Spreadsheet
- Step 1: Open a new spreadsheet and save it with some names.
- Step 2: Select and click on Tools > Share Spreadsheet from the main menu bar. It will open the Share Document Dialog window.
- Step 3: In the Share Document Dialog window, Click on the checkbox “Share this spreadsheet with other users” and
- Step 4: Click on OK button. It will open a Confirmation Dialog window.
- Step 5: In the Confirmation dialog window, click on Yes to activate the shared mode.
- Note: Once the spreadsheet is saved, the name of the spreadsheet in the title bar will display (shared) along with the name of the spreadsheet.
- (b) Commands to perform Record Changes
- Step 1: To enable the Record changes, first disable the shared mode of a spreadsheet.
- Step 2: To disable the shared mode, open the spreadsheet. Select and click on Tools > Share Spreadsheet from main menu bar.
- Step 3: Remove the check mark on the check box, “Share this spreadsheet with other users”, and click on OK button.
- Step 4: It will display the Confirmation dialog window to disable the sharing mode. It will give a warning to disable the shared mode of a spreadsheet. Click Yes to continue.
- Step 5: Now to record track changes, click on Edit > Track Changes > Record.
- Note:
(i) Now Record Track changes is ON. After that, changes made by any user can be recorded and appear in red. Also, the changed cell will display the description if the cursor moves to the changed cell.
(ii) Thus, by looking at the spreadsheet, other users can easily know the changes made in the cell and the changes made by whom.
Question 3:
Which menu is used to perform the functions
(a) Track Changes (b) Saving Spreadsheet
Answer: (a) Edit Menu (b) File Menu
Question 4:
What do you understand by reviewing the changes in the
spreadsheet?
Answer: Reviewing the changes in the spreadsheet means looking and checking all the changes made by team members. In this stage, we can accept changes or reject changes to prepare the final spreadsheet.
Question5:
Differentiate between Merging and Comparing Spreadsheet.
Answer: Merging Spreadsheet vs Comparing Spreadsheet
| Merging Spreadsheet | Comparing Spreadsheet |
| Merging spreadsheets means combining the old version spreadsheet file with the new version or changed version of the spreadsheet file. It is useful, when we have two different versions of the same spreadsheet file, and we want to merge them after reviewing all changes. | Comparing Spreadsheets means comparing the two versions of the same spreadsheet file. It is useful when we want to check how many changes have been done by the team members. |
Lab Exercises. (Do by yourself in Lab)
Anushka and Niyaz have been made the class representative. Anushka has been asked to collect the class assignments for the various subjects. Create a spreadsheet to store the roll number, name of the students and subject names. Perform the following operations so that Niyaz can access the file:
- Enable Track changes
- Add a comment to show the date on which the assignment has been submitted.
- Share the document with the class teacher.
