Use the chart below to answer the following two questions:
-Which of the following is a difference between relative addressing and absolute addressing when using cell formulas in Excel?
A) 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.
B) 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.
C) 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.
D) A relative address uses only the column label in the cell reference; an absolute address uses the row.

Question

Use the chart below to answer the following two questions: 
-Which of the following is a difference between relative addressing and absolute addressing when using cell formulas in Excel?
A) 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. 
B) 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. 
C) 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. 
D) A relative address uses only the column label in the cell reference; an absolute address uses the row.

Quizplus · Accepted Answer

Relative addressing in Excel references cells by their position relative to the cell containing the formula, and changes when the formula is copied to another cell. Absolute addressing, on the other hand, uses a dollar sign before the column and/or row label to keep the reference constant, regardless of where the formula is copied.

Use the Chart Below to Answer the Following Two Questions