DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Unlocked cells
|
|
|
Locked cells
|
|
|
Protected workbook
|
|
|
Protected Range with password
|
Detailed explanation-1: -Now select only the cells or columns, rows that you want to protect. Right click and choose Format cells again. Go to the protection tab and check Locked option and click Ok. Go to Review tab, click Protect Sheet and protect the sheet using a password.
Detailed explanation-2: -The plasma membrane, or the cell membrane, provides protection for a cell. It also provides a fixed environment inside the cell, and that membrane has several different functions. One is to transport nutrients into the cell and also to transport toxic substances out of the cell.
Detailed explanation-3: -Select the cells you want to lock. On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window. On the Protection tab, select the Locked check box, and then click OK to close the popup.