Excel Worksheet Protection Quiz

How can you lock or unlock specific cells in a worksheet?

• Right-click on the cell and select "Lock Cell"

• Use the "Format Cells" option, then the "Protection" tab to lock/unlock cells

• Go to "File" and click on "Lock Cells"

• Select the cell and press Ctrl + L

What must you do after locking cells in Excel to protect them from editing?

• Save the workbook

• Turn on sheet protection by going to "Review" > "Protect Sheet"

• Highlight the cells and press "Protect"

• Close and reopen the workbook

What happens when you protect a worksheet in Excel?

• The workbook cannot be saved

• The entire worksheet is hidden from view

• Users can view the data but cannot edit certain locked cells

• All formulas are automatically erased

Which of the following options allows you to protect an entire workbook from structural changes?

• Protect Workbook option under the Review tab

• Save As with a password

• Hide Workbook option under the View tab

• Protect Sheet option under the Home tab

What is the purpose of using Data Validation in Excel?

• To automatically sort data based on rules

• To restrict the type of data that can be entered into a cell

• To protect certain cells from being edited

• To highlight duplicates in the worksheet

Which of the following is NOT a common use of Data Validation in Excel?

• Restricting entries to whole numbers only

• Setting a drop-down list for specific cell inputs

• Automatically adding currency symbols to numeric entries

• Creating custom input messages for cells

To remove Data Validation from a cell, you should:

• Delete the cell’s contents

• Use the Clear Validation option

• Re-enter the data

• Change the cell format

How can you protect the structure of an Excel workbook?

• By applying "Protect Workbook" and selecting "Structure" under the "Review" tab

• By hiding all the sheets except the first one

• By renaming the workbook file with a password

• By setting data validation rules on every sheet

Which action does NOT require you to unlock a worksheet before making changes?

• Editing locked cells

• Formatting the worksheet

• Entering data into unlocked cells

• Deleting a worksheet

How do you set a password to protect a worksheet from being unprotected?

• Go to the "File" tab, select "Info," and set the password

• Under the "Review" tab, select "Protect Sheet" and set a password

• Under the "Home" tab, select "Protect Workbook"

• Go to the "Data" tab, select "Data Validation," and set a password