In Excel, what symbol is used before a number or text to make it an absolute reference?

A cell reference like 'A1' is an example of a relative reference.

What does the '$' symbol do to a cell reference in Excel?

Which of the following is an example of a mixed reference in Excel?

When you copy a formula with a relative reference, the reference stays exactly the same.

What is the term for a cell reference that does not change when copied?

If you have a formula in cell B2 that says =A2+C2, and you copy it to cell B3, what will the new formula be?

A cell reference like '$B$5' is a relative reference.

What is the main benefit of using absolute references?

Which reference type is useful when you want to multiply a column of numbers by a single constant value?

In Excel, 'A$1' is a mixed reference because only the row is locked.

What type of reference is 'B$2'?

If a formula in cell C3 is =SUM($A$1:$B$2), and you copy it to cell D4, what will the formula become?

A formula with a relative reference will always refer to the same cells when copied.

What is the term for a cell reference that locks either the column OR the row, but not both?