Lesson 7


Share and Review a Spreadsheet

    đŸ‘‰Text Books PDF
    đŸ‘‰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