The ____ Function Ignores Blank Cells and Text

question 101

Multiple Choice

The ____ function ignores blank cells and text.

• A) AVERAGE
• B) COUNT
• C) COUNTA
• D) both a and b

---

Definitions:

Car Dealership

A business that sells new or used cars at the retail level, typically based on a dealership contract with an automaker or its sales subsidiary.

Asymmetric Information

A situation where one party in a transaction has more or superior information compared to another, potentially leading to an imbalance in decision-making, similar to adverse selection.

Adverse Selection

A situation in which asymmetrical information leads to the selection of suboptimal market participants, often seen in insurance markets where those most likely to make a claim are also most likely to seek insurance.

Market Signals

Information or indicators that suggest the future direction of market prices, helping investors and businesses make decisions.