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
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
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
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
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
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
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
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
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
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
