In order for the Lock or Hidden Cells function to work, which option should beenabled?O a) The Protect Workbook function needs to be enabled.b) No functions need to be enabled other than the lock or unlock cells options.O c) The worksheet must be saved before the cells will become locked orunlocked.d) The Protect Worksheet function needs to be enabled.

Answered: In order for the Lock or Hidden Cells…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

In order for the Lock or Hidden Cells function to work, which option should be
enabled?
O a) The Protect Workbook function needs to be enabled.
b) No functions need to be enabled other than the lock or unlock cells options.
O c) The worksheet must be saved before the cells will become locked or
unlocked.
d) The Protect Worksheet function needs to be enabled.

Expert Solution

Step 1

Until you secure the worksheet, locking cells in Excel has no effect. This can be perplexing, but Microsoft intended it to be that way.It is possible to unlock all the cells in order to allow some cell editing while leaving others locked. Before protecting a worksheet, you can lock only specific cells and ranges and, optionally, allow specific users to alter only specific ranges of a protected sheet.