74.0k views
4 votes
n spreadsheet programs, labels and constant values are always copied exactly to the new location; what happens to formulas when they are copied depends on whether they use relative cell referencing or ____.

User Zorro
by
8.6k points

1 Answer

4 votes

Answer:

The correct answer is Absolute cell referencing.

Step-by-step explanation:

An absolute reference is a reference in the formula, which does not change when copying to another cell. By using absolute references the cell address is kept when copied to other cells. This is a powerful tool when you are working on a spreadsheet with lots of data.

To create an absolute reference, place the weight sign ($) before the column (letter) or line (number) that you do not want to change. For example: the cell reference $ C $ 4 is an absolute reference; however cell reference C4 is a relative reference. If you copy a formula that contains the absolute reference $ C $ 4 to another cell, the cell reference $ C $ 4 does not change, but if you copy a formula that contains the relative reference C4 to another cell, the C4 reference does change.

User Marianobianchi
by
8.3k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.