Question

Janet is working on a highly confidential company budget spreadsheet, and she needs to prevent anyone, including administrators in the IT department, from being able to open the file and view its contents. What should she do? Use the Home tab, select Protect Sheet, and enter a password to prevent access to the sheet. Click the Info tab in the Backstage view, select Protect Workbook, select Encrypt with Password, and enter a password. Click the Review tab, select Protect Workbook, and enter a password for protecting the sheet. Click the View tab and customize the view to protect the sheet from unauthorized users.

Answer 1

(B)Click the Info tab in the Backstage view, select Protect Workbook, select Encrypt with Password, and enter a password.

Step-by-step explanation:

(A)Use the Home tab, select Protect Sheet, and enter a password to prevent access to the sheet.

• The Protect Sheet option is not on the Home Tab.

(C)Click the Review tab, select Protect Workbook, and enter a password for protecting the sheet.

• This option allows user to view the content of the sheet but only restricts editing.

(D)Click the View tab and customize the view to protect the sheet from unauthorized users.

• This option is not available in the View Tab.