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:

Aggressive

Behavior characterized by hostility, assertiveness, and often the intent to harm or assert dominance over others.

Peers

Individuals who are equals within a specific context, such as age, grade, or status, often influencing social and psychological behavior.

Daycare

A service that provides care and educational activities for children when their parents or guardians are unavailable during the day.

Nutrition

The process of providing or obtaining the food necessary for health and growth.