As part of his new job, Seth has created a Projected Income worksheet for his company. He wants to prohibit users from changing the formulas in the Projected Income worksheet, while allowing them to change values such as unit sales and unit price. Seth has also imported a worksheet named Sales History, which contains sales information for sunglasses for the last year.
-Seth is thinking about hiding all cells with formulas in his Projected Income worksheet. He thinks this will definitely protect them from being changed. You would advise him not to hide all of these cells because ____.
A) depending on whether the worksheet is protected, users will still be able to unhide and change the cell contents
B) it is considered poor practice to hide cells with formulas in a worksheet
C) both a and b
D) neither a nor b

Question

Quizplus · Accepted Answer

Hiding cells with formulas does not inherently protect them from being changed if the worksheet is not protected. Users could unhide and modify the cell contents.

As Part of His New Job, Seth Has Created a Projected