How should the current worksheet be protected to allow users to select both locked and unlocked cells, but only make changes to unlocked cells?

A. Protect the worksheet with the password "cengage."
B. Allow users to select both locked and unlocked cells.
C. Allow changes only to unlocked cells.
D. All of the above.

To protect a worksheet while allowing the selection of both locked and unlocked cells but limiting editing to only unlocked cells, the worksheet should be protected potentially with a password, with settings allowing cell selection and restricting changes to unlocked cells only. Therefore, the answer is 'All of the above'.

Explanation:

To protect the current worksheet to allow users to select both locked and unlocked cells but only make changes to unlocked cells, the correct action is to use a combination of settings when you protect the worksheet. You should do the following:

Protect the worksheet with a password, if necessary, to prevent unauthorized changes.
Ensure the option to allow users to select both locked and unlocked cells is enabled.
Set the protection to allow changes only to unlocked cells.

These settings will enable users to select cells to view the data but restrict editing to only the cells that are not locked. Therefore, the answer to the student's question would be 'd) All of the above'.