The Value in Cell B2 Cell Is 65

question 193

Multiple Choice

The value in cell B2 cell is 65.In cell C2, the value is 75.Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

• A) =IF(B2>=70, C2>=80)
• B) =OR(B2>=70, C2>=80)
• C) =AND(B2>=70, C2>=80)
• D) =NOT(OR(B2>=70, C2>=80))

---

Definitions:

Payback Period

The amount of time it takes for an investment to generate an amount of income or cash flow equal to the cost of the investment.

Useful Life

The expected period over which an asset is estimated to be economically usable by one or more users, often influencing depreciation calculations.

Simple Rate Of Return

A method to evaluate the profitability of an investment, calculated by dividing the incremental annual income by the initial investment cost.

Sales Revenues

The income generated from the sale of goods or services before any costs or expenses are deducted.