Specifications

Computer Tutorial 3 Lesson 6  15
cell to show a leading dollar sign by clicking Format Cells. Click the number tab, and
choose Accounting as the category. Choose $ as the symbol. Click OK.
11. In cell A10, enter 3300, the account number for Dividends.
12. In cell F10, enter Dividends.
13. In cell G10, enter the formula =FRAMTA("BALP"). This formula enters the ending
balance for the current period. Format the cell appropriately.
14. In cell A11, enter %%, the wild card for all accounts.
15. In cell B11, enter the formula ="ACCTGRPID >= ""Revenue""". This formula limits
the wild card in cell A11 to only those accounts whose account group is greater or equal
to Revenue. This will select all revenue and expense accounts. Format the cell
appropriately.
16. In cell D11, enter T. This will total the amounts and report them on one line.
17. In cell F11, enter Profit (loss) for period.
18. In cell G11, enter the formula =-FRAMTA("BALP"). This formula enters the balance
from the end of the current period and reports the amount as a positive number.
19. In cell F13, enter Retained Earnings end of year.
20. In cell G13, enter the formula =SUM(G8:G11). This will total the amounts on your
statement. Format the cell to show a dollar sign as described previously. Add a border by
clicking the drop-down arrow next to the Borders icon on the toolbar. Select the single
line on top of the cell, double line at the bottom option.
21. Click File Save. Your specification file should look like Exhibit 6-12. Exhibit 6-13 shows
the same specification file, except the spreadsheet has been changed to show the formulas
for your benefit. In order to show all the formulas, some column widths have been
reduced.
EXHIBIT 6-12
Completed specification file