Computer Science, asked by rohitmandal25200l, 4 months ago

. What is the role of $ sign in referring to the cells in a formula in a
spreadsheet? Give examples..​

Answers

Answered by kurhadeshruti
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