FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following is the path to the Protect Sheet button?
A
(VIEW tab | Protect Sheet group)
B
(HOME tab | Protection group)
C
(REVIEW tab | Changes group)
D
(VIEW tab | Protect group)
Explanation: 

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.

There is 1 question to complete.