函入6期第1讲作业上交贴（5、6、7组）

nxl369

游客，如果您要查看本帖隐藏内容请回复

</p><p><strong><font color="#ff0000">通过！！！</font></strong></p>

[此贴子已经被yuhe0008于2010-8-13 14:41:08编辑过]

jj13204967

<p>07 096交作业</p><p>第一题：参考人数=COUNTIF(C$3:C$30,"&gt;0") 我实在想不出怎么表达不取文本值的公式；</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 总分&nbsp;&nbsp;&nbsp; =SUM(C$3:C$30)</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;平均分&nbsp;&nbsp;=AVERAGE(C$3:C$30)</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;及格人数=COUNTIF(C$3:C$30,"&gt;=60")</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 及格率&nbsp; =C$34/C$31</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 优秀人数=COUNTIF(C3:C30,"&gt;=85")</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;优秀率&nbsp; =C$36/C$31</p><p>第二题：最高分&nbsp;&nbsp; =MAX(第1题!C$3:C$30)&nbsp; </p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 最低分&nbsp; =MIN(第1题!C$3:C$30)</p><p>第三题： 实在是想出来怎么做</p><p></p><p>=。=&nbsp; 看看同学是怎么答的。我感觉自己好差啊</p><p>[em03][em03][em03]</p><p><strong><font color="#ff0000">第3题未完成！！！</font></strong></p>

[此贴子已经被yuhe0008于2010-8-13 14:42:12编辑过]

Zhang2010607

<p>

游客，如果您要查看本帖隐藏内容请回复

</p><p><a href="http://user.qzone.qq.com/369238407"><font color="#ff0000"><strong>通过！！！</strong></font></a></p>

[此贴子已经被yuhe0008于2010-8-13 14:43:30编辑过]

沙漠王子1

游客，如果您要查看本帖隐藏内容请回复

</p><p><strong><font color="#ff0000">及格人数公式有问题！！！</font></strong></p>

[此贴子已经被yuhe0008于2010-8-13 17:33:32编辑过]

L5160729

[hide]<table border="0" cellspacing="0" cellpadding="0" width="104" style="WIDTH: 78pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="44" style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 1408;"></col><col></col><col width="60" style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 1920;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" width="104" colspan="2" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 78pt; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">参考人数=COUNTA(C3:C30)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" colspan="2" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">总分=SUM(C3:C30)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" colspan="2" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">平均分=AVERAGE(C3:C30)</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" colspan="2" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">及格人数=COUNTIF(C3:C30,"&gt;60")</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" colspan="2" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">及格率=C34/C31</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" colspan="2" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">优秀人数=COUNTIF(C3:C30,"&gt;85")</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" colspan="2" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">优秀率=C36/C31</font></td></tr></tbody></table><font face="宋体"><p><table border="0" cellspacing="0" cellpadding="0" width="72" style="WIDTH: 54pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" width="72" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 54pt; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;">最高分=LARGE(第1题!C2:C30,1)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;">最低分=SMALL(第1题!C3:C30,1)</td></tr></tbody></table></p><p>=C3-D3+E2</p></font><p><font face="宋体">[/</font>replyview]</p><p><strong><font color="#ff0000">及格人数、优秀人数公式有问题，第3题有问题！！！</font></strong></p>

[此贴子已经被yuhe0008于2010-8-13 17:34:56编辑过]

yishuihanab

看看答案

sarkis

看看答案，学习一下

hujiayiyu

看看           

sunjing-zxl

回复学习答案                             

qingfeng_qf

看一下学习学习！