【函快2期2班】第二讲作业上交贴(001-065)

轩辕轼轲 · 发表于 2010-12-13 20:11

<table cellspacing="0" cellpadding="0" width="432" border="0" style="WIDTH: 324pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="6" width="72" style="WIDTH: 54pt;"></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="432" colspan="6" height="19" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 324pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: #ffcc99;"><div align="center" style="MIN-HEIGHT: 200px; WORD-WRAP: break-word;">【函快2期2班】第二讲作业上交贴(066-130)</div></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl28" width="432" colspan="6" height="20" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-BOTTOM-COLOR: #d4d0c8; BORDER-LEFT: windowtext 1pt solid; WIDTH: 324pt; HEIGHT: 15pt; BACKGROUND-COLOR: #ff99cc;">班级名称  Excel函数快速入门2期2班 </td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" width="72" height="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #ccffcc;">课时</td><td class="xl31" width="360" colspan="5" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 270pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"> 第一讲:公式与函数基础 </td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" width="72" height="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #ccffcc;">讲师</td><td class="xl31" width="360" colspan="5" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 270pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"> QQ9947 </td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" width="72" height="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #ccffcc;">班主任</td><td class="xl31" width="360" colspan="5" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 270pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"> hnnyfcykl </td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" width="72" height="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #ccffcc;">班长</td><td class="xl31" width="360" colspan="5" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 270pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;">芷水</td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" width="72" height="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #ccffcc;">本帖学委</td><td class="xl31" width="360" colspan="5" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 270pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;">wp8680</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl43" width="72" height="77" rowspan="4" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 57.75pt; BACKGROUND-COLOR: red;">上交作业注意</td><td class="xl34" width="360" colspan="5" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 270pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">1、作业尽量通过自己思考独立完成 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl34" width="360" colspan="5" height="19" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 270pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">2、作业以回复可见方式提交 </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl34" width="360" colspan="5" height="19" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 270pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">3、禁止非本组学员回复 </td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl34" width="360" colspan="5" height="20" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 270pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: yellow;">4、必须先提交作业再投票，否由按抄袭论处</td></tr><tr height="31" style="HEIGHT: 23.25pt;"><td class="xl23" width="72" height="31" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 23.25pt; BACKGROUND-COLOR: #ccffcc;">回复标题格式  </td><td class="xl31" width="360" colspan="5" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 270pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;">函快2期2班第2讲×××号+论坛ID上交作业 </td></tr><tr height="31" style="HEIGHT: 23.25pt;"><td class="xl23" width="72" height="31" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 23.25pt; BACKGROUND-COLOR: #ccffcc;">回复可见方法</td><td class="xl37" width="360" colspan="5" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 270pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=114926" target="_blank">回复可见及头衔修改操作方法 </a></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" width="72" height="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #ccffcc;">课件链接 </td><td class="xl37" width="360" colspan="5" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 270pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=150449" target="_blank"> 第二讲课件:公式与函数基础 </a></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl23" width="72" height="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #ccffcc;">作业链接</td><td class="xl37" width="360" colspan="5" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 270pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=151060" target="_blank">第二讲:公式与函数基础作业 </a></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl24" width="72" height="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #ccffcc;">锁帖时间 </td><td class="xl40" width="360" colspan="5" style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 270pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ffcc99;"> 2010年12月14日 17点 </td></tr></tbody></table>

[此贴子已经被作者于2010-12-13 20:11:33编辑过]

pzh130 · 发表于 2010-12-13 20:16

今天不交作业，刷BB,对不起了老师。[em01][em01][em01]

anchangmei · 发表于 2010-12-13 20:24

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

<div class="msgheader">QUOTE:</div><div class="msgborder">有几个公式有点取巧，不过也能得出正确的结果                               轩辕轼轲    2010-12-14</div>

[此贴子已经被轩辕轼轲于2010-12-14 18:57:53编辑过]

ddcl · 发表于 2010-12-13 20:34

[em01][em01]

toby991 · 发表于 2010-12-13 22:01

函快2期2班第2讲025号toby991 上交作业

zDw8IDqf.rar (21.48 KB, 下载次数: 1)

ylgzlz · 发表于 2010-12-13 22:13

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

<div class="msgheader">QUOTE:</div><div class="msgborder">全部正确，不过第二题的公式还可以简化。                               轩辕轼轲    2010-12-14</div>

[此贴子已经被轩辕轼轲于2010-12-14 18:59:22编辑过]

myjml · 发表于 2010-12-14 00:47

[em01][em01][em01]

SZHPBS · 发表于 2010-12-14 08:29

04050上交第二讲作业

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

<div class="msgheader">QUOTE:</div><div class="msgborder">及格我们一般不用">59"来判断，而是用大于等于60。因为存在59.5这样的数据。第三题忽略了数据的对齐方式。                               轩辕轼轲    2010-12-14</div>

[此贴子已经被轩辕轼轲于2010-12-14 19:03:19编辑过]

雁背斜阳 · 发表于 2010-12-14 12:44

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

雁背斜阳 · 发表于 2010-12-14 12:45

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

<div class="msgheader">QUOTE:</div><div class="msgborder">第三题忽略了数据的对齐方式。其他都正确。                               轩辕轼轲    2010-12-14</div>

[此贴子已经被轩辕轼轲于2010-12-14 19:04:41编辑过]

		自动登录	找回密码
密码			注册

[资料] 【函快2期2班】第二讲作业上交贴(001-065)

【函快03031】anchangmei上交作业

函快2期2班第2讲025号toby991 上交作业

函快2期2班第2讲38号+ylgzlz上交作业

04050上交作业