Western Governors University (WGU) BUIT2200 C268 Spreadsheets Practice Exam

The correct choice for summing up the total interest paid in cell G13 is found in the option that indicates calculating the sum of all interest paid in the "Interest" column of the amortization table. This method accurately reflects the total interest that accrues over the entire loan period as outlined in the amortization schedule.

In an amortization table, each payment is usually broken down into principal and interest components. By summing the individual entries in the "Interest" column, one obtains the complete picture of how much interest has been paid throughout the duration of the loan. This is an essential calculation for borrowers looking to understand the total cost of borrowing and the impact of interest rates on overall expenses.

The other options do not specifically capture the total interest paid. While averaging payments, calculating total payments over the loan term, or finding the difference between total payments and principal could provide useful financial insights, they do not directly represent the total interest specifically incurred during the loan period in the manner that summing the interest column does.