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.

b?                                                              v                  

They are locked and unhidden.

In Excel, you can lock a selected formula or cells with formulas on a given sheet. Locking cells with formulas does not mean that you cannot edit those cells. Actually, locking cells has no effect until you protect the entire worksheet. You can use the Go To Special dialog box to select cells with formulas only and then lock them using the Format Cells dialog box. Selecting the Locked option in the Format Cells dialog box prevents the user from overwriting or deleting the contents of the cells. Hiding a formula means preventing that formula from being shown in the formula bar when you click and highlight that cell with the formula . Therefore, in this case, if the formula appears when you click the cell, then it is not hidden.

the answer is d underlined.