What should be clicked to allow users to select but not edit locked cells?

Prepare for the Level 4 Black Belt Badge Credential Exam with our comprehensive course. Tackle flashcards and multiple-choice questions with hints and explanations. Boost your confidence and excel in your exam!

Selecting the option to protect the sheet is the correct choice because it allows users to interact with specific cells while ensuring that locked cells cannot be edited. When you protect a sheet, you have the ability to define which cells are locked and which are editable. By doing so, you can enable selection of locked cells, but not allow any modifications to them.

This protective measure is particularly essential when you need to preserve the integrity of certain data while still permitting users to navigate through the spreadsheet. The other options are not appropriate for this scenario because protecting the workbook deals with the overall structure of the file rather than individual cell permissions, formatting cells pertains to changing the appearance of data rather than security, and accessing the review tab does not directly relate to controlling cell editability.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy