Understanding Excel Cell References

Which of the following is a relative cell reference in Excel?

• $A$1

• A1

• $A1

• A$1

What symbol is used in Excel to make a cell reference absolute?

• #

• $

• &

• %

Which of the following is an absolute cell reference?

• A1

• $A1

• $A$1

• A$1

What type of cell reference is A$1 in Excel?

• Absolute

• Relative

• Mixed

• External

How do you reference cell B2 from a sheet named "Data" in Excel?

• Data!B2

• 'Data Sheet'!B2

• [Data]B2

• =Data!B2

Which of the following best describes a relative reference?

• It always refers to the same cell, no matter where it is copied.

• It changes based on where the formula is copied.

• It refers to a cell on another worksheet.

• It locks only the column or row.

If you copy the formula a formula from once cell to another, what must you do to ensure a cell reference does not change?

• make sure you plug in the right formula

• make sure you plug in a mixed cell reference

• make sure you plug in a fixed cell reference

• you cannot copy a formula and must retype it each time

Which cell reference will keep the row fixed but allow the column to change when copied?

• A1

• A$1

• $A1

• A1

You have the formula =Sheet2!C3 in cell A1. What does this formula do?

• Adds the values of C3 from all sheets

• References cell C3 from Sheet2

• Multiplies A1 by C3

• Copies the value of A1 to Sheet2!C3

Which of the following is a mixed cell reference?

• A1

• A1

• $A1

• Sheet1!A1