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 wants to understand Excel's default settings. He realizes that the workbook's default setting includes which of the following?
A) all cells are locked, worksheet is protected
B) all cells are locked, worksheet is unprotected
C) cells are not locked, worksheet is protected
D) cells are not locked, worksheet is not protected

Question

Quizplus · Accepted Answer

The default setting in Excel is that all cells are locked, but the worksheet is unprotected. This means that users can change the values in cells, but cannot change the formulas unless the cells are unlocked first. Therefore, to achieve Seth's goal, he needs to unlock the cells containing formulas and then protect the worksheet.

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