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)

Question

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)

Quizplus · Accepted Answer

The Answer of 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