Download
add the values in c10 and m12 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Add the Values in C10 and M12 PowerPoint Presentation
Download Presentation
Add the Values in C10 and M12

Add the Values in C10 and M12

76 Vues Download Presentation
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 A11 from the value in B16 =B16-A11

  3. Multiply the value in A7 by the value in D10 =A7*D10

  4. Raise the Value in B10 to the 5th power =B10^5

  5. Divide the Value in A14 by 3 =A14/3

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

  7. Add the values in E17 and A14 and then multiply by 10 =(E17+A14)*10

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

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

  10. Determine the Largest value in cell range B3 to B20 =MAX(B3:B20)

  11. 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)

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

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

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

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

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

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

  18. Divide the value in A6 by 2, then subtract the value in B6 =A6/2-B6

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

  20. Add the values in A3 and A4, then multiply the sum by 3 =(A3+A4)*3

  21. Determine the product of C5 and C6 and then add 50 =C5*C6+50

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

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