Practical Word skills sharing: How to quickly calculate tabular data

In the previous article "Practical Word Tips Sharing: Multiple Methods to Enter Mathematical Formulas", we learned about various techniques for inputting mathematical formulas in Word. The following article will show you a super convenient formula application technique. It turns out that Word table calculations are also very simple!

When using Word to perform some simple data calculations, many people will say that it is not as convenient as Excel. Therefore, most people will first calculate the data in Excel and then convert it, which is very troublesome. In fact, you can complete the calculation directly using Word! For example, summing, averaging, etc., and you can also perform batch calculations like Excel!

So, today’s content will share with you how to quickly calculate Word table data.

1. Automatic table summing

Position the mouse insertion point in the cell where the sum is required, and click [Table Tool Layout] - [Data]-[fx Formula], open the "Formula" dialog box (here the system automatically matches a formula =SUM(LEFT), which means adding the values ​​of the cells on the left). It is exactly the formula we need, so it is not If you need to enter additional formulas, click the "OK" button directly to get the result.

Tips: =SUM(LEFT) that appears in the formula window means that all cells on the left Sum of grid numbers. In the same way, when the numbers in all the cells above are to be summed, the formula "=SUM()" is displayed as "ABOVE" in the brackets.

2. Table automatic filling

Many people believe that formulas can only be entered into cells one by one in Word tables for calculations. Actually not, it can also automatically fill in calculations quickly. There are two different ways to achieve this. Here are the introductions:

Method 1: After setting the first cell formula and getting the result, immediately select other cells. grid, press the [F4] key, the formula will automatically fill in and calculate the result.

Method 2: Copy and paste the summation result (Ctrl C, Ctrl V keys) to other cells below, then [F9] key, All cell updates will be automatically summed.

Tips: On the surface, what is copied and pasted here is data, but in fact, the formula of the cell (i.e. "field" is copied at the same time code). So when the [F9] key is pressed, the data changes automatically, that is, the domain is updated. When the quarterly data in the table changes, select the cell with the formula again and press the [F9] key to get the new summary results.

3. Calculate the average value

After understanding the above data summation method, then the calculation of the average value is very easy. Just change the formula. The function for finding the average is AVERAGE. Therefore, enter the formula

=AVERAGE(LEFT) in the "Formula" dialog box to get the result. (Note: Here the average is calculated for the data on the left, including the "Total" column data on the left).

Tip: The cells in the Word table also have row numbers and column labels. Therefore, when writing a formula, you can use the same writing method as Excel: =AVERAGE(b2:d2), that is, find the average value of the data in cells b2 to d2 in the table.

Recommended tutorial: "

Word Tutorial"

The above is the detailed content of Practical Word skills sharing: How to quickly calculate tabular data. For more information, please follow other related articles on the PHP Chinese website!