Sharing and protecting workbooks Excel MCQs

  1. Which option allows you to restrict users from making changes to a workbook in Excel?
    a) Protect Workbook
    b) Share Workbook
    c) Lock Workbook
    d) Restrict Changes
    Answer: a) Protect Workbook
  2. How can you password-protect a workbook to prevent unauthorized access?
    a) Go to File > Save As > Tools > General Options
    b) Go to Review > Protect Workbook > Password
    c) Go to File > Protect Workbook > Encrypt with Password
    d) Go to Data > Password Protect
    Answer: c) Go to File > Protect Workbook > Encrypt with Password
  3. Which feature allows multiple users to work on the same Excel workbook simultaneously?
    a) Share Workbook
    b) Protect Workbook
    c) Track Changes
    d) Collaborate
    Answer: a) Share Workbook
  4. What does the ‘Track Changes’ feature do in Excel?
    a) Saves changes automatically
    b) Highlights changes made by different users
    c) Encrypts the workbook
    d) Protects the workbook from unauthorized access
    Answer: b) Highlights changes made by different users
  5. Which option should you select to prevent others from deleting a worksheet within a protected workbook?
    a) Protect Workbook Structure
    b) Protect Worksheet
    c) Restrict Editing
    d) Set Permissions
    Answer: a) Protect Workbook Structure
  6. How can you review changes made to a shared workbook?
    a) Go to Review > Track Changes > Highlight Changes
    b) Go to Data > Track Changes
    c) Go to View > Shared Workbook
    d) Go to Tools > Track Changes
    Answer: a) Go to Review > Track Changes > Highlight Changes
  7. What is the purpose of the ‘Allow Users to Edit Ranges’ feature in Excel?
    a) To define which cells can be edited when the workbook is protected
    b) To limit the number of users who can edit the workbook
    c) To track changes made by users
    d) To restrict access to specific worksheets
    Answer: a) To define which cells can be edited when the workbook is protected
  8. Which action will remove a password from a protected workbook?
    a) Go to Review > Unprotect Workbook
    b) Go to File > Protect Workbook > Remove Password
    c) Go to Data > Remove Protection
    d) Go to Review > Change Password
    Answer: b) Go to File > Protect Workbook > Remove Password
  9. How can you make a workbook read-only to prevent accidental changes?
    a) Save the workbook with the Read-Only recommended option
    b) Protect the workbook with a password
    c) Share the workbook and set user permissions
    d) Use the ‘Mark as Final’ option
    Answer: a) Save the workbook with the Read-Only recommended option
  10. Which setting should you use to prevent users from copying or printing a protected workbook?
    a) Protect Workbook
    b) Restrict Editing
    c) Mark as Final
    d) Encrypt with Password
    Answer: b) Restrict Editing

Related Posts: