Ruth has a home office that she shares with her husband, Barret. She keeps track of her business profits and expenses in several worksheets.
-Barret decides he wants to unprotect one of the protected cells so he can replace one of the formulas.What did Ruth do to cause an error message to appear when Barret tries to change the protection?
A) she created a password to prevent the protection from being changed
B) she set the protection on all of the cells with a double-lock status
C) she did not completely test the formula for that cell as she had thought
D) she set the "Select locked cells" option in the Protect Sheet dialog box

Question

Quizplus · Accepted Answer

Ruth likely created a password to prevent the protection from being changed, which would cause an error message to appear when Barret tries to modify a protected cell without the password.

Ruth Has a Home Office That She Shares with Her