Which of the Following Formulas Contains an Absolute Cell Reference

question 45

Multiple Choice

Which of the following formulas contains an absolute cell reference?

• A) =$B4
• B) =B$4
• C) =$B$4
• D) =B4

---

Definitions:

Senior Discount

A reduction in the price of goods, services, or commodities offered to elderly individuals, typically those who are 65 or older.

Indirect Price Discrimination

A pricing strategy where the price variance does not directly relate to cost differences but is based on different consumer groups' ability or willingness to pay.

Willingness To Pay

The maximum amount an individual is prepared to spend to procure a good or service, reflecting its perceived value to them.

Consumer Surplus

The disparity between the amount consumers are prepared to spend on a good or service and the actual price they incur.