Specifications

Computer Tutorial 3 Lesson 6  13
EXHIBIT 6-10
Current asset section of balance sheet
9. Now you will combine accounts in the current liabilities section. You will combine all
the employee deduction accounts into one line, and all the tax payable accounts into one
line. Place your cursor on line 35 and click Insert Rows. Do this twice more so you have
created three blank rows below Row 34.
10. Type 2000:2100 in cell A34 (overwriting the “%%”).
11. Type 2110:2350 in cell A35, T in cell D35, Employee deductions payable in F35, and
“\-” in G35.
12. Type 2400:2480 in cell A36, T in cell D36, Taxes payable in F36 and “\-” in G36.
13. Type 2500 in cell A37, “\” in F37 and “\-” in G37.
14. Click cell G38 and change the formula to sum cells G34 to G37 to include the three
rows you created.
15. Click FR, FR View. Ensure the Year/Period is 2010-12, then click OK. The report will
generate. The current liabilities section of your balance sheet should appear as Exhibit 6-
11. If it does, click File Save. If it does not, close the file without saving and repeat steps
9 to 14.
EXHIBIT 6-11
Current liabilities section of balance sheet