When a cell is set to read-only, how does it affect the relationship between the cell and any data used in its formula?

(1 point)
Responses

The original data is locked against changes.
The original data is locked against changes.

The read-only cell stays the same even if the original data changes.
The read-only cell stays the same even if the original data changes.

The read-only cell updates if the original data changes.
The read-only cell updates if the original data changes.

The cells can be changed, but the file can’t be saved.
The cells can be changed, but the file can’t be saved.

1 answer

The correct response is:

The read-only cell stays the same even if the original data changes.

When a cell is set to read-only, it means that the cell itself cannot be edited, and as a result, it will retain its value even if the original data used in its formula is changed.