Word 2007: Table formula calculation and output corresponding format

As we all know, in Excel tables, we can calculate various formulas for the input data. The table we inserted in Word 2007 also makes it easy to do some simple calculations on the data in the table and converts the data into the desired format.

First, data calculation

Take the table shown in Figure 1 as an example, we need to calculate the sum of each person and the average per quarter.

Figure 1 Average

First position the mouse over the second row at the Sixth column intersection (that is, the F2 cell), where the Table Tools toolbar is added to the ribbon, and the design and Layout tabs are added below it. Click the formula button in the Data feature group on the Layout tab, as shown in Figure 2.

Figure 2 Layout

In the Formula dialog box that opens, confirm that the formula in the Formula input field is =sum (left), as shown in Figure 3, and then you can get the total value of the John.

Figure 3 Formula

The total number of other people is the same.

As for the average of the quarterly, we can first position the mouse at the intersection of the second column at line sixth (that is, the B6 cell). The Formula dialog box is still open in the above method, and the formula in the Formula input column should be "=sum (ABOVE)", and we can remove anything except the equals sign in the formula. Then click the Paste Function Drop-down button below, select AVERAGE in the Drop-down list, and then fill in the parentheses after AVERAGE in the formula column, as shown in Figure 4. Once we're sure, we can get the average we need.

Figure 4 Formula

Second, format conversion

As for format conversion, some simple requirements can be implemented in the Formula dialog box. For example, when you click the mouse in C6 cell and open the Formula dialog box, modify the formula, and then click the number Format Drop-down button in the dialog box, we can select the number format in the Drop-down list, and we'll see how it's done, as shown in Figure 5.

Figure 5 Numbering format

If you want to complete the calculated number in Chinese capital format, you can copy the number, paste it in the corresponding cell, position the mouse over the Paste Options smart tag that appears, and then click the small triangle that appears to the right, and select the "Keep Text only" option in the pop-up menu, as shown in Figure 6. We can also use "paste selective" to complete.

Figure 6 Preserving text

Now select the pasted data and click the Numbering button in the symbol feature group of the Ribbon Insert tab to open the Numbering dialog box. Select the Chinese capitalization format in the number Type list, and then you'll get the results you want, as shown in Figure 7.

Figure 7 Number

Well, if we're just going to do a simple calculation of the data in the table or a simple format conversion, it's OK to rely on Word 2007 alone.

In the Word 2007 document table for simple data calculation and conversion to the format we want, the operation is very simple, similar to Excel, in the formula box, modify the corresponding formula, and select the appropriate number format, you can output the corresponding format.