Types of cell references-Relative reference snd Absolute reference!

Question 1

What is a cell address in a formula known as?

Answer 1

The cell address in a formula is known as cell reference.

Question 3

When you create a formula, what are references to a cell or ranges are usually based on?

Answer 3

When you create a formula, references to a cell or ranges are usually based on the position relative to the cell.

Question 4

When you copy the formula to other cells, what automatically gets changed?

Answer 4

When you copy the formula to other cells, the reference cell automatically gets changed.

Question 5

Can you give an example of relative reference?

Answer 5

Example, if the formula in A3 is =A2+A1 and you copy the formula from A3 to B3, Excel automatically changes the reference to match the location of the cells like here, =B1+B2

Question 6

When is absolute cell reference used?

Answer 6

Absolute cell reference is used when you do not want to change the address of the cell while copying the formula to another cell.

Question 7

How to use absolute reference in a formula with an example?

Answer 7

To use absolute reference in a formula, you need to add a dollar sign ($) before the column and row number. Example=$A$1=$A$2