what do you mean by cell referencing and what are the different types of referencing
Answers
Answered by
33
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.
Answered by
24
cell referencing is a tool which helps to make a relation between two or more cells by arithmetical logical tools.
Explanation:
- cell referencing is of two types. They are absolute referencing and relative referencing
- absolute referencing means the type of referencing when the value does not change even if the the contents of the cell are copied to a different cell.
- However in case of relative reference the value of the arithmetical to change his when the content of a particular cell is copied to another cell. As a result of absolute referencing is not dependent on the position of the cell contents but relative reference is dependent on it.
To know more about referencing,
What is the difference between mixed referencing and absolute referencing? Brainly.in
https://brainly.in/question/2602278
Similar questions