開始使用免費開始

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.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習