what is cell refference and there types
Answers
Answer -
- A cell Refference refers to a cell or range of cells on a worksheet to n Ms Excel and can be used in a formula so that ms Excel can find the values or data that you want to calculate in a formula.
__________________________
There Are Three types of cell reference →
Absolute cell Refference - An absolute cell reference in a formula such as $A$1 always refers to a cell in a specific location. If the position of the cell that contains the formula changed. The absolute reference remain the same if you copy the formula across row or down columns the absolute reference does not adjust by default new formula use relative reference and you need to switch them to absolute reference.
_______________________________
Relative cell Refference - A relative cell reference in a formula such as A1 is based on the relative position of the cell that contains the formula and the cell reference refers to. If the position of the cell that contains the formula changed. The reference is changed. If you copy the formula across rows down columns. The reference automatically adjust by default new
______________________________
Mixed cell Refference - It is a combination of relative and absolute reference as with absolute cell reference the $ sign is used in mixed cell reference to indicate that a column latter or row no. is to remain fixed when it copied from one cell to another. Ex of a mixed reference would be $E4 or f$6
→ Hope it will help you ❣️❣️
→ Please mark as Breinliest ❤️❤️