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

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

User Manuel Jordan
asked Oct 16, 2019 111k views
Which column and row references are updated when you copy the formula: =SUM($B5:D$15)?
Manuel Jordan asked Oct 16, 2019
by Manuel Jordan
8.2k points
2 answers
3 votes
111k views
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

Categories

Other Questions

“What does it mean when we “rework” copyrighted material?”
The book shows how to add and subtract binary and decimal numbers. However, other numbering systems are also very popular when dealing with computers. The octal (base 8) numbering system is one of these.
Seven basic internal components found in a computer tower
Link Copied!