Use the Chart Below to Answer the Following Two Questions

question 20

Multiple Choice

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.

---

Definitions:

Variable Costs

Expenses that vary directly with the level of production or sales volume, such as materials and labor.

Fixed Costs

Costs that do not change with the level of production or sales, such as rent, salaries, and insurance.

Unit Contribution Margin

The difference between the selling price per unit and the variable cost per unit, indicating how much each unit sold contributes to fixed costs and profit.

Variable Costs

Expenses that fluctuate directly with the volume of production or sales, such as raw materials and direct labor costs.