WHAT IS THE ACTUAL FORMULA FOR F6 WHICH CAN CAN BE COPIED AND PASTED INTO BOTH G6 AND F7

55.10 Calculate the number of clients 55.11 Calculate the Ioan principal 55.12 Calculate the average income levels for each client by credit rating. a. In cell F10, use the AVERAGEIF function to calculate the average income for those who have a Fair credit rating. b. Reference the cells in the "Credit Rating" and "Income" columns of the Client Data table to calculate it. c. Use copy and paste to fill the Average Income for clients with other ratings as well as the rest of the table (Average Monthly PMT, Average PMT/Income Ratio, and Average FICO Score for all different credit ratings). d. Note: Your formula must use absolute references that allow the formula in F10 to be copied and pasted to other cells in the "Average Income," "Average Monthly PMT," "Average PMT/Income Ratio," and "Average FICO Score" columns. Mytducator lasks 55.8) (Caiculatc income averages by loan slalus. a. In cell ( F6 ), use the AVERAGEIF function to calculate the average income for those who defaulted. b. Reference cell (CG) as criteria in the AVRAGI IIF function. c. Use copy and paste to flll the Average income of non Lle[dult Llients in cell 'F7] as well as the rest of the table (Average Monthly PMT. Average Ratio, and Average FICO Score for both default and non default). d. Note: Your formula must use ahsolute referencesthar allow the formula in (E-6) to be copied and pasted to uller cells in lhe "Aver dye Income," "Average Monthly MT," "Average FMT/come Ratio," and "Average FICO Score" columns