Preparation of Statements and Three Column Accounts With Electronic Spreadsheets

1. The actual spreadsheet is a paper column that has multiple columns and rows in the standard grid form for the presentation of accounting information.

2. With the development of new technologies, computer screens have been used to the paper space and are known as electronic spreadsheets. Electronic spreadsheets are found to be better and more efficient as they solve problems involving numbers and formulas.

3. Now on the market, there are various types of electronic spreadsheet software suitable for accounting processing work. Among them are Lotus 1-2-3, Multiplex, Excel, and Symphony and so on. However, most electronic sheeting software has the same functionality. For further discussion purposes, the Lotus 1-2-3 electronic spreadsheet software will be used.

4. Examples of Lotus 1-2-3 electronic spreadsheets are indicated as shown below. The basic components of an electronic spreadsheet are cells, columns, rows, data, and formulas.

5. The Lotus 1-2-3 electronic spreadsheet contains 52,400 cells. Each cell can store information in the form of text, numbers or formulas. The cell address indicates the cell in the spreadsheet. Example: E5 indicates cell in column E and line 5.

6. Columns are marked with alphabet letters A, B, C …

7. The line is marked with numbers 1, 2, 3 … from top to bottom and can be changed altitude.

8. Data consists of two forms, ie labels, and values. Labels are titles used and can be numerically or alphabetically. Whereas the value is the number that is entered into the spreadsheet.

9. The formula can be used for value calculation. The formula is shown at the top of the sheet and does not appear in the cell.

10. Three-row statements and accounts preparation procedures with spreadsheet spreads the following three steps:

a) Step 1: Providing Skeletons
b) Step 2: Key in data
c) Step 3: Calculates data using formula