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:

Hard Influence Tactic

A coercive strategy used to influence others' actions or decisions by exerting power or pressure, similar to hard influence tactics with emphasis on control.

Forming Coalitions

The process of creating alliances or partnerships between groups or individuals to achieve a common goal or address a common issue.

Strike

A collective work stoppage by a group of employees, often through a union, to express grievances or demand better conditions or pay.

Controlling Information

The management practice of regulating and determining the flow, access, and accuracy of information within an organization.