Assignment #20
(10 points)

  1. Watch Video #7 - "Microsoft Excel: Working with Formulas (Monthly Payment)" at one of the following URLs:
    http://www.billrosener.com/teaching/videos/office/2013/excel/ - MS Excel 2013
    http://www.billrosener.com/teaching/videos/office/2010/excel/ - MS Excel 2010

  2. Create a Microsoft Excel document similar to the document developed in the video and shown below. Formulas must be created for Monthly Payment, Number of temperatures above 90, Number of entries.



  3. Insert your name somewhere in the document.

  4. Save your work as "assignment20.xls" or "assignment20.xlsx" when you are finished.

  5. Upload this file to YOUR-CLASS-WEBSITE.   Help



Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
1. Document contains row headers, column headers, and data. Document uses borders and possibly shading to enhance the visual impact. 3 0 2 3 __/3
2. Document uses formulas to compute: Monthly Payment, Number of temperatures above 90, Number of entries. 7 0 4 7 __/7
Total points __/10