Ruth Has a Home Office That She Shares with Her

Multiple Choice

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