How to automatically calculate multiplication in a table

The method of automatic multiplication in table setting is as follows:

Tools/materials: Lenovo Tianyi 5 10S computer, Windows 10 system, Excel149310/32 version.

1. After entering the excel table interface, select a blank cell and click the formula tab.

2. Click the first insert function button, click the category selection drop-down menu, and select the math and trigonometric functions.

3. Find and click the product function inside, and click the OK button below.

4. Select the data to be calculated in the function box, and then click OK.

5. Enter the excel spreadsheet interface and enter the equal sign in the blank cell.

6. Select the first data cell to calculate the product, and then enter an asterisk.

7. Select the second data unit to be calculated and press Enter to get the calculation result.