Specifications

12  Lesson 6 Computer Tutorial 3
EXHIBIT 6-9
Sample Company Limited balance sheet
3. You will make changes to the current asset section of the balance sheet first. You will
combine all the Bank accounts into one line, and all the prepaid accounts into one line.
Place your cursor on line 17 and click Insert Rows. Do this again so you have created
two blank rows below Row 16.
4. Type 1000:1060 in cell A16 (overwriting the “%%”), T in cell D16, and Cash in cell
F16 (overwriting the “\”).
5. Type 1100:1340 in cell A17, “\” in cell F17, and “\” in G17.
6. Type 1400:1440 in cell A18, T in cell D18, Prepaids in F18 and “\” in G18.
7. Click cell G19 and change the formula to sum cells G16 to G18 to include the two rows
you created.
8. Click FR, FR View. Ensure the Year/Period is 2010-12, then click OK. The report will
generate. The current asset section of your balance sheet should appear as Exhibit 6-10.
If it does, click File Save. If it does not, close the file without saving and repeat the
previous steps.