How to automatically generate Excel table product: first open the table, click on a cell as the position of the final output product; then enter the "=A1*B1" formula after "f(x)" and press Press enter; finally, put the mouse on the lower right corner of the cell of the first result and a bold " " will appear, and just pull down.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Related learning recommendations: excel basic tutorial

How to automatically generate excel table multiplication:

1. Open Excel Table, click on a cell as the final output product position, then enter "=A1*B1" after "f(x)", that is, multiply the data of the cells where A1 and B1 are located, and finally press "Enter" to output Answer.

Rendering:

2. Place the mouse on the lower right corner of the cell of the first result. Bold " ", just pull down to see the product results of other data.

Effect (copying a cell means copying the function formula, and other data is calculated according to this formula):

The above is the detailed content of How to automatically generate excel table quadrature. For more information, please follow other related articles on the PHP Chinese website!