How is absolute referencing different from mixed referencing in a spreadsheet? Explain with an example.
Answers
Answered by
5
Answer:
In Absolute Cell Referencing the cell references remain constant and does not change with change in formula position, when copied to a new position. $ (Dollar) sign us used to make a row or column absolute. In Mixed Cell Referencing either a column or a row is made absolute or fixed with help of $(Dollar) sign.
Similar questions