DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A password prevents other people from removing the worksheet protection-it needs to be entered to unprotect the sheet. Given below are the steps to protect your sheet. On the Review tab, click Protect Sheet. In the Allow all users of this worksheet to list, select the elements you want people to be able to change.
Detailed explanation-2: -Select File > Info. Select the Protect Workbook box and choose Encrypt with Password. Enter a password in the Password box, and then select OK. Confirm the password in the Reenter Password box, and then select OK.
Detailed explanation-3: -By default, Excel activates certain “protected view” settings. This is meant to prevent you from opening an potentially infected file downloaded from the Internet, sent to you in an Email, etc.
Detailed explanation-4: -Open File > Info > Protect Document to view your security options. From the Protect Document menu, select Always Open Read-Only. Now just save the document, close it, then reopen it again. Word flashes a message that the author would like you to open this as read-only, unless you need to make changes.