函入班第5讲5组上交作业帖

zhaoxiaofeng · 发表于 2008-6-25 07:39

<p>函数入门班5组学员在此跟帖上交第5讲作业</p><p>     1、请不要回复与作业无关的内容。<br/>     2、作业直接帖出公式，不要上传附件，作业上交后不得再修改或重复上交。<br/>     3、必须采用回复可见方式上交作业。 <br/>     4、每位学员必须上交作业,前三名正确答案奖励2个金币。<br/>     5、作业上交截止7月1日14点。</p><p><font color="#0033ff">第5讲作业下载: <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=58280"><font color="#0000ff">http://www.excelpx.com/forum.php?mod=viewthread&tid=58280</font></a></font></p><p><font color="#0033ff">如何上传附件:  <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=154"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=154" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=154" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=154" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=154" target="_blank">http://www.excelpx.com/forum.php?mod=viewthread&tid=154</a><a></a><a></a><a></a><a></a></font></p><p><font color="#0033ff">如何发回复可见帖: <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=50825"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=50825" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=50825" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=50825" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=50825" target="_blank">http://www.excelpx.com/forum.php?mod=viewthread&tid=50825</a></font></p><p> </p><p>

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

</p>

[此贴子已经被作者于2008-6-26 15:12:04编辑过]

xu2yong · 发表于 2008-6-28 17:51

费了九牛二虎之力，终于完成了作业。

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

ANLEIFINE · 发表于 2008-6-28 20:49

jh_richey · 发表于 2008-6-29 13:55

学习一下

50-80-120 · 发表于 2008-6-29 14:46

来看看。。

MERRY5988 · 发表于 2008-6-29 20:20

<p>

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

</p><p><table cellspacing="0" cellpadding="0" width="648" border="0" xstr="" style="WIDTH: 486pt; BORDER-COLLAPSE: collapse;"><colgroup><strong><col span="9" width="72" style="WIDTH: 54pt;"></col><col></col><strike><sup></sup></strike></strong></colgroup><tbody><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" width="576" colspan="8" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; WIDTH: 432pt; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><div style="MIN-HEIGHT: 200px; WORD-WRAP: break-word;"><sup><table cellspacing="0" cellpadding="0" width="648" border="0" xstr="" style="WIDTH: 486pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="9" width="72" style="WIDTH: 54pt;"></col><col></col></colgroup><tbody><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" width="648" colspan="9" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; WIDTH: 486pt; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"><div style="MIN-HEIGHT: 200px; WORD-WRAP: break-word;"><font face="宋体" size="2">1. =IF(TODAY()>A2,365-DATEDIF(A2,TODAY(),"yd"),DATEDIF(TODAY(),A2,"yd"))</font></div></td></tr></tbody></table></sup></div></td><td class="xl24" width="72" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; WIDTH: 54pt; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"><p> </p></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" colspan="6" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><table cellspacing="0" cellpadding="0" width="648" border="0" xstr="" style="WIDTH: 486pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="9" width="72" style="WIDTH: 54pt;"></col><col></col></colgroup><tbody><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" width="648" colspan="9" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; WIDTH: 486pt; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"><p><font face="宋体" size="2">2、=TEXT(TEXT(A2,"mdd")-TEXT(NOW(),"mdd"),"[>30]_ ;;生日")</font></p><p>3、=TEXT(TEXT(A2,"mdd")-TEXT(NOW(),"mdd"),"[>"&7-WEEKDAY(NOW(),2)&"]_ ;;生日")</p><p>4. =(B3-A3)*24*60</p><p>5. =REPLACEB(A2,1,,"NO."&REPT(0,10-LEN(A2)))</p><p>6. =YEAR(A2)&"-"&MONTH(A2)&"-"&DAY(A2)</p><p>    =HOUR(A2)&":"&MINUTE(A2)</p><p>7. =DATE(YEAR(TODAY()),6,22)-WEEKDAY(DATE(YEAR(TODAY()),6,22),2)</p><p>8. =REPLACE(A2,2,,IF(MOD(LEFT(A2,2),2),"8","3"))</p></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" colspan="9" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2"></font></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" colspan="9" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2"></font></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" colspan="9" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2"></font></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" colspan="9" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2"></font></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" colspan="9" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">          </font></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" colspan="9" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2"></font></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" colspan="9" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2"></font><div><font face="宋体" size="2"></font></div></td></tr></tbody></table></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" colspan="8" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl25" width="576" colspan="8" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; WIDTH: 432pt; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"><p> </p><p> </p><p> </p><p> </p></td><td class="xl26" width="72" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; WIDTH: 54pt; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" colspan="5" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" colspan="4" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" colspan="4" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl25" width="576" colspan="8" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; WIDTH: 432pt; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;"></td><td class="xl26" width="72" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; WIDTH: 54pt; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td></tr><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl24" colspan="5" height="27" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><div> </div></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td><td class="xl24" style="BORDER-RIGHT: #f1f8fc; BORDER-TOP: #f1f8fc; BORDER-LEFT: #f1f8fc; BORDER-BOTTOM: #f1f8fc; BACKGROUND-COLOR: transparent;"></td></tr></tbody></table></p>

[此贴子已经被作者于2008-6-29 20:26:58编辑过]

dtl314159 · 发表于 2008-6-30 11:41

wmy · 发表于 2008-6-30 16:15

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

</p><p>水平太差，才刚做好。最近发现越来越跟不上了。</p>

天使兰优 · 发表于 2008-6-30 22:08

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

molly · 发表于 2008-7-1 13:02

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

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

[通知] 函入班第5讲5组上交作业帖

交作业

回复：（zhaoxiaofeng）函入班第5讲5组上交作业帖