Assignment #4
(30 points)
 Watch the video
PMT Function (Google Sheets)
(CC).
 Create a Google Sheets spreadsheet similar to the document
developed in the video and shown below.
(Data).
Formulas must be created for those cells highlighted in red circles.
In particular, formulas must be created for:
Monthly Payments, Total Purchase Cost,
Total Interest Cost, Lowest Priced Golf Cart,
Highest Priced Golf Cart,
and Average Price of Golf Cart.
Insert your name somewhere in the document.
 Explore the tutorial Using Excel PMT Function
to Calculate Loan Payment Amount.
Convince the instructor that you understand the key concepts in this tutorial by including
one or more of the following:
a summary of the tutorial, modified formulas similar to those covered in the tutorial,
details, examples, charts, tips you learned, etc.
Add this information (in a separate tab) to the document
created in the previous step.
 Save your work as "assignment4". Share this document
with your instructor: rosener@nsuok.edu.
 Create a link to this document on YOURCLASSWEBSITE.
Help
