Which of the Following Is a Difference Between Relative Addressing

question 31

Multiple Choice

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.

---

Definitions:

Neutral Conductors

Conductors connected to the neutral point in a circuit, carrying current only under unbalanced load conditions.

Open Circuit

A break in an electrical circuit preventing current from flowing.

DC Circuit

A circuit that has a constant direction of flow of electric current, typically using direct current (DC) as its power source.

Directly Proportional

A relationship between two variables where if one increases, the other one also increases at a constant ratio.