What is the role of $ sign in referring to the cells in a formula in a spreadsheet? Give examples.
Answers
Answered by
10
Answer:
It is used in absolute cell refrence so that when the formula is copied to another cell its reference doesn't gets changed
Please mark it as the brainliest answer
Answered by
2
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