Renuncia de responsabilidad: El siguiente video se tradujo mediante un software de traducción y se dobló con una voz artificial para tu comodidad, todo ello de forma automática. Si deseas obtener más detalles, consulta la renuncia de responsabilidad completa.

Transcript

Instructions

  1. Add a prospective car buyer and estimated price range to your spreadsheet.
  2. Create columns for "Loan Amount" and "Monthly Payment" to create a table below the frozen rows.
  3. Enter a range of potential loans, increasing incrementally.
  4. Calculate the monthly payment for each loan amount using the PMT function.
  5. Make the monthly APR and loan term references absolute instead of relative cell references.
  6. Copy the function to the rest of your spreadsheet.
Attributions
  • "File:Wrapped Porsche 918 Spyder.jpg" by Axion23 (https://commons.wikimedia.org/wiki/File:Wrapped_Porsche_918_Spyder.jpg) -- Licensed by CC BY 2.0 (https://creativecommons.org/licenses/by/2.0/deed.en) -- Image scaled up, cropping edges
  • "New Car" by Caitlin Regan (https://www.flickr.com/photos/caitlinator/3673390863) -- Licensed by CC BY 2.0 (https://creativecommons.org/licenses/by/2.0/) -- Image scaled up, cropping edges
namespaces/google.engedu.apski/contents/Activity-74265891230407816693157650910170544914en