Excel Calculations Self-Test - Duke University

The absolute reference in a formula does not change when a formula containing it is moved or copied. The picture below shows cell E1 (containing the value 4.184) used as an absolute (unchanging) reference cell. Defined Names. are an example of absolute cell references (see Excel Practice Part I). ................
................