Examlex

Solved

An Investor Is Developing a Portfolio of Stocks

question 67

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 H11 of the Excel spreadsheet? 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 H11 of the Excel spreadsheet?     A)  =SUMPRODUCT(B15:D15,G9:I9)  B)  =SUMPRODUCT(B15:D15,B4:D13)  C)  =SUMPRODUCT(B15:D15,I9)  D)  =SUMPRODUCT(B15:D15,G4:I6) 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 H11 of the Excel spreadsheet?     A)  =SUMPRODUCT(B15:D15,G9:I9)  B)  =SUMPRODUCT(B15:D15,B4:D13)  C)  =SUMPRODUCT(B15:D15,I9)  D)  =SUMPRODUCT(B15:D15,G4:I6)


Definitions:

Algebraic Expression

A mathematical phrase that can contain ordinary numbers, variables, and operation symbols but does not have an equal sign.

Distance

The numerical measure of how far apart objects or points are.

Average Speed

The overall rate of speed of a moving object, calculated as the total distance traveled divided by the total time of travel.

Algebraic Expression

A mathematical phrase that includes numbers, variables, and operation symbols but no equal sign.

Related Questions