开始使用免费开始使用

Finish and visualize

You should finish your retirement model by copying the formula you just created to the rest of the table for retirement savings. By using the partial and complete absolute references in the previous exercise, you can simply copy and paste them into all the cells.

Last, visualize the difference more years of savings makes on the monthly payment by including a chart.

本练习是课程的一部分

Google Sheets 金融建模

查看课程

练习说明

  • Copy the formula in B9 into the cells B9:G16 to complete the table.
  • Insert a line graph by clicking on cell A18, then highlighing A7:G16, clicking on insert, and then chart.
  • Be sure to change the chart to a line chart!

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习