DATABASE FUNDAMENTALS
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?
|
(VIEW tab | Protect Sheet group)
|
|
(HOME tab | Protection group)
|
|
(REVIEW tab | Changes group)
|
|
(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: -On the Review tab, in the Changes group, click the Protect and Share Workbook button. The Protect Shared Workbook dialog window will show up, and you select the Sharing with track changes check box.
There is 1 question to complete.