The method is as follows:

1. Enter the multiplication formula "=A1*B1*C1*D1" in cell E1.

2. Then enter the data to be multiplied in A1, B1, C1, and D1 in sequence, and the result will be displayed in "E1".

3. Use the mouse to select the "F1" cell. When the mouse turns into a black cross, hold down the left button and drag it down. At this time, the formula in "F1" has been copied from "F1" to the following F2, F3, F4, etc. The next time you need to perform calculations, enter the data directly in front of F2, F3, F4, etc. The result of the operation will be automatically displayed in the cell.

Microsoft Excel is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. The intuitive interface, excellent calculation functions and charting tools, coupled with successful marketing, make Excel the most popular personal computer data processing software.

In 1993, after the release of version 5.0 as a component of Microsoft Office, Excel began to become the dominant spreadsheet software on applicable operating platforms.

In the early days, Excel became the target of trademark law because it had the same name as a software called Excel sold by another company. After a trial, Microsoft was required to use the name Microsoft Excel in its official documents and legal documents. to name this software. However, as time went by, this practice gradually disappeared.

Although Excel provides a large number of user interface features, it still retains the features of VisiCalc, the first electronic spreadsheet software: rows and columns form cells, data, data-related formulas or other An absolute reference to the cell is saved in the cell.