1. Open the worksheet and make the following table. Fields include: product number, component name, quantity, unit price, etc.

2. Enter data such as product number, component name and quantity. , can't miss or exceed.

3. Enter the unit price of the component. In practical work, the unit price will change, and there are various financial algorithms.

4. Select the data in the red box as shown in the figure, and then enter the formula "=D3*E3" in the F3 cell.

5. Press CTRL+ENTER to get the price of various single devices.

6. Enter the formula "=SUM(F3:F 1 1)" in cell F 12.

7. Press Enter to get the total material cost of an electronic product material. On the basis of this data, plus management costs, labor costs and other prices, we can get the cost of the whole product.