USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
(VIEW tab | Protect Sheet group)
|
|
(HOME tab | Protection group)
|
|
(REVIEW tab | Changes group)
|
|
(VIEW tab | Protect group)
|
Detailed explanation-1: -Go to File > Info > Protect > Unprotect Sheet, or from the Review tab > Changes > Unprotect Sheet.
Detailed explanation-2: -Method A: Protect Sheet button in Review tab Go to the Changes group under Review tab, you will find out the Protect Sheet button as soon as possible.
Detailed explanation-3: -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-4: -Purpose of a Protecting sheet with a password To prevent the unknown users from accidentally or purposely changing, editing, moving, or deleting data in a worksheet, you can lock the cells in the Excel worksheet and then protect an Excel sheet with a password.