Cell Reference Mastery

In a spreadsheet, what type of cell reference stays the same when copied to other cells?

• Absolute cell reference

• Static cell reference

• Dynamic cell reference

• Relative cell reference

Identify the type of cell reference: $A$1

• $A$1

• $A1

• A$1

• A1

If cell A1 contains the formula =B1+C1, what type of cell reference is used for B1 and C1?

• Absolute cell reference

• Relative cell reference

• Mixed cell reference

• Static cell reference

What type of cell reference changes when copied to other cells?

• Static cell reference

• Relative cell reference

• Mixed cell reference

• Absolute cell reference

In the formula =A1*$B$2, what type of cell reference is used for A1 and B2?

• Static and Dynamic

• Relative and Absolute

• Fixed and Variable

• Constant and Changing

Identify the type of cell reference: C$3

• Absolute cell reference

• Relative cell reference

• Dynamic cell reference

• Mixed cell reference

Tags

CCSS.HSS.ID.A.4

If cell A1 contains the formula =A1+B1, what type of cell reference is used for A1 and B1?

• Relative cell reference

• Circular cell reference

• Absolute cell reference

• Mixed cell reference

What type of cell reference is used when the row number is fixed but the column letter can change?

• Mixed row reference

• Absolute row reference

• Dynamic row reference

• Relative row reference

In the formula =A$1*B2, what type of cell reference is used for A1 and B2?

• Static and moving

• Stable and flexible

• Fixed and dynamic

• Absolute and relative

Tags

CCSS.HSS.ID.C.8

Identify the type of cell reference: D4

• Mixed

• Static

• Absolute

• Relative