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 sampletely 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 created a password to prevent the protection from being changed, which is why Barret receives an error message when trying to modify the protected cell.

Ruth Has a Home Office That She Shares with Her