Which of the Following Is a Nested Function

question 4

Multiple Choice

Which of the following is a nested function?

• A)=IF(AND(B7>5),"Yes","No")
• B)=SUM(B6:B10)
• C)=VLOOKUP(B8,A10:B20,2)
• D)=HLOOKUP(B8,A10:B20,2)

---

Definitions:

Prosperity Phase

A period of economic growth and expansion, marked by high levels of production, employment, and consumer confidence.

Business Cycle

The fluctuation in economic activity that an economy experiences over a period of time.

Disinflation

A reduction in the rate of inflation, indicating a slowdown in the rate at which prices for goods and services rise.

CPI

A gauge called the Consumer Price Index tracks the overall cost of a varied mix of consumer items and services like food, healthcare, and transport, by measuring their weighted average prices.