USING MICROSOFT EXCEL
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: -Important: The password is optional. If you do not supply a password, any user can unprotect and change the workbook. If you do enter a password, make sure that you choose a password that is easy to remember.
Detailed explanation-2: -To prevent other users from accidentally or deliberately changing, moving, or deleting data in a worksheet, you can lock the cells on your Excel worksheet and then protect the sheet with a password.
Detailed explanation-3: -Open the sheet or workbook that you want to protect. On the Review tab, click Protect Sheet or Protect Workbook. In the Password box, type a password, and in the Verify box, type the password again. Choose any other protection options you want and click OK.
Detailed explanation-4: -Add a password to protect worksheets or your entire workbook and control whether others can open or make changes to them. You can add headers to the top and footers to the bottom of a worksheet.
Detailed explanation-5: -The recent versions of Excel use more sophisticated methods of sheet protection, but they are also vulnerable and can be unlocked without knowing a password.