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 cell that is locked cannot be edited when the worksheet is protected. Since its formula is visible in the formula bar, the cell’s formula is not hidden. Therefore, the cells are locked and unhidden.

AI-written and checked against the verified answer.