If Cell G7 Contains the Function , It States That

question 22

Multiple Choice

If cell G7 contains the function , it states that if the value in cell C3 is 9, the number 7 will be assigned to cell G7; if the value in cell C3 is not 9, the number 4 will be assigned to cell G7.

• A) =IFG7=9)G7=7)=ORG7=4)
• B) =IFG7=7)=THENC3=9)=ORC3=4)
• C) =IFC3=9)C3=7)=ORC3=4)
• D) =IFC3=9,7,4)

---

Definitions:

Ordinary Annuity

A series of equal payments made at equal intervals of time, with the payments occurring at the end of each period.

Present Value Factors

The factors used to calculate the present value of a future amount of money or stream of cash flows, given a specific discount rate.

Long-term Lease Obligation

A financial commitment that involves leasing an asset for a long-term period, noted on the balance sheet as a liability.

Capital Lease

A Capital Lease is a lease agreement that has the characteristics of a purchase agreement for accounting purposes.