1. To calculate the average of numben in this table, we used the function, Select one: - a.RAND(AI:A6) - b.If(RAND =0.A1A6) - esum(AI:A6)6 - d. COUNTIF(AI:A6,0) II. The result obtained for this function is 0 =2 4 - 6 III. You invested 5000 in year 2 and 10000 in year 10 , what would be the present value, if the interest rate is 3.45% ? PV=$8,325.48PV=$11,795.59PV=$12,613.91PV=$7,325.48 IV. You take a loan from a bank to buy a car with a value of 100000 for 10 years (120 months). You pay 20000 at the beginning and 10000 at the end. If the monthly interest rate is 0.8%. How much is the monthly installment? A=$1,821.43A=$2,821.43A=$1,119.57A=$989.62 V. You invested 10000 per year from year 1 to year 10 at the stock market, if the expected yearly rate of return is 5%. How much you would have at the end of year 10 ? Select one: -a $125,778 -b. $177,494 c. $79,179 -d. $155,780