Download
Download Presentation
Add the Values in C10 and M12

Add the Values in C10 and M12

Télécharger la présentation

Add the Values in C10 and M12

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

1. Add the Values in C10 and M12 =C10+M12

2. Subtract the Value in B5 from the Value in C7 and then Divide by 3 =(C7-B5)/3

3. Round B5 to the nearest thousanth =ROUND(B5,3)

4. Determine the Square Root of 466 =SQRT(466)

5. Determine the Future Value of an account at the end of 5 years after making \$400 monthly payments at a return of 8% =FV(.08/12,5*12,400) (rate,# of payments,amount)

6. Determine the Present Value of a college fund where you make 25 yearly payments of \$4,000 at 13%. =PV(.13,25,4000)

7. Calculate the monthly paymenton a 30 year loan of \$75,000 at6% interest. =PMT(.06/12,30*12,75000)

8. Determine the Smallest Cell Value in B3:B20 =MIN(B3:B20)

9. Determine the Average of cell range E7:E19 =AVERAGE(E7:E19)

10. Determine the number of cells in the range C5:C154 =COUNT(C5:C154)

11. Determine the monthly car payment for a \$8000 loan for 3 ½ year at 8% APR. =PMT(.08/12,3.5*12,8000)

12. Subtract the value in B6 from the value in A6, then divide by 2 =(A6-B6)/2

13. Rasies the value in A3 to the 3rd power, then divides the result by the value in A4 =A3^3/A4

14. Divides 100 by the value in C4, then multiplies the result by the value in C3 =100/C4*C3