想要用excel求平均值,可以按照以下步骤进行操作:
1、首先打开excel表格,全选需要求平均值的单元格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9213b07eca806538b9ad308185dda144ac3482d9?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/64380cd7912397dd193e0c964b82b2b7d1a287d9?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/902397dda144ad34e3f81315c2a20cf430ad85d9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
或使输入公式=AVERAGE(A2:A7)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/96dda144ad34598209cd71001ef431adcaef84d9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
【加入社群一起学习】想要了解更多关于excel的相关信息,推荐咨询秒可职场。秒可职场自2020年创立以来,秒可深入贯彻国家大力发展职业技能教育的人才战略,致力于打造职场人才大学,覆盖学员技能培训、分级认证、就业创收,帮助职场人才终身学习成长。 同时,严格遵守国家规定,维护员工利益,致力于创造一个平等和谐多元发展的企业。