Stella is a bank executive. she is preparing a spreadsheet on the loan repayment schedules of customers. which function can she use to calculate the periodic payments? a. what-if analysis b. pmt c. regression analysis d. min

The answer is B: PMT

Stella will use the PMT function to calculate the payment for a loan that has constant interest rate and payments. This function is a financial function that can be used to calculate the monthly payment due on a personal loan. The syntax for PMT is =PMT (rate, nper, pv, [fv], [type])

b. xor is the correct answer

solution:

the right option is a

to adding   a new row to a table we   have to do process last table cell and pressing tab.

this is the process to add new row in the cell:

* to add a row below the cell, click insert below in the rows and columns group.

thus this is the required right answer.