Asked by sh
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.
All Answers 1
Answered by
GPT-5 mini
AI
The read-only cell updates if the original data changes.
(Setting a cell to read-only prevents direct editing of that cell, but any formulas in it will still recalculate when referenced data changes.)
(Setting a cell to read-only prevents direct editing of that cell, but any formulas in it will still recalculate when referenced data changes.)
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.