1. Which feature in Excel allows you to restrict others from changing the structure of a workbook?
(A) Protect Sheet
(B) Protect Workbook
(C) Share Workbook
(D) Track Changes
2. What does the "Protect Sheet" option in Excel do?
(A) Prevents changes to formulas only
(B) Encrypts the workbook with a password
(C) Hides the sheet permanently
(D) Restricts users from editing specific cells or the entire sheet
3. Which option allows you to set a password so that only authorized users can open a workbook?
(A) Protect Sheet
(B) Protect Workbook
(C) Encrypt with Password
(D) Track Changes
4. The "Share Workbook" feature in Excel is used to:
(A) Send workbook via email directly
(B) Allow multiple users to work on the same file simultaneously
(C) Protect the file with a password
(D) Convert the file to PDF
5. Which feature helps in tracking who made changes to a shared Excel workbook?
(A) Track Changes
(B) Protect Sheet
(C) Goal Seek
(D) Data Validation
6. If you protect a worksheet without selecting specific options, by default users cannot:
(A) Select unlocked cells
(B) Enter data in any cell
(C) Change the width of columns
(D) Insert new worksheets
7. Which tab in Excel contains the “Protect Workbook” and “Protect Sheet” options?
(A) Home
(B) Review
(C) Data
(D) File