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.
Latihan ini merupakan bagian dari kursus
Pemodelan Keuangan di Google Sheets
Instruksi latihan
- Select cell
B8and copy over the formula intoC8,D8, andE8. - Repeat that process for rows
13,17,20, and23.
Latihan interaktif langsung
Ubah teori menjadi aksi dengan salah satu latihan interaktif kami
Mulai latihan