Excel tables support simple calculations and statistics. There are two ways to achieve this effect, namely product function method and multiplication function method. Let me take wps11.1.1.10 as an example to demonstrate the operation method.

Method 1: product function method

Step 1: Select any cell and enter the function =PRODUCT (cell 1, cell 2, cell 3, ...) in the edit box above. In this example, we enter function =PRODUCT(A 1, B 1) and click enter.

Step 2: You can see that the product of two cells has been displayed in the blank cell.

Method 2: Multiplication function method.

Step 1: Select any cell and enter the function = cell 1 * cell 2 * cell 3 * ... in the edit box above. In this example, we enter the function =A 1*B 1, and then click enter.

Step 2: You can see that the product of two cells has been displayed in the blank cell.

Tip: The product function used by the first method can only support the calculation of the product of 30 data values at most, while the second method does not limit the number of data.