Lesson 7
Share and Review a Spreadsheet
đText Books PDF
đMCQ Online Exam
đMCQ Answer
đPaid Answer (For Membership User)
đMCQ Online Exam
đMCQ Answer
đPaid Answer (For Membership User)
1. What is the purpose of sharing a spreadsheet? (Spreadsheet āĻļ্āĻŦেā§াā§° āĻā§°াā§° āĻāĻĻ্āĻĻেāĻļ্āϝ āĻি?)
Answer: Sharing a spreadsheet allows multiple users to view, edit, and collaborate on the same file simultaneously.
(Spreadsheet āĻļ্āĻŦেā§াā§° āĻā§°িāϞে āĻŦāĻšুāϤো āĻŦ্āĻ¯ā§ąāĻšাā§°āĻাā§°ীā§ে āĻāĻেāϞāĻে āĻĢাāĻāϞāĻো āĻাāĻ, āϏāĻŽ্āĻĒাāĻĻāύা āĻā§°ি, āϏāĻšāϝোāĻিāϤা āĻā§°িāĻŦ āĻĒাā§°ে।)
2. What is the Review feature in a spreadsheet? (Spreadsheet-āϤ Review āĻŦৈāĻļিāώ্āĻ্āϝāĻো āĻি?)
Answer: The Review feature allows users to track changes, add comments, and compare versions of a spreadsheet.
(Review āĻŦৈāĻļিāώ্āĻ্āϝāĻ āĻŦ্āĻ¯ā§ąāĻšাā§°āĻাā§°ীāĻ āĻĒā§°িā§ąā§°্āϤāύ āĻিāύাāĻ্āϤ āĻā§°া, āĻŽāύ্āϤāĻŦ্āϝ āϝোāĻ āĻā§°া, āĻā§°ু Spreadsheet-ā§° āϏংāϏ্āĻā§°āĻŖ āϤুāϞāύা āĻā§°াā§° āϏুāĻŦিāϧা āĻĻিā§ে।)
3. How can you track changes in a spreadsheet? (Spreadsheet-āϤ āĻĒā§°িā§ąā§°্āϤāύ āĻেāύেāĻৈ āĻিāύাāĻ্āϤ āĻā§°িāĻŦ?)
Answer:
Go to Edit → Track Changes → Record.
It highlights the modifications made by different users.
(Spreadsheet-āϤ Edit → Track Changes → Record āĻ্āϞিāĻ āĻā§°িāϞে āĻĒā§°িā§ąā§°্āϤāύ āĻিāύাāĻ্āϤ āĻšā§।)
4. What is the purpose of the "Add Comment" option? ("Add Comment" āĻŦিāĻāϞ্āĻĒā§° āĻāĻĻ্āĻĻেāĻļ্āϝ āĻি?)
Answer: The "Add Comment" option allows users to provide feedback, ask questions, or explain changes without altering the content.
("Add Comment" āĻŦিāĻāϞ্āĻĒāĻ āĻŦ্āĻ¯ā§ąāĻšাā§°āĻাā§°ীāĻ āĻŽāύ্āϤāĻŦ্āϝ āϝোāĻ āĻā§°ি āĻĒ্ā§°āϤিāĻ্ā§°িā§া āĻĒ্ā§°āĻাāĻļ āĻā§°িāĻŦāϞৈ āĻĻিā§ে।)
5. How can you protect a spreadsheet from unauthorized editing? (Spreadsheet āĻ
āύāύুāĻŽোāĻĻিāϤ āϏāĻŽ্āĻĒাāĻĻāύাā§° āĻĒā§°া āĻেāύেāĻৈ āϏুā§°āĻ্āώিāϤ āĻā§°িāĻŦ?)
Answer:
Go to Tools → Protect Sheet.
Set a password to prevent unauthorized editing.
(Spreadsheet-āϤ Tools → Protect Sheet āϞৈ āĻৈ Password āĻĻিā§āĻ।)
6. What is the difference between "Share" and "Protect" in a spreadsheet? (Spreadsheet-āϤ "Share" āĻā§°ু "Protect" ā§° āĻŽাāĻāϤ āĻĒাāϰ্āĻĨāĻ্āϝ āĻি?)
Answer: Share: Allows multiple users to collaborate and edit the same spreadsheet.
Protect: Restricts editing by unauthorized users.
(Share: āĻŦāĻšুāϤো āĻŦ্āĻ¯ā§ąāĻšাā§°āĻাā§°ীā§ে āĻāĻেāϞāĻে āĻাāĻŽ āĻā§°িāĻŦ āĻĒাā§°ে। Protect: āĻ
āύāύুāĻŽোāĻĻিāϤ āϏāĻŽ্āĻĒাāĻĻāύা āĻāĻāĻাā§।)
7. How can you add a password to a spreadsheet? (Spreadsheet-āϤ āĻেāύেāĻৈ Password āϝোāĻ āĻā§°িāĻŦ?)
Answer: Go to File → Save As → Tools → General Options → Set Password.
Enter and confirm the password.
(Spreadsheet-āϤ File → Save As → Tools → General Options → Set Password āĻ্āϞিāĻ āĻā§°ি Password āĻĻিā§āĻ।)
8. What is the purpose of "Compare Document" in a spreadsheet? (Spreadsheet-āϤ "Compare Document" āĻŦিāĻāϞ্āĻĒā§° āĻāĻĻ্āĻĻেāĻļ্āϝ āĻি?)
Answer: It compares two versions of a spreadsheet and highlights the differences.
It is used for reviewing changes made by multiple users.
(Compare Document āĻ āĻĻুāĻা Spreadsheet-ā§° āϤāĻĢাā§ āĻĻেāĻুā§ąাā§।)
9. What does "Accept or Reject Changes" mean in spreadsheet review? (Spreadsheet Review-āϤ "Accept or Reject Changes" āĻŽাāύে āĻি?)
Answer: It allows you to either approve or discard changes made by other users.
(āĻāĻ āĻŦিāĻāϞ্āĻĒে āĻŦ্āĻ¯ā§ąāĻšাā§°āĻাā§°ীāĻ āĻĒā§°িā§ąā§°্āϤāύ āĻ
āύুāĻŽোāĻĻāύ āĻŦা āĻĒ্ā§°āϤ্āϝাāĻ্āϝাāύ āĻā§°িāĻŦāϞৈ āĻĻিā§ে।)
10. How can you insert comments in a spreadsheet? (Spreadsheet-āϤ āĻেāύেāĻৈ āĻŽāύ্āϤāĻŦ্āϝ Insert āĻā§°িāĻŦ?)
Answer: Select the cell → Insert → Comment → Type your feedback.
The comment will appear when you hover over the cell.
(Spreadsheet-āϤ Insert → Comment āĻ্āϞিāĻ āĻā§°ি āĻŽāύ্āϤāĻŦ্āϝ āϞিāĻিāĻŦ āĻĒাā§°ি।)
11. What is the use of "Share Document" in LibreOffice Calc? (LibreOffice Calc-āϤ "Share Document" ā§° āĻŦ্āĻ¯ā§ąāĻšাā§° āĻি?)
Answer: It enables multiple users to collaborate and edit the same spreadsheet in real time.
(LibreOffice Calc-āϤ "Share Document" āĻāĻেāϞāĻে āĻŦāĻšুāϤো āĻŦ্āĻ¯ā§ąāĻšাā§°āĻাā§°ীā§ে āĻাāĻŽ āĻā§°িāĻŦ āĻĒাā§°ে।)
12. What is the difference between "View Changes" and "Track Changes"? ("View Changes" āĻā§°ু "Track Changes" ā§° āĻŽাāĻāϤ āĻĒাā§°্āĻĨāĻ্āϝ āĻি?)
Answer: Track Changes: Records modifications made by different users.
View Changes: Displays the recorded changes.
(Track Changes: āĻĒā§°িā§ąā§°্āϤāύ ā§°েāĻā§°্āĻĄ āĻā§°ে। View Changes: āĻĒā§°িā§ąā§°্āϤāύ āĻĻেāĻুā§ąাā§।)
13. What is the purpose of the "Merge Document" option? ("Merge Document" āĻŦিāĻāϞ্āĻĒā§° āĻāĻĻ্āĻĻেāĻļ্āϝ āĻি?)
Answer: It combines multiple spreadsheets into one.
It is useful when multiple users edit different copies of the same document.
("Merge Document" āĻ āĻŦāĻšু Spreadsheet āĻāĻেāϞāĻে āĻŽিāϞাā§।)
14. How can you resolve conflicts in a shared spreadsheet? (Shared Spreadsheet-āϤ āĻĻ্āĻŦāύ্āĻĻ্āĻŦ āĻেāύেāĻৈ āϏāĻŽাāϧাāύ āĻā§°িāĻŦ?)
Answer: Go to Edit → Track Changes → Resolve Conflicts.
Review and choose whether to accept or reject each conflicting change.
(Spreadsheet-āϤ Edit → Track Changes → Resolve Conflicts āĻ্āϞিāĻ āĻā§°ি āĻĻ্āĻŦāύ্āĻĻ্āĻŦ āϏāĻŽাāϧাāύ āĻā§°িāĻŦ।)
15. What is the purpose of "Data Validation" in a spreadsheet? (Spreadsheet-āϤ "Data Validation" ā§° āĻāĻĻ্āĻĻেāĻļ্āϝ āĻি?)
Answer: It ensures that only valid data is entered into the cells.
It prevents incorrect or invalid values.
(Data Validation āĻ āĻļুāĻĻ্āϧ Data Cell-āϤ āĻā§°্āϤি āĻā§°াā§° āύিāĻļ্āĻā§āϤা āĻĻিā§ে।)
EDIT BY: KRISHNA SAIKIA