Which of the Following Will You Select as X in the Series

question 49

Multiple Choice

Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select) Range of cells > Home tab > Styles group > Conditional formatting > X > Top 10 items > Change value and highlight option in dialog box if required > OK?

• A) Icon Sets
• B) Color Scales
• C) Top/Bottom Rules
• D) Highlight Cells Rules

---

Definitions:

Market Portfolio

A theoretical bundle of investments that includes every type of asset available in the market, with each asset weighted by its total market capitalization.

Capital Asset Pricing Model (CAPM)

Equation of the Security Market Line showing the relationship between expected return and beta.

Reward To Risk Ratio

A measure that evaluates the anticipated gains from an investment against the level of risk assumed to achieve these gains.

Security Market Line

A graphical representation of the expected return of all risky marketable securities as a function of their beta, or systemic risk, according to the capital asset pricing model.