If Cell B7 Contains a Value That Is Greater Than

question 76

Multiple Choice

If cell B7 contains a value that is greater than 20,and "ORDER" will be displayed when the logical test is TRUE,which of the following contains the correct IF function syntax?

• A)=IF(B7<20, "ORDER", "OK")
• B)=IF(B7<20, "OK", "ORDER")
• C)=IF(B7>20, "ORDER", "OK")
• D)=IF(B7>20, "OK", "ORDER")

---

Definitions:

Risk-Adjusted Returns

Performance measurement that evaluates the return gained from an investment relative to the risk taken, often calculated using measures such as the Sharpe ratio.

Small Firms

Companies with a relatively small market capitalization.

Large Firms

Corporations or companies that have a significant market capitalization, extensive operations, and a widespread influence in their industries.

Market Efficiency

A concept stating that all available information is already reflected in asset prices, making it impossible to consistently achieve higher returns without assuming additional risk.