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:

Component Parts

Individual pieces or elements that, when combined, form a complete product or system.

Specialty Products

Specialty products are goods and services that are perceived as unique or high-value by consumers, often characterized by significant brand loyalty and a higher purchasing effort.

Shopping Products

Goods that consumers purchase after comparing quality, price, and style from various sellers, spending considerable time and effort to make the best decision.

Business Products

Goods or services that are sold to other businesses for further production, use in operations, or resale.