Step 1: Open the excel table of the product you want.

Step 2: Select the cell where you want to put the quadrature data, and find "Math and Trigonometric Function" in the "Formula" option in the menu bar.

Step 3: Select the function "product" in "Mathematics and trigonometric function".

The PRODUCT function is used to calculate the product of multiple numbers.

Step 4: Drag the mouse directly to select the required product quantity, and then click OK.

Step 5: Place the cursor in the circled position in the figure and drag it directly to complete the quadrature operation.

Method 2: How to quadrature in excel tables-

Step 1: Select the cell where you want to put orthogonal data, and enter "=".

Step 2: Select the cell where a number is located, then enter "*", then select the cell where another number is located, and click Enter. The multiplication symbol "*" simultaneously presses shift and the number 8.

Complete the quadrature of a cell.

According to the above method, drag the mouse to complete all data quadrature.