Format a balance statement model
You will now create a balance statement model for the Grape Debate Wine Company. They want to format the statement using financial settings. Even though equity and liabilities are money owed, they are usually represented as positive numbers in these documents.
Each section will have a subtotal, using the sum() function, and the final total for equity and liabilities should be the total of those two sections.
Latihan ini merupakan bagian dari kursus
Pemodelan Keuangan di Google Sheets
Instruksi latihan
- Format the numerical data in Financial format (excluding the Years).
- Using the
sum()function, create subtotals inB11,B18, andB23. - Using the
sum()function, create a total for Equity and Liabilities inB25.
Latihan interaktif langsung
Ubah teori menjadi aksi dengan salah satu latihan interaktif kami
Mulai latihan