COMP APPS II: 5.4.1 Data Protection

Why might you want to limit the ability of other users to modify your spreadsheets?

• To ensure that the document will continue to function properly.

• To prevent other users from accessing the data in the spreadsheet.

• To make it easier for other users to use the spreadsheet.

• To prevent other users from saving changes to the spreadsheet.

How do you protect a worksheet?

• Click on the Home tab, in the Cells group, click on the Protect Sheet button, and select permissions for users.

• Click on the View tab, in the Window group, click on the Protect Sheet button, and select permissions for users

• Click on the Review tab, in the Changes group, click on the Protect Sheet button, and select permissions for users.

• Click on the File tab, in the Info group, click on the Protect Sheet button, and select permissions for users.

How do you unlock cells before protecting a worksheet?

• Select cells to be editable, right-click them, choose Format Cells, click on the Protection tab, check Locked box and click OK.

• Select cells to be editable, right-click them, choose Format Cells, click on the Protection tab, uncheck Locked box and click OK.

• Select cells to be editable, right-click them, choose Format Cells, click on the Number tab, uncheck Locked box and click OK.

• Select cells to be editable, right-click them, choose Format Cells, click on the Alignment tab, uncheck Locked box and click OK.

What happens when a user tries to edit content of a protected sheet?

• They will receive a message

• They will not receive a message

• All of these

• None of these

How can you protect a worksheet?

• Click Review tab then Changes group then Protect Sheet button

• Select permissions for users

• Enter password if desired

• All of these

How can you unlock cells before protecting worksheet?

• Select cells to be editable then right click then Format Cells

• Click Protection tab then uncheck Locked box then click OK

• All of these

• None of these

What happens when you protect a worksheet?

• Unlocked cells remain editable

• Locked cells are not editable

• All of these

• None of these

What is default setting for cells?

• Locked

• Unlocked

• All of these

• None of these

What happens when you unlock cells before protecting worksheet?

• Unlocked cells remain editable

• Locked cells are not editable

• All of these

• None of these

What is purpose of unlocking cells before protecting worksheet?

• To allow certain cells to remain editable while others are not

• To prevent certain cells from being edited while others are not

• All of these

• None of these