Question

weighted average spreadsheet setup
mendell reviews his financing options and decides to adjust the amounts
borrowed. he now takes $15,000 from the dealership at an interest rate of
4.5% and $10,000 from a personal line of credit at an interest rate of 5.5%.
mendell inputs his loan details into a spreadsheet to calculate the weighted
average interest rate.
what formula should you enter in cell d4 to correctly sum the weighted
products for calculating the weighted average interest rate?
=sum(b2:c3)
=sum(b2:b3)*sum(c2:c3)
=sum(d2:d3)
=d2+d3

Explanation:

Step1: Analyze formula requirements

The problem is to sum the weighted products. The weighted products are calculated in cells D2 and D3.

Step2: Evaluate each formula option

• =SUM(B2:C3) sums values in columns B and C (amounts and interest rates), not weighted products.
• =SUM(B2:B3)*SUM(C2:C3) multiplies sums of amounts and interest rates, not correct for weighted product sum.
• =SUM(D2:D3) correctly sums the weighted products (since D2 and D3 are the weighted product cells).
• =D2 + D3 also sums the weighted products but SUM(D2:D3) is a more standard spreadsheet - style for summing a range.

Answer:

C. =SUM(D2:D3)，D. =D2 + D3