|
<p>函入6期O1O12</p><p>第一题</p><table cellspacing="0" cellpadding="0" width="862" border="0" style="WIDTH: 647pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="120" style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 1920;"></col><col width="248" style="WIDTH: 186pt; mso-width-source: userset; mso-width-alt: 3968;"></col><col width="222" style="WIDTH: 167pt; mso-width-source: userset; mso-width-alt: 3552;"></col><col width="272" style="WIDTH: 204pt; mso-width-source: userset; mso-width-alt: 4352;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl72" width="862" colspan="4" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: #ebe9ed; WIDTH: 647pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">**学校三1班学生成绩统计表</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">姓名</td><td class="xl68" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">语文</td><td class="xl68" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数学</td><td class="xl68" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">英语</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">参考人数</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(C3:C30,"<>缺考")</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(D3:D30,"<>缺考")</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(E3:E30,"<>缺考")</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">总分</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=SUM(C3:C30)</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=SUM(D3:D30)</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=SUM(E3:E30)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">平均分</td><td class="xl70" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=AVERAGE(C3:C30)</td><td class="xl70" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=AVERAGE(D3:D30)</td><td class="xl70" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=AVERAGE(E3:E30)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">及格人数</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(C3:C30,">59")</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(D3:D30,">59")</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(E3:E30,">59")</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">及格率</td><td class="xl71" xfmla="=B6/B3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=C36/C33</td><td class="xl71" xfmla="=C6/C3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=D36/D33</td><td class="xl71" xfmla="=D6/D3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=E36/E33</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">优秀人数</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(C3:C30,">=85")</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(D3:D30,">=85")</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=COUNTIF(E3:E30,">=85")</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">优秀率</td><td class="xl71" xfmla="=B8/B3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=C38/C33</td><td class="xl71" xfmla="=C8/C3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=D38/D33</td><td class="xl71" xfmla="=D8/D3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=E38/E33</td></tr></tbody></table><p></p><p>第二题</p><p><table cellspacing="0" cellpadding="0" width="556" border="0" style="WIDTH: 417pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="108" style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 1728;"></col><col width="160" style="WIDTH: 120pt; mso-width-source: userset; mso-width-alt: 2560;"></col><col span="2" width="144" style="WIDTH: 108pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" width="108" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 81pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">科目</td><td class="xl68" width="160" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 120pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">语文</td><td class="xl68" width="144" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 108pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数学</td><td class="xl68" width="144" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 108pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">英语</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">最高分</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=MAX(第1题!C3:C30)</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=MAX(第1题!D3:D30)</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=MAX(第1题!E3:E30)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">最低分</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=MIN(第1题!C3:C30)</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=MIN(第1题!D3:D30)</td><td class="xl69" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">=MIN(第1题!E3:E30)</td></tr></tbody></table></p><p>第三题</p><p><table cellspacing="0" cellpadding="0" width="256" border="0" style="WIDTH: 192pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="256" style="WIDTH: 192pt; mso-width-source: userset; mso-width-alt: 4096;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" width="256" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 192pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">结余(累计)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #ffcc99;">=SUM($C$2:C2)-SUM($D$2:D2)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #ffcc99;">=SUM($C$2:C3)-SUM($D$2:D3)</td></tr></tbody></table></p><p>选做题</p><p><table cellspacing="0" cellpadding="0" width="246" border="0" style="WIDTH: 185pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="246" style="WIDTH: 185pt; mso-width-source: userset; mso-width-alt: 3936;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" width="246" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 185pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">计算结果</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A7,B7&C7,D7&E7)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A8,B8&C8,D8&E8)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A9,B9&C9,D9&E9)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A10,B10&C10,D10&E10)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A11,B11&C11,D11&E11)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A12,B12&C12,D12&E12)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A13,B13&C13,D13&E13)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A14,B14&C14,D14&E14)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A15,B15&C15,D15&E15)</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl69" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">=SUM(A16,B16&C16,D16&E16)</td></tr></tbody></table></p><p><table cellspacing="0" cellpadding="0" width="204" border="0" style="WIDTH: 153pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="204" style="WIDTH: 153pt; mso-width-source: userset; mso-width-alt: 3264;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" width="204" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 153pt; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: #ffcc99;">=C2-D2+IF(E1=$E$1,0,E1)</td></tr></tbody></table></p><p></p> |
|