Home >Topics >excel >How to automatically generate excel table quadrature

How to automatically generate excel table quadrature

coldplay.xixi
coldplay.xixiOriginal
2021-01-05 16:41:1718581browse

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.

How to automatically generate excel table quadrature

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.

How to automatically generate excel table quadrature

Rendering:

How to automatically generate excel table quadrature

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.

How to automatically generate excel table quadrature

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

How to automatically generate excel table quadrature

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn