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

Question

Quizplus · Accepted Answer

Seth should unlock the cells he wants users to access and then protect the worksheet. This will allow users to change the values in those specific cells while not allowing them to change any formulas or other cells in the worksheet.

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