Which of the Following Is an Example of a Conditional

question 36

Multiple Choice

Which of the following is an example of a conditional aggregate function?

• A)=IF(AND(C7>B3, D8<=5),"PAY","NO PAY")
• B)=IF(OR(C7>B3, D8<=5),"PAY","NO PAY")
• C)=IF(NOT(C7>B3),"PAY","NO PAY")
• D)=IF((SUM(A1:A7)>7),"PAY","NO PAY")

---

Definitions:

Exchange

Exchange signifies a platform or system where various entities trade commodities, securities, currency, and other instruments.

Future

A financial contract obligating the buyer to purchase, or the seller to sell, a particular asset at a predetermined future date and price.

Put Option

A financial contract that gives the holder the right, but not the obligation, to sell a stated amount of an underlying security at a specified price within a specified time.

Sell An Asset

The act of disposing of a property or other investment in exchange for money or other assets.