Which of the following steps will you take to protect your worksheet from unauthorized access?

Which of the following steps will you take to protect your worksheet from unauthorized access?
A . Format > Protect Sheet > Lock Sheet
B . Insert > Format > Protect Sheet
C . Home > Format > Protect Sheet
D . Format > Worksheet > Lock Sheet

View Answer

Answer: C

Explanation:

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.

Answer options B, A, and D are incorrect. These are not valid steps to protect your worksheet from unauthorized access.

Reference: Microsoft Dynamics CRM Course Manual, Contents: "Protect Sheet"

Chapter: ADVANCED SPREADSHEETS

Objective: Editing