10
RCMultiple Choice

Unit Test — Cumulative exam

Question 10 • LHS Computer Applications

Fiona is starting to utilize the protection capabilities of Excel 2019. For the Lock or Unlock Cells function to work, which option should be enabled?

Answer
A
The Protect Workbook function needs to be enabled.
B
No functions need to be enabled other than the lock or unlock cells options.
C
The worksheet must be saved before the cells will become locked or unlocked.
D
The Protect Worksheet function needs to be enabled.

Explanation

In Excel, cells are marked as locked or unlocked in their formatting, but that setting only takes effect when the worksheet is protected. Fiona needs to enable Protect Worksheet for the lock or unlock settings to restrict editing. Protect Workbook controls the workbook’s structure, not cell editing.

AI-written and checked against the verified answer.

Previous
Next