In Excel, after __________ is on you can not change a locked item.

2024

In Excel, after __________ is on you can not change a locked item.

  1. A.

    Formula

  2. B.

    Protection

  3. C.

    Absolute referencing

  4. D.

    Relative referencing

Attempted by 62 students.

Show answer & explanation

Correct answer: B

By default, every cell in a Microsoft Excel worksheet has its "Locked" property checked. However, this setting is completely dormant until the user explicitly turns on the Protect Sheet feature.

Once Protection is turned on (typically via the Review tab > Protect Sheet), Excel enforces the lock. If a user attempts to modify, delete, or type into a locked cell, Excel will trigger an error message stating that the cell or chart is on a protected sheet. To make specific cells editable while keeping the rest secured, you must uncheck the "Locked" property for those specific cells before turning protection on.

Explore the full course: Rssb Basic Computer Instructor