23.3k views
5 votes
In a cell reference, if you move the formula to another cell, the cells referred to in the formula will not change is called______

a.Conditional Formatting
b.Mixed
c.Relative
d.Absolute

User LukeSolar
by
7.5k points

1 Answer

4 votes

Final answer:

Absolute referencing is a feature in spreadsheets like Microsoft Excel that allows you to lock a cell reference so that it does not change when a formula is moved to another cell.

Step-by-step explanation:

The correct answer is Absolute.

Absolute referencing is a feature in spreadsheets like Microsoft Excel that allows you to lock a cell reference so that it does not change when a formula is moved to another cell. When a cell reference is absolute, it is denoted with a dollar sign ($).

For example, if you have a formula =A1+$B$2 and you copy this formula to cell C3, the cell reference A1 will change to B3, but the cell reference B2 will remain unchanged because it is an absolute reference.

User Bhaller
by
7.6k points