Q1. What is cell referencing? what is the difference between relative and absolute reference explain with example.
Answers
Answered by
0
Answer:
What is cell referencing
acell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.
Explanation:
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.
Similar questions