函快二期学前练习题2-求最大差

QQ9947

<p>题目：求每位同学语、数、英三科中最高分和最低分相差多少。&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>要求：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>&nbsp;1、在F3单元格内输入一个公式下拉至F23得出所有答案。&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>&nbsp;2、用“回复可见”的形式贴出F3单元格内的公式即可。&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>&nbsp;3、回贴后不可再修改贴子。<br/>&nbsp;4、水贴（非答案）立即删<br/>&nbsp;5、<span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-cn; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">前</span><span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: en-us; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">10</span><span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-cn; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">位正确答案的本班同学奖励</span><span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: en-us; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">20BB/</span><span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-cn; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">人（非本班学员不送</span><span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: en-us; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">BB，未修改头衔视为非本班学员</span><span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-cn; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">）。</span></p><p><span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-cn; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;">详见附件：</span></p><p><span style="FONT-WEIGHT: normal; FONT-SIZE: 12pt; VERTICAL-ALIGN: baseline; COLOR: black; FONT-STYLE: normal; FONT-FAMILY: 宋体; language: zh-cn; mso-ascii-font-family: 宋体; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-bidi-theme-font: minor-bidi; mso-text-raise: 0%; mso-style-textfill-type: solid; mso-style-textfill-fill-color: black; mso-style-textfill-fill-alpha: 100.0%;"></span>&nbsp; vYyqYziA.rar (13.63 KB, 下载次数: 1)

2010-11-18 23:00 上传

点击文件名下载附件
函快二期学前练习题2-求最大差 <br/></p>

Hollycui

<p>学习学习</p>

儿子叫我爹

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

</p><p><font color="#1111ee"></font></p><p><font color="#1111ee"></font></p><p><font color="#1111ee"></font></p><p><font color="#1111ee">--------------------------------------------------------------------------------------</font></p><p><font color="#1111ee">先学会改头衔！</font></p>

[此贴子已经被QQ9947于2010-11-19 7:22:30编辑过]

乐满地

<p>

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

</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p>---------------------------------------------------------------------------------------------------------------------</p><p>&nbsp;[em17]</p>

[此贴子已经被QQ9947于2010-11-19 7:23:50编辑过]

清风无语

<p>

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

</p><p></p><p></p><p></p><p></p><p><font color="#0909f7">----------------------------------------------------------------------------------------</font></p><p><font color="#0909f7">请到此贴回复后领取BB：</font></p><p><font color="#0909f7"><strong><font color="#000000">函快二期学前练习题2前10名正确答案的学员请进！</font></strong><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=148905">http://www.excelpx.com/forum.php?mod=viewthread&tid=148905</a></font></p>

[此贴子已经被QQ9947于2010-11-19 7:33:48编辑过]

网上游民

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

[此贴子已经被作者于2010-11-18 23:22:05编辑过]

liquanchun

<p>

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

</p><p></p><p></p><p></p><p><font color="#0909f7">-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</font></p><p><font color="#0909f7">请到此贴回复后领取BB：</font></p><p><strong>函快二期学前练习题2前10名正确答案的学员请进！</strong><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=148905" target="_blank"><font color="#000000">http://www.excelpx.com/forum.php?mod=viewthread&tid=148905</font></a></p>

[此贴子已经被QQ9947于2010-11-19 7:34:42编辑过]

春光来了

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

Hollycui

<p>

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

</p><p></p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p><font color="#0909f7">-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</font></p><p><font color="#0909f7">请到此贴回复后领取BB：</font></p><p><strong>函快二期学前练习题2前10名正确答案的学员请进！</strong><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=148905" target="_blank"><font color="#000000">http://www.excelpx.com/forum.php?mod=viewthread&tid=148905</font></a></p>

[此贴子已经被QQ9947于2010-11-19 7:35:23编辑过]

你Q我Q

<p>

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

</p><p></p><p></p><p></p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p><p><font color="#0909f7">-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</font></p><p><font color="#0909f7">请到此贴回复后领取BB：</font></p><p><strong>函快二期学前练习题2前10名正确答案的学员请进！</strong><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=148905" target="_blank"><font color="#000000">http://www.excelpx.com/forum.php?mod=viewthread&tid=148905</font></a></p>

[此贴子已经被QQ9947于2010-11-19 7:35:42编辑过]