COMPSCI 1BA3 Lecture Notes - Microsoft Excel, Doubleclick

the adjusted cell references in a copied and pasted formula are called ____ cell references.

Which of the following happens when you enter the formula =g15 into a cell?

1. Excel recalculates all formulas in the worksheet
2. Excel assigns the sum of the values in the previous 15 cells to the active cell
3. Excel assigns the value in cell G15 to the active cell
4. Nothing, =G15 is an invalid formula

when you copy a formula that contains an absolute reference to a new location, the reference ____.