contestada

5. Nadia wants to calculate the total interest, which is the total amount of the payments minus the loan amount. In cell F6, enter a formula without using a function that multiplies 12 by the Term and the Monthly_Payment, and then subtracts the Loan_Amount to determine the total interest

Respuesta :

Answer:

= B4 - D6 * 2% * 0.5 " and press enter

Explanation:

Nadia wants to calculate the total amount of interest that she has paid. She can use excel worksheet for this purpose. Excel allows the complex calculation with just one formula input. The data displayed from the excel is accurate. Nadia should use the subtraction with multiplication function to calculate the interest paid on the loan.

[tex]B4 - D6 * 2% * 0.5 "[/tex] and then press enters Nadia wants to calculate the total amount of interest that she has paid.

Advance excel

After that She can use an Advance excel worksheet for this purpose. Then Advance Excel are allowed the complex calculation with just one formula input. The data displayed from advanced excel is accurate. After that Nadia should have been used the subtraction with multiplication function to calculate the interest paid on the loan. Thus, the total interest= [tex]B4 - D6 * 2% * 0.5 "[/tex] and also then press enter

Find out more information about Advance excel here:

https://brainly.com/question/15453012