시작하기무료로 시작하기

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로 하는 Financial Modeling

강의 보기

연습 안내

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

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작