WPS Table Application Tutorial

The first section establishes and uses the WPS form

The WPS Office 2007 Office software provides a component called the WPS table, a utility that is used to establish and use electronic reports to apply data records in tabular form.

Start language: The WPS table is part of the WPS Office 2007 software. When you run it by starting Windows application, the screen displays its action window and opens an electronic report called BOOK1 (Workbook 1), but there is nothing but waiting for you to build it, and this tutorial begins.

Figure 1 The Operation window into the WPS table

Note: Workbooks are files that process and store data in the WPS table, and each workbook can contain more than one worksheet, so you can manage multiple types of related information in a single file; Worksheet is an area that is displayed on the screen, consisting of a table, as shown in Figure 1. This area is called a "worksheet area" where various data will be entered for display.

Step one, see Figure 2, click A1 Cell.

The WPS Table Operation window consists of a title bar, a drop-down menu, a toolbar, a status bar, and so on. Underneath the toolbar is the worksheet area where you build the spreadsheet, which provides a series of cells, each cell has a name, and when you move the cursor inside the cell, the status changes to a cross, see Figure 2. A, B, C, D ... labeled below the toolbar. Used to indicate each column in the table, respectively, the numbers on the left edge of the table indicate each row, and the column and line numbers determine the position of a cell, such as A1 represents the first row of cells in column A, C3, which represents the third row of cells in column C. In the WPS Table Operation window, the number of cells provided is very large, but all applications will be rare, usually with only a fraction of it, or even a small portion.

Figure 2 Click A1 cell

Note: The worksheet area is composed of a worksheet, its cells, gridlines, row number column labels, scroll bars, and Sheet tabs. "Column label" is the gray letter above each column, and line number is the gray numbered area to the left of each row.

Figure 3

Enter "Name" Step two here, enter "name", see Figure 3. In a spreadsheet, "column" is equivalent to "field" in the database, "row" is equivalent to "record", and the name you enter here becomes a new field.

Figure 4

Triple Recommendation: Click for free Download the latest version of WPS Office software "to see more computer tutorials

The contents of the first row of columns step three, click the right ARROW key on the keyboard, and then enter age, and then in the two columns on the right side, enter the title, the amount of pay, and see Figure 4.

Use the left, right, top, and bottom arrow keys on your keyboard to move the cursor to each cell, which selects the current cell, allowing you to enter text information in each cell.

Step four, see Figure 5, move the mouse click A2 cell, and then refer to the above, enter the contents of other cells, the results see Figure 6.

Figure 5 Click A2 cell

Figure 6 Compiling this "Employee Payroll"

Once this is done, the employee payroll is prepared, as shown in Figure 6. In this spreadsheet, the number of employees involved is limited, but the basic method of operation is explained. If you are a school leader, you can now make the "Employee payroll", but that's not enough, you can get more, such as statistical attendance, workload, and so on. Incidentally, there will be no problem if you want to use this software for financial work.

Note: The WPS table closes the current action window without automatically saving the results of the operation, so you must first perform the Save command in the file Drop-down menu before you can close it.