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

question 137

Multiple Choice

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

---

Definitions:

Whales

Large marine mammals belonging to the order Cetacea, known for their intelligence and complex behaviors.

Marine Fish Species

Aquatic species that live predominantly in oceanic and sea environments.

Coastal Waters

The part of the ocean adjacent to the coast, within a certain distance, often characterized by shallow depths and significant influence from land.

Tragedy Of The Commons

A situation where individuals, acting independently according to their own self-interest, deplete or spoil shared resources, leading to long-term collective loss.