what is cell reference mention its type and in short
Answers
Answered by
33
Answer:
cell 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. In one or several formulas, you can use a cell reference to refer to: ... Data contained in different areas of a worksheet.
Explanation:
I hope it will help you
pls give me thankx
Answered by
26
Answer :
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.
hope it is help full
mark me as Brain list
Similar questions
English,
2 months ago
History,
2 months ago
Math,
2 months ago
English,
4 months ago
Computer Science,
11 months ago
Social Sciences,
11 months ago