Question

You can use up to three levels of security and protection to control who can access and change your Excel data. Please describe two of the three levels and how you access each of them.

Answer 1

Explanation:

First level security is when you lock file:

In order to unlock and access you have to set password for file as per below step.

• Go to excel file then click File – Save As.
• Choose location where you want to save it, Folder, Desktop.
• In the Save As dialog box, choose the specific folder you like, after that click Tools and after that click General Options.
• You will get a dialog box named - Generals Options where you can set password to open file and password to make modification in file – set a password for both.
• Then Click Save.

Second level of security is to lock worksheet.

In order to Secure Worksheet you have to protect that Worksheet.

• You will see Review tab on tab menu click on that, then you see Protect Sheet option click on that.
• Dialog box will open where you can set area you want to allow user to modify, Choose the area.
• You have to check the Protect worksheet and content of locked cells and enter a password in Password to unprotect sheet to protect sheet from getting open and modify.