question 10

help needed

In Excel, the worksheet needs to be prepared prior to running the Solver. As such, the total (total return), cell G8, shows the total of the expected return for approved projects. What is the formula that must be set in G8 to capture the results accurately? \begin{tabular}{|l|l|r|r|r|r|r|r|} \hline & \multicolumn{1}{|c|}{ A } & \multicolumn{1}{c}{ B } & \multicolumn{1}{c|}{ C } & \multicolumn{1}{c|}{ D } & \multicolumn{1}{c|}{ E } & \multicolumn{1}{c|}{ F } & G \\ \hline 1 & Cash Investment & Project 1 & Project 2 & Project 3 & Project 4 & Cash Spent & Cash Available \\ \hline 2 & Year 1 & 50 & 45 & 30 & 40 & 85 & 90 \\ \hline 3 & Year 2 & 10 & 10 & 10 & 10 & 20 & 50 \\ \hline 4 & Year 3 & 10 & 10 & 10 & 10 & 20 & 50 \\ \hline 5 & Year 4 & 0 & 10 & 0 & 10 & 20 & 50 \\ \hline \end{tabular} 6 7 \begin{tabular}{|l|r|r|r|r|r|} \hline Expected Return & 350 & 400 & 385 & 450 & Total 850 \\ \hline \end{tabular} 10 Funding (1=yes, 0= No) \begin{tabular}{|r|r|r|r|} \hline 0 & 1 & 0 & 1 \\ \hline \end{tabular} Multiple Choice =SUMPRODUCT(B8:E8,G2:G5) =SUM(B8:E8 * B10:E10) =SUMPRODUCT(B8:E8, B10:E10) =SUMPRODUCT(B8:E8 * B10:E10)