2
AssignmentMultiple Select

Use Spreadsheet Functions and Formulas

Question 2 • CHS- TX-Professional Communications (CR)

Which of the following correctly describe cell protection in spreadsheet software? Choose all that apply.

Answer
A
Cell protection is a security feature used to limit changes and visibility of data.
B
The contents of an unlocked cell cannot be modified.
C
By default, cells are locked and not hidden.
D
Once activated, cell protection is guaranteed.

Explanation

Cell protection can restrict changes to cells and, when the hide option is used, can conceal their contents, so A is correct. In typical spreadsheet software, cells are marked locked by default but that setting only takes effect after sheet protection is turned on; cell contents are not hidden by default, so C is correct. Unlocked cells can be modified, and protection is not guaranteed against every kind of access or change, making B and D incorrect.

AI-written and checked against the verified answer.

Previous
Next