Question

What is Absolute Reference​

Answer 1

Answer:

AN ABSOLUTE REFERENCE IS AN CELL REFERENCE THAT INTENTIONALLY WON'T CHANGE WHEN AN FORMULA IS COPIED. THERE ARE MANY SITUATIONS WHERE ABSOLUTE REFERENCES ARE HELPFUL, TO MAKE REFERENCE ABSOLUTE, YOU NEED TO ADD DOLLAR

SIGN TO THE ADDRESS, ONE TO LOCK THE ROW AND ONE TO LOCK THE COLUMN

HOPE It's HELP YOU

Answer 2

Answer:

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied