The Table Array

question 86

Multiple Choice

The Table Array

• A) is the argument in a VLOOKUP function that identifies from which column to return a value.
• B) looks up a value in a horizontal table where the first row contains the values to compare with the lookup value.
• C) calculates the periodic payment for a loan with a fixed interest rate and fixed term.
• D) is a range containing a lookup table.

---

Definitions:

Break-Even Cost

The amount of revenue needed to cover the total fixed and variable costs of producing and selling a product, with no profit or loss.

Demand Curve

A graph representing the relationship between the price of a good and the quantity demanded by consumers at various price levels.

Price Collusion

An illegal practice where competing companies agree on price levels rather than competing, harming consumer interests.

Price Fixing

An illegal practice where businesses agree on prices for their products or services, rather than letting competition in the marketplace determine them.