How to use the excel table formula? Excel formula usage skills

1. The simplest thing is that excel uses formulas for sum, average, and product. Let's make a product of data and try a formula at the same time.

2. We have prepared a set of arrays, as shown in the figure. Click the formula icon.

3. "sum, average, count, maximum, and minimum" is displayed in the pop-up menu. Here we click "other functions"

4. Then we will use the product function on the pop-up function insertion page. Here we will search for the product ".

5. Click search and we will find the product function, as shown in the following figure. Click "OK"

6. Now we start to calculate the product of the first group of data. Select the group of data we just selected with the mouse. After the selection, the group of data will be surrounded by dotted lines, and this group of data will be displayed in the function parameter box. At the same time, there will be a calculation result at the bottom, as shown in the figure.

7. After the product of the first group of data is calculated, calculate the product of the second group of data. Click the button on the right of number2 on the function parameter page, as shown in the figure, click this button to select another group of data.

8. As shown in the following figure, the function parameter settings page on the right will become smaller when you select this set of data. This array is also displayed on the function parameter settings page, now the product of the two groups of data is calculated. Click OK to calculate the product of the two sets of data. As shown in the figure.

9. After clicking "OK", the product of the two groups of data is displayed in the cell. Because the data I demonstrated is too large, the product cannot be fully displayed. Of course, if it is the data we usually use, we can completely display the product.