Please show formulas,

Q3 ( 2 point +1 bonus point): Use the following table to answer the questions below the table The formula in C14 is -PMT(B14/12, C13, F9). The PMT(interest rate, number of payments, loan amount) formula calculates the monthly payments required for a loan. (Note that B14 is divided by 12 in the formula in order to convert the annual interest rate to a monthly rate). Q3a (1 point): Adjust the relative and absolute addressing on B14, C13, and F9 directly in the formula in C14 so that it can be filled down and to the right, while still correctly referring to the interest rate, loan term, and loan amount appropriate to that row and column. Then fill out the rest of the table by using fill down and fill right to copy the formula in C14 to the rest of the table. Q3b (1 point): Use index function and match functions to build a monthly payment lookup tool in cell I15 for the Annual Interest Rate in cell I13 and the Loan Term in cell I14. Q3c (bonus 1 point): Build the same lookup tool as Q3b, but use vlookup and match functions instead. 24 ( 2 point): Use the following table to answer the questions below the table