. What is the role of $ sign in referring to the cells in a formula in a
spreadsheet? Give examples..
Answers
Answered by
0
Answer:
The dollar sign in an Excel cell reference affects just one thing - it instructs Excel how to treat the reference when the formula is moved or copied to other cells. In a nutshell, using the $ sign before the row and column coordinates makes an absolute cell reference that won't change
Similar questions