Word 2007 Table Simple calculation and number format conversion

In Word 2007, we can easily make some simple calculations of the data in the table and convert the data into the format we need.

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.

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.

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.

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.

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.

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.

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.

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.