183k views
0 votes
When is it appropriate to use an absolute reference?

when the information in a formula always relates to the same cell
when the information in a formula changes to relate to the cells next to the specified location
when the value of a specified cell must remain a positive number
when the value of a specified cell must be the same as the value of the cell immediately preceding it

User Sgrgmngt
by
8.0k points

1 Answer

6 votes

Answer: The answer to this question is C when the value of a specified cell must remain a positive number

User Mitzy
by
7.3k points