14
QuizMultiple Choice

Pivot Tables and Pivot Charts — Cumulative exam

Question 14 • Computer Applications - Office 2016 - EL3520 A

What is the only way to remove a password encryption on an Excel file?

Answer
A
Resave the workbook as a new document or make a copy of it.
B
Open the workbook as Read Only and resave it without a password.
C
Open the workbook in Protected View and resave it without a password.
D
Enter the password to open the workbook, and delete the password created in the Encrypt with Password box.

Explanation

To remove password encryption, you must first open the workbook using its current password. Then go to the Encrypt with Password setting, delete the password, and save the workbook. Making a copy or opening the file in Read Only or Protected View does not remove its encryption.

AI-written and checked against the verified answer.

Previous
Next