Ch 7 Share and Review Spreadsheet Question Answers
Ch 7 Share and Review Spreadsheet Question Answers
A. Multiple choice questions
Q1. Sharing allows to edit the Spreadsheet by
(a) single user
(b) different users simultaneously
(c) one by one users
(d) one after other users
[showhide type=”links1″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. (b) different users simultaneously [/showhide]
Q2. 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
[showhide type=”links2″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. (a) multiple sheets [/showhide]
Q3. 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
[showhide type=”links3″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. (d) one or other users [/showhide]
Q4. In Calc, the comments are added
(a) automatically
(b) by author
(c) by reviewer
(d) all of above
[showhide type=”links4″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. (d) all of above [/showhide]
Q5. 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
[showhide type=”links5″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. (c) owner [/showhide]
B. State whether the following statements are True or False
1. Spreadsheet cannot be shared to work with more than one user?
[showhide type=”links6″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. Spreadsheet cannot be shared to work with more than one user? False [/showhide]
2. Some of the features becomes unavailable when the spreadsheet is in shared mode.
[showhide type=”links7″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. Some of the features becomes unavailable when the spreadsheet is in shared mode. True [/showhide]
3. You can record changes in the spreadsheet when the spreadsheet is opened in shared mode.
[showhide type=”links8″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. You can record changes in the spreadsheet when the spreadsheet is opened in shared mode. False [/showhide]
4. File menu is used to Record changes for the spreadsheet.
[showhide type=”links9″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. File menu is used to Record changes for the spreadsheet. False [/showhide]
5. You can add a note or suggestion in the spreadsheet using Insert Comment.
[showhide type=”links10″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. You can add a note or suggestion in the spreadsheet using Insert Comment. True [/showhide]
6. Formatting comment can be used to change the font colour of the comment.
[showhide type=”links11″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. Formatting comment can be used to change the font colour of the comment. True [/showhide]
C. Fill in the blanks
1. The title bar of the document shows ______________ along with the filename for the shared mode of the spreadsheet.
[showhide type=”links12″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. The title bar of the document shows shared along with the filename for the shared mode of the spreadsheet. [/showhide]
2. The shared mode spreadsheet allows _____________ users to access and edit the spreadsheet at the same time.
[showhide type=”links13″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. The shared mode spreadsheet allows multiple users to access and edit the spreadsheet at the same time. [/showhide]
3. Recording changes automatically ______________ the shared mode of a spreadsheet.
[showhide type=”links14″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. Recording changes automatically turn-off the shared mode of a spreadsheet. [/showhide]
4. Click on Edit menu, Track Changes and then select ______________ to record the changes in the spreadsheet.
[showhide type=”links15″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. Click on Edit menu, Track Changes and then select record to record the changes in the spreadsheet. [/showhide]
5. The border color of the changed cell will be ________________________.
[showhide type=”links16″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. The border color of the changed cell will be red. [/showhide]
6. ___________________ is used to add notes or suggestions to a cell in a spreadsheet.
[showhide type=”links17″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. Comment is used to add notes or suggestions to a cell in a spreadsheet. [/showhide]
7. The comment box can be formatted just like formatting the _______________
[showhide type=”links18″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. The comment box can be formatted just like formatting the cell contents. [/showhide]
D. Answer the following questions
Q1. Define the terms
(a) Sharing Spreadsheet
(b) Record changes
[showhide type=”links19″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. (a) Sharing Spreadsheet : Sharing a spreadsheet allows multiple users to open the same file for editing at the same time.
(b) Record changes: This feature of LibreOffice Calc provides ways to record the changes made by one or other users in the spreadsheet. [/showhide]
Q2. Write the commands to perform
(a) Sharing Spreadsheet
(b) Record changes
[showhide type=”links20″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. (a) Tools > Share Spreadsheet
(b) Edit > Track Changes > Record [/showhide]
Q3. Which menu is used to perform the functions
(a) Track Changes
(b) Saving Spreadsheet
[showhide type=”links21″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. (a) Edit menu
(b) File menu
[/showhide]
Q4. What do you understand by reviewing the changes in the spreadsheet?
[showhide type=”links22″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. Reviewing changes means to go through all the changes made by the different users and to decide which changes should accept or reject to prepare the final spreadsheet. [/showhide]
Q5. Differentiate between Merging and Comparing Spreadsheet.
[showhide type=”links23″ more_text=”Show Answer” less_text=”Hide Answer”] Ans. When multiple reviewers return edited copies of a spreadsheet. In this case, it may be faster to review all of the changes at once, rather than one review at a time. For this purpose, we can merge documents in Calc.
Sometimes reviewers may not record the changes they make. In this case Calc can find the changes by comparing documents. [/showhide]
Important links of Class X (IT – 402)
Unit 1: Digital Documentation (Advanced) using LibreOffice Writer
Chapter 1. Introduction to Styles – NOTES
Chapter 1. Introduction to Styles – Question Answers
Chapter 2. Working with Images – NOTES
Chapter 2. Working with Images – Question Answers
Chapter 3. Advanced features of Writer – NOTES
Chapter 3. Advanced features of Writer – Question Answers
Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc
Chapter 4. Analyse Data using Scenarios and Goal Seek – NOTES
Chapter 4. Analyse Data using Scenarios and Goal Seek – Question Answers
Chapter 5. Using Macros in Spreadsheet – NOTES
Chapter 5. Using Macros in Spreadsheet – Question Answers
Chapter 6. Linking Spreadsheet Data – NOTES
Chapter 6. Linking Spreadsheet Data – Question Answers
Chapter 7. Share and Review a Spreadsheet – NOTES
Chapter 7. Share and Review a Spreadsheet – Question Answers
UNIT 1: DIGITAL DOCUMENTATION (ADVANCED) – MCQ
UNIT-2: ELECTRONIC SPREADSHEET (ADVANCED) – MCQ
UNIT-3 RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC) – MCQ
Disclaimer : I tried to give you the simple answers of “Ch 7 Share and Review Spreadsheet Question Answers“ , but if you feel that there is/are mistakes in the answers of “Ch 7 Share and Review Spreadsheet Question Answers“ given above, you can directly contact me at csiplearninghub@gmail.com. NCERT Book and Study material available on CBSE Website are used to create above article “Ch 7 Share and Review Spreadsheet Question Answers“
thank you