An Investor Is Developing a Portfolio of Stocks

question 66

Multiple Choice

An investor is developing a portfolio of stocks. She has identified 3 stocks to invest in. She wants to earn at least 5% return but with minimum risk. The problem data is given in the following Excel spreadsheet. What formula should be entered in cell G4 of the Excel spreadsheet? ​

• A) =COVAR(B4:B13)
• B) =VARP(B4:B13)
• C) =COVAR(B4:D13,$D$4:$B$13)
• D) =COVAR(B4:B13,$B$4:$B$13)

---

Definitions:

IDS

Intrusion Detection System, a device or software application that monitors a network or systems for malicious activity or policy violations.

IPS

Stands for In-Plane Switching, a screen technology for liquid-crystal displays (LCDs) that offers better viewing angles and color reproduction than traditional LCDs.

Grammar

The set of rules that govern the structure of sentences in a language, including syntax, morphology, and punctuation.

Administrator Access

Refers to the highest level of access rights on a computer or network, allowing the user to make system-wide changes and access all files.