Which of the following is a difference between relative addressing and absolute

Question

Which of the following is a difference between relative addressing and absolute addressing when using cell formulas in Excel?

A. A relative address uses just the row and column label in the cell reference; an absolute address uses a dollar sign before either the row or column label.

B. A relative address uses a dollar sign before either the row or column label; an absolute address uses the ampersand symbol before either the row or column label.

C. A relative address uses a dollar sign before either the row or column label; an absolute address uses just the row and column label in the cell reference.

D. A relative address uses only the column label in the cell reference; an absolute address uses the row label.

Explanation / Answer

Answer: A) A relative address uses just the row and column label in the cell reference; an absolute address uses a dollar sign before either the row or column label.

Absolute Reference:

An absolute reference in Excel is a cell address with the dollar sign ($) in the row or column label, like $A$1.

Using $ in cell references allows you to copy the formula in Excel without changing references.

Relative Reference :

A relative reference in Excel is a cell address without the $ sign in the row and column label, like A1.

When a formula with relative cell references in copied to another cell, the reference changes based on a relative position of rows and columns.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.