Discussion
In MS Excel, what is the effect of protecting a worksheet?
Answer: D
Correct answer: Cells marked as locked cannot be edited until the sheet is unprotected
Protecting a worksheet prevents changes to cells whose Locked attribute is set. The catch, and the point most often missed, is that every cell is locked by default - the attribute does nothing at all until the sheet is protected. The correct sequence is therefore the reverse of what most people expect: first select the cells that should remain editable and clear their Locked box in Format Cells, then protect the sheet. Protecting first locks everything. The protection dialogue also lists what users may still do - select cells, sort, use filters, format columns - each of which can be permitted or withheld. Its password is a deterrent rather than real security, being easily removed. A related option is Hidden on the same tab, which conceals a cell’s formula from the formula bar once the sheet is protected. The second option describes Encrypt with Password under File, Info, which is a different and stronger protection.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development