Chapter 1, Problem 1.8CP

In cell G10, insert a formula using the PMT function using the monthly interest rate (cell G6), the loan period in months (cell G8), and the loan amount (cell G4) to calculate the monthly payment for the 10 Years scenario.

In cell B12, create a nested formula using the AVERAGE and ROUND functions to first find the average number of clothing sets sold in January (the range B6:B9), and then round the answer to 0 digits. Copy the formula from cell B12 to the range C12:N12.

10 If the Year of Hire is 2003, insert the value from cell M2, If the Year of Hire is 1996, insert the value from cell M3, If the Year of Hire is 1984 insert the value from cell M4, otherwise insert the value from cell M5. (Use absolute cell referencing where necessary).