while you were conducting some calculations, you realize that the values were being incorrectly calculated because the range of the cells would change when you dragged the cell or copied it to another location. your goal is to make cell e9 an absolute reference, which means that if you copy or drag the function to another cell, it will still point to the same cell. you wo