开始使用免费开始使用

Copy sums for each year

To finish your first financial model, you will copy the formulas from the previous exercise across Years 2016-2018. This information will show the four-year income statement for the Wine Company.

You can use copy (ctrl + c) and paste (crtl + v) to copy over each formula, as Sheets automatically fills in the right cell references for you, or you can use the fill handle as shown in the slides.

本练习是课程的一部分

Google Sheets 金融建模

查看课程

练习说明

  • Select cell B8 and copy over the formula into C8, D8, and E8.
  • Repeat that process for rows 13, 17, 20, and 23.

动手互动练习

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

开始练习