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

question 124

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.
-In order for Seth to allow others to enter data into some of the cells in the worksheet but not others, he should ____.

• A) unlock the cells he wants users to access and then protect the worksheet
• B) protect the worksheet and then unlock the cells he wants users to access
• C) name ranges and click "allow data entry" in the Data Validation dialog box
• D) none of the above

---

Definitions:

Mutual Savings Bank

A financial institution owned by its depositors, primarily engaging in saving accounts and residential mortgage lending.

Depositors

Individuals or entities who place their money in a bank for safekeeping and earn interest over time.

Gramm-Leach-Bliley Act

A U.S. federal law enacted in 1999 that allows financial institutions to offer a broader range of services, including banking, securities, and insurance.