213k views
0 votes
To lock certain cell in a worksheet to protect them, select the cells, then click Home tab-Alignment group-Format Cells popup window-Protection Tab-locked check box-OK to close then popup. Then click on Review tab-Changes group-Protect sheet.a. True b. False

User Gerharddc
by
8.0k points

1 Answer

3 votes

Answer:

a. True

Step-by-step explanation:

To lock certain cells in a worksheet to protect them, you need to first select the cells, then click on the Home tab, go to the Alignment group, and click on the Format Cells popup window. In the Format Cells window, select the Protection tab, then check the Locked checkbox and click OK to close the popup window.

Once you have locked the desired cells, click on the Review tab, go to the Changes group, and click on the Protect Sheet option. This will bring up the Protect Sheet dialog box, where you can set a password for the protection, choose which actions users are allowed to perform on the sheet, and select which cells are locked and which are unlocked.

Therefore, the statement "To lock certain cell in a worksheet to protect them, select the cells, then click Home tab-Alignment group-Format Cells popup window-Protection Tab-locked check box-OK to close then popup. Then click on Review tab-Changes group-Protect sheet" is true.

User Dionna
by
8.0k points