Work Smarter With Microsoft Excel Coursera Quiz Answers [new] Official
Mastering the Work Smarter with Microsoft Excel is a major step toward boosting your productivity and preparing for the MO-200: Microsoft Excel certification.
Conclusion
Options: Protect the workbook with a password; Hide the specific cells; Unlock all cells, then lock the specific cells, then protect the sheet.
Correct Answer: Unlock all cells, then lock the specific cells, then protect the sheet.
Explanation: By default, all cells are "Locked." Protection only takes effect when you protect the sheet. To allow editing everywhere except a few cells, you must unlock all cells (Ctrl+1 > Protection > Uncheck Locked), then lock the specific cells, then turn on Sheet Protection.