43
RCMultiple Choice

Pivot Tables and Pivot Charts — Cumulative exam

Question 43 • Computer Applications - Office 2016 - EL3520 A

Fiona is starting to utilize the protection capabilities of Excel 2016. 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 through their formatting, but that setting only takes effect when the worksheet is protected. Fiona needs to enable Protect Worksheet; protecting the workbook is a separate feature for securing workbook structure, not individual cells.

AI-written and checked against the verified answer.

Previous
Next