Electronic Spreadsheet Advanced Class 10 Information Technology
Session 3: Sharing Worksheets Data
Important Questions Answer
1. What is the purpose of a shared drive?
Answer: The main purpose of a shared drive is to store common files for everyone to use.
2. Why did this message appear when you open a shared file?
“The document [file name] is locked for editing by another user. To open a read-only copy of this document, click“!!
Answer: This message appears because someone else already has the file open.
3. What do you mean by “read-only copy of this document”?
Answer: It means a read-only copy of this document is going to open, in which you can perform only reading, you can’t add, modify or delete any content.
4. What are the advantages of keeping files on a shared drive?
Answer: Advantages are –
- Multiple people working on a file at the same time.
- Speed up data entry.
- Make things easier for collaboration purposes.
5. Does spreadsheet software allows to share the workbook?
Answer: Yes
6. Which menu of OpenOffice Calc allows to Share Document?
Answer: Tools Menu
7. Write the steps to Share Document in OpenOffice Calc.
Answer: To Share Document to activate the collaboration features for this worksheet, follow these steps: –
- Choose Tools > Share Document, A dialog opens where you can choose to enable or disable sharing.
- To enable sharing, select the box at the top of the dialog, and then click OK.
- A message appears stating that you must save the worksheet to activate shared mode.
- Click Yes to continue.
The word (shared) is then shown on the title bar after the worksheet’s title.
8. Write the steps to unshare Document in OpenOffice Calc.
Answer: To Unshare Document to activate the collaboration features for this worksheet, follow these steps: –
- Choose Tools > Share Document, A dialog opens where you can choose to enable or disable sharing.
- To disable sharing, Unselect the box at the top of the dialog, and then click OK.
OR
If you want to use a shared worksheet in unshared mode, you need to save the shared worksheet using another name or path. This creates a copy of the spreadsheet that is not shared.
