Question 989 • Crowley Credit Recovery Algebra II B
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?
Answer
A
Use the Home tab, select Protect Sheet, and enter a password to prevent access to the sheet.
B
Click the Info tab in the Backstage view, select Protect Workbook, select Encrypt with Password, and enter a password.
C
Click the Review tab, select Protect Workbook, and enter a password for protecting the sheet.
D
Click the View tab and customize the view to protect the sheet from unauthorized users.
Explanation
To prevent people from opening and reading the spreadsheet, Janet needs to encrypt the workbook with a password. In Excel, she can do this from File (Backstage view) > Info > Protect Workbook > Encrypt with Password. Protecting a sheet or changing its view limits editing or display features, but does not prevent someone from opening the file and viewing its contents.
AI-written and checked against the verified answer.