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:

Bull Money Spread

An options strategy used by investors to profit from the moderate rise in the price of a stock.

Puts

Options contracts giving the holder the right, but not the obligation, to sell a specified amount of an underlying asset at a set price within a specified time.

Call Contract

A financial contract that gives the holder the right, but not the obligation, to buy a specified amount of an underlying asset at a predetermined price within a specified time period.

Put Contract

A financial agreement that grants the holder permission, but not the requirement, to sell a certain amount of an underlying asset at a predetermined price before a certain deadline.