117k views
2 votes
When you copy a formula that contains an absolute reference to a new location, the reference ____. a. has a dotted outline in its cell b. becomes bold c. is updated automaticallyd. does not change

1 Answer

2 votes

Answer:

d. does not change

Step-by-step explanation:

The correct answer to the given question is d. does not change. When a formula is copied that contains a reference, the reference does not change. However if a cell is copied in excel the cell copied has a dotted line which indicates the cell, of which the contents have been copied and are ready to be pasted in any other cell.

User Ali Mousavi
by
8.5k points

No related questions found