Computer Science, asked by janvi87685, 8 months ago

3) Which cell reference is an example if absolute cell reference 1) $A1 2) $A$1 3) A1$​

Answers

Answered by jefferson7
5

3) Which cell reference is an example if absolute cell reference 1) $A1 2) $A$1 3) A1$​

Explanation:

When one enters a cell reference or range into a formula, by default, the reference is relative. It is most widely used type of cell referencing.

In absolute  cell referencing, the cell reference must be unchanged when copied or when using AutoFill.  Dollar signs are usually used to hold a column and/or row reference constant.

In the above case $A$1 is an absolute cell reference.

Similar questions