Register
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
121k views
3 votes
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

User Seanrco
by
8.5k points

1 Answer

4 votes
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.
User Zecong Hu
by
7.0k points
← Prev Question Next Question →

Related questions

Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.4m questions

12.2m answers

Other Questions

“What does it mean when we “rework” copyrighted material?”
Please help me ! All you do is just put it it all in your own words ! Please this is for my reported card!i don't know how to put it in my own words because my English is not that good!
describe an advance in technology that makes life more enjoyable. what discoveries contribute to this technology?
Disadvantages of using animation in advertising? advantages and disadvantages of using animation for education? advantages and disadvantages of using animation in entertainment?
What is an example of a dedicated computer system?
Link Copied!