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

wp8680 · 发表于 2010-12-11 13:55

<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></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-LEFT: windowtext 1pt solid; WIDTH: 324pt; BORDER-BOTTOM: #d4d0c8; 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: 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: 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: 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: 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-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; 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">第二讲:公式与函数基础作业 </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点 <div></div><div></div></td></tr></tbody></table>

[此贴子已经被作者于2010-12-11 14:02:09编辑过]

wp8680 · 发表于 2010-12-11 13:55

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

[此贴子已经被作者于2010-12-15 21:28:03编辑过]

sys31yy · 发表于 2010-12-11 14:23

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

正确；只是第三题公式还可以简化，没必要用IF，想法变为数值就可。

[此贴子已经被wp8680于2010-12-11 22:00:30编辑过]

hjcexecl · 发表于 2010-12-11 14:48

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

无附件无真相？

[此贴子已经被wp8680于2010-12-11 22:01:57编辑过]

qasdqasd · 发表于 2010-12-11 18:25

想入菲-菲 · 发表于 2010-12-11 21:14

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

第一题中F27/3>80应改为F27/3>=80第二题要求用一个公式下拉完成的。第三题正确，只是所得结果不是文本结果，但这不是问题。我交了之后才发现，唉，失误，少个=。第二题没注意看要求，呵呵，现改为=IF(H7="出生年份",MID(VLOOKUP($I$6,$B$7:$F$24,ROW(2:2),0),7,4),VLOOKUP($I$6,$B$7:$F$24,ROW(2:2),0))[/hide]

[此贴子已经被作者于2010-12-12 10:51:58编辑过]

wp8680 · 发表于 2010-12-11 22:10

有作业的先阅了，万一明天论说不保存帖子了，造成麻烦。

wxj1126 · 发表于 2010-12-12 11:25

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

118号wxj1126交作业基本正确

[此贴子已经被wp8680于2010-12-12 13:05:10编辑过]

年龄 · 发表于 2010-12-12 11:33

学习

nhcyss · 发表于 2010-12-12 12:32

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

基本正确，但作业要用回复帖，还有不需用这么长的公式吧，我头都晕了，想办法简化简化。

[此贴子已经被wp8680于2010-12-12 13:18:31编辑过]

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

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

函快二期二班作业上交情况

函快2期2班第2讲113号sys31yy上交作业

【函快2期2班】第二讲123号hjcexecl上交作业

函快2班第2讲075号想入菲菲上交作业

函快2班第2讲171号nhcyss交作业