155k views
3 votes
An absolute cell reference changes the cell references when the formula is copied to a new location.

a) true
b) false

User Shizam
by
5.6k points

1 Answer

3 votes

Answer:

False

Step-by-step explanation:

In Microsoft Excel or Google Sheet, an absolute cell reference is a cell address that won't be changed even the formula is copied to a new location.

Absolute cell reference is always used whenever a formula is expected to be consistently referred to a particular cell. To create an absolute cell reference, we can simply preceded the row or column or both with the dollar sign $.

For example:

=$A$3 - $B$3

User Hansika
by
5.1k points