Question

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

Answer 1

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.