Understanding Cell References in Excel

What is a relative cell reference in Excel?

• A reference that always points to a specific cell, regardless of where it is copied.

• A reference that changes when the formula is copied to another cell.

• A reference that combines both absolute and relative references.

• A reference that is used only in charts.

Which of the following is an example of an absolute cell reference?

• A1

• A$1

• $A1

What is a mixed cell reference?

• A reference that changes both row and column when copied.

• A reference that keeps either the row or the column constant.

• A reference that is used only in conditional formatting.

• A reference that is used only in data validation.

How would you write a formula to add cells A1 and B1 using relative references?

• =A1+B1

• =$A1+B1

If you copy the formula =A1+B1 from cell C1 to cell D1, what will the formula become?

• =A1+B1

• =B1+C1

• =D1+E1

• =B1+C1

What happens to an absolute cell reference when you copy it to another cell?

• It changes based on the new location.

• It remains the same.

• It becomes a mixed reference.

• It becomes a relative reference.

Which of the following is an example of a mixed cell reference?

• A1

• A$1

• $A1

How do you make a cell reference absolute in Excel?

• By adding a dollar sign ($) before the column letter and row number.

• By adding a hash (#) before the column letter and row number.

• By adding an asterisk (*) before the column letter and row number.

• By adding an ampersand (&) before the column letter and row number.

• =A1+B1

• A$1

• $B2

• None