How to use excel for data manipulation

Excel has powerful data manipulation functions, and the specific operations are as follows:

I. Operating tools: excel20 10

Second, the operation steps:

1. Enter excel20 10 to open the document to be calculated. Click the cell to be calculated, enter the code "= G3 * H3", and then press Enter. At this time, the amount (quantity * unit price) can be calculated, as shown in the following figure:

2. Move the mouse to the bottom of the cell of the calculation result. When the cross icon appears, press and drag it down, and then you can automatically calculate the number of other cells, as shown in the following figure:

3. Next, start to calculate the total amount, click the cell, and then click the automatic sum icon in the data toolbar, as shown in the following figure:

4. Then select the summed cell area and press Enter, as shown in the figure below:

5. The total amount is automatically calculated, as shown in the figure below: