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

d. does not change

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.

since it can be assumed that what aslam is making is a template by compiling all the commonly used excel formatting in several worksheets in an excel document, aslam can choose to save it using the .xltx or .xltm format instead. thus, aslam can distribute the templates he has made to his team members in an easier manner.

ιт ιѕ ωнєи ѕσмєσиє ρυтѕ ιи α ¢σ∂є σя ѕσмєтнιиg тнαт вяιиgѕ α νιяυѕ, σя мєѕѕєѕ уσυя gαмє υρ, σя αℓℓσωѕ тнєм тσ ¢нєαт.

αи∂ уєѕ ι нανє вєєи нα¢кє∂ вєfσяє(ιт αιит fυи)

нσρє ι ¢συℓ∂ нєℓρ уσυ.