Microsoft Excel 2010 Expert — Question 27

You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2010 and shared it with the other employees of the company. You want to protect the worksheet and locked cells by permitting or prohibiting other employees to select, format, insert, delete, sort, or edit areas of the spreadsheet.
Which of the following options will you use to accomplish the task?

Answer options

• A. Mark as Final
• B. Encrypt with Password
• C. Protect Current Sheet
• D. Protect Workbook Structure

Correct answer: C

Explanation

The correct answer is C, Protect Current Sheet, because it allows you to set specific permissions for actions on the worksheet. Options A and B do not provide the ability to restrict editing actions, while D protects the overall structure of the workbook rather than individual sheet actions.