Ask Question

Which column and row references are updated when you copy the formula: = F$5+12? Value 12 Column F Column F and row 5 Row 5

+4
Answers (1)
  1. 10 March, 22:37
    0
    The answer is column F. During relative copy and paste in Excel, the positioning of the '$' symbol effectively indicated an absolute reference to a position, so that is not updated. Therefore, in the formula ' = F$5+12 ', only column F is updated.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Which column and row references are updated when you copy the formula: = F$5+12? Value 12 Column F Column F and row 5 Row 5 ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers