1、打开工作表,制作以下形式的表格。字段包括:产品品号、元器名称、数量、单价等。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c75c10385343fbf2e6346c5ca07eca8065388fb1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、输入产品品号、元器名称、数量等数据,不能漏,也不能多。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7a899e510fb30f249a82267cd895d143ad4b03b1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、输入元器件的单价,在实际工作中,单价是会变化的,在财务上有各种算法。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/11385343fbf2b211c6354f31da8065380cd78eb2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、选中如图红框中数据,然后在F3单元格中输入公式“=D3*E3”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/caef76094b36acaf49fa5c836cd98d1001e99cb3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、按CTRL+ENTER键后,即得出各单种器件的价格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a6efce1b9d16fdfa2f790c91a48f8c5494ee7bbc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、在F12单元格中输入公式“=SUM(F3:F11)”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/838ba61ea8d3fd1fe51d6845204e251f95ca5fbd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、按回车键后,即得出A电子产品材料的整个材料成本。在此数据的基础上再加上管理成本、人工成本等价格,便得出了整个产品的成本了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7dd98d1001e939014c1547416bec54e736d196be?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)