Critical Thinking Questions Case 4-2 Ruth Has a Home Office

Multiple Choice

Critical Thinking Questions Case 4-2 Ruth has a home office that she shares with her husband, Barret. She keeps track of her business profits and expenses in several worksheets. Ruth has fully tested all of the formulas in her worksheet and the correct results appear. Ruth provides a copy of the worksheet file to Barret so he can use it for his business calculations. As a user, Barret can make changes only to certain cells. What did Ruth do to ensure the other cells cannot be altered by user Barret?

A) unlock the user cells and then unprotect the worksheet
B) unlock the user cells and then protect the worksheet
C) she did not completely test the formula for that cell as she had thought
D) lock the user cells and then protect the worksheet