Excel表格中怎么样制作比赛自动评分表
<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>竞赛中常用统计表格。传统的评分表是都是用手工记录、手工或计算器计算，<span style="color: black;">而后</span>再人工排序，<span style="color: black;">这般</span>做不仅效率低下，<span style="color: black;">况且</span>容易出错。利用<span style="color: black;">Excel</span><span style="color: black;">中排序等<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></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1、</span><span style="color: black;">新建<span style="color: black;">Excel</span><span style="color: black;">命名为评分表，设置好表头；</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/6jqE7PLSYAcJtRbRIe9wbDV1eJWV4pMMX8LLnWkPxsv4UqQ874ubSeicQEnCDVhBDa9fJ9icwib7NTfkhLibP3pZxg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<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;">L2</span><span style="color: black;">中输入“</span><span style="color: black;">=(SUM(B2:K2)-MAX(B2:K2)-MIN(B2:K2))/8</span><span style="color: black;">”，意思是求得所有评委评分的总和，再减去一个最高分和一个最低分，<span style="color: black;">而后</span>除以</span><span style="color: black;">8</span><span style="color: black;">，得到的结果<span style="color: black;">便是</span>选手平均得分；</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/6jqE7PLSYAcJtRbRIe9wbDV1eJWV4pMMUPabNVeKG98d31vVWIA3Pvw0UnicHrxqIqYTAemvkkV4PbBogOe66sw/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3<span style="color: black;">、在单元格</span><span style="color: black;">M2</span><span style="color: black;">中输入“</span><span style="color: black;">=RANK(L2</span><span style="color: black;">，</span><span style="color: black;">$L$2</span><span style="color: black;">：</span><span style="color: black;">$L$11)</span><span style="color: black;">”，即<span style="color: black;">按照</span></span><span style="color: black;">L2</span><span style="color: black;">到</span><span style="color: black;">L11</span><span style="color: black;">的平均得分进行排名；</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/6jqE7PLSYAcJtRbRIe9wbDV1eJWV4pMM7uXdepiaGGibY4CNccYQYCU8lmAkmO9wbHOS43AOWWZibIDWOHrw4DOhg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4<span style="color: black;">、接下来只要输入选手的得分，平均得分和排名就能够自动计算出来。</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/6jqE7PLSYAcJtRbRIe9wbDV1eJWV4pMM9elOo6KCiaZI4x52L05EDX9zTaNuUwfZcbnZrKU15HhArBToq8zPyzw/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咨询热线：<span style="color: black;">4008-386-486</span></span></p>
太棒了、厉害、为你打call、点赞、非常精彩等。 期待与你深入交流，共探知识的无穷魅力。
页:
[1]