Question

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

Answer 1

unlock the user cells and then protect the worksheet

Step-by-step explanation:

In order for Ruth's husband, Barret not to alter other cells of the worksheet files, she has to unlock the user cells and then protect the worksheet.

By unlocking the user cells and protecting the work sheet, she has prevented her husband, Barret from making a change to other cells of the worksheet.

A worksheet refers to a sheet of paper on which one performs work. The worksheet Ruth used in he home office is the computer based work sheet (software) where she keeps records of her business transactions.