Question

In a particular spreadsheet, the data in each cell is password protected. When cells are selected, the formula is visible in the formula bar. Which is true?

A. The cells are locked and hidden.

B. The cells are locked and unhidden.

C. The cells are unlocked and hidden.

D. The cells are unlocked and unhidden.

Answer 1

Answer: I think the answer is C. The cells are unlocked and hidden.

Explanation: The formula of a locked cell remains visible, but grayed out, in the formula bar and the Spreadsheet View's status bar, when the mouse pointer is resting on the locked cell.

You may need to enter a password though if the worksheet is protected with a password. Then press CTRL+1 to open the Format Cells window. Uncheck Hidden from the Protection tab. Next click on the OK button as shown in the following picture. After that, you will see that the cell contents are visible in the formula bar as shown below.