平均值函数excel公式怎么用 excel表格中求平均值怎么操作
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在excel中求平均值的函数是AVERAGE，但有不少用户不<span style="color: black;">晓得</span>这个平均值函数公式到底怎么操作，<span style="color: black;">详细</span>需要勾选<span style="color: black;">那些</span>数据。今天<span style="color: black;">博主</span>就<span style="color: black;">经过</span><span style="color: black;">仔细</span>的图文教程来给<span style="color: black;">大众</span>说明一下excel表格中求平均值的<span style="color: black;">详细</span><span style="color: black;">处理</span><span style="color: black;">办法</span>，有需要的用户们赶紧来看一下吧。<a style="color: black;">#excel函数公式大全#</a></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/6dbe9decf2bc476e80eef0b19c1b47f2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981044&x-signature=ubGr%2B%2Fh78ePjA6fGlgZ%2Fm7r%2FUwY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">平均值函数excel公式怎么用</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">详细</span><span style="color: black;">过程</span>如下：</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1.<span style="color: black;">首要</span>，打开班级的成绩单，<span style="color: black;">能够</span>看到<span style="color: black;">每一个</span><span style="color: black;">朋友</span>的成绩。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/994cd34b4eb547938f6dfc7bd788e72a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981044&x-signature=OUNSDaXPbaSenKuMrymfzJJxWss%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2.<span style="color: black;">此刻</span>想<span style="color: black;">需求</span>出每科的平均数，现以语文为例，把平均成绩放在B21单元格。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/7f0eaaa5aa9f462e95a190c4f08de338~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981044&x-signature=vgPRnaewKFIN1VIwZztQ2GdXgnY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3.将光标放在B21单元格内，点击菜单栏上边的【公式】-【<span style="color: black;">插进</span>函数】按钮。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/fc796c0b4f9540a1a7e007a4353ad133~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981044&x-signature=PQPQr5MK8v%2Fz%2FGk71JPyKF7hhtg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4.在弹出的弹框里边找到AVERAGE函数，点击【确定】。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/c4f4b12e97c14391830ae83557ff8154~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981044&x-signature=1TxHzf7QuNymE9i1aMx5TKbTbT0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">5.在参数1中选中所有语文成绩，<span style="color: black;">这儿</span>是【B3：B20】，再点击【确定】。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/e92b47ce23a44e5cac1a6a56e07c9112~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981044&x-signature=VsCVvGZgvdRUgozaqsoDqt7GNYQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">6.求出了语文的平均数，<span style="color: black;">而后</span>选中单元格，会变成黑色十字，向右拖拽就<span style="color: black;">能够</span>把数学、英语成绩的平均数算出来了。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/154a14820a364d9f99a0b13c3117955f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981044&x-signature=u3WkLqjgnveuTZeAk3pNb5S6uR0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">7.想把平均数<span style="color: black;">保存</span>成整数：选中单元格单击鼠标右键，<span style="color: black;">选取</span>【设置单元格格式】，小数位数改成0，点击确定。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/5e3d2cd4fdcc4f5bb588b145e0f10349~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981044&x-signature=RNiT4MRx3f6k2VADrR7PdcL9dGc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">8.最后，<span style="color: black;">能够</span>看到了平均数被求出来了，数值<span style="color: black;">亦</span>变<span style="color: black;">成为了</span>两位小数了。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/447be6c277bd4bb89e3b4d0610377c67~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981044&x-signature=rT0xX0inmWskS5%2FgeNrPXG8%2BgwI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">以上<span style="color: black;">便是</span>平均值函数excel公式的<span style="color: black;">运用</span><span style="color: black;">办法</span>介绍了，<span style="color: black;">期盼</span>对各位用户们有所<span style="color: black;">帮忙</span>。</span></p>
你的留言真是温暖如春，让我感受到了无尽的支持与鼓励。 你的努力一定会被看见，相信自己，加油。 祝福你、祝你幸福、早日实现等。 顶楼主，说得太好了！ 一看到楼主的气势，我就觉得楼主同在社区里灌水。
页:
[1]