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)
The original data is locked against 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 cells can be changed, but the file can’t be saved.

1 answer

The correct answer is: The read-only cell updates if the original data changes.

When a cell is marked as read-only, it prevents users from making changes to that specific cell. However, if the cell contains a formula that references other data, it will still update automatically based on changes to the referenced data, as long as that data is not also read-only.