Which of the following are the ways to protect a sheet from unauthorized access?
Each correct answer represents a complete solution. Choose all that apply.
There are two ways to protect a sheet from unauthorized access.
The first way is:
Take the following steps to protect a worksheet:
Go to the Format drop down icon in the Home tab.
Select the Protect Sheet option.
Fill the password in the Protect Sheet dialog box and re-enter the password in the Confirm Password dialog box.
After completing the above process, an error message will occur while editing the sheet.
The second way is:
Right-click on the Sheet tab and click the Protect Sheet option.
Answer options A and B are incorrect. These are not correct ways to protect a sheet from unauthorized access.
Chapter: ADVANCED SPREADSHEETS