函入5期第六讲作业上交专贴－－－（1组）

一剑惊心

<strong><font color="#0000ff" size="3">1、作业尽量独立完成，如有疑问，学员之间可互相学习，但严禁在论坛上公开发贴求助作业题目。</font></strong><br/>&nbsp;<p><font size="3"><strong><font color="#0000ff">2、<font size="4">以回复可见的方式上传作业，一经上传，不得进行二次编辑，否则进行删贴处理！未进行回复可见方式上传作业的，一律删贴并不予批改！</font></font></strong></font></p><p><font color="#0000ff" size="3"><strong>3、如需要注明操作步骤的，请尽量提供完整步骤。</strong></font></p><p><font color="#0000ff" size="3"><strong>4、作业上交截止日期为下节课前一天的17：00，届时将进行锁贴操作。</strong></font></p><p><strong><font color="#0000ff" size="3">5、对于仅回复贴子而不上交作业的学员，对其在以后楼层再上交的作业一律不予批改。</font></strong></p><p><strong><font color="#0000ff" size="3">6、非本组学员回帖一律进行删贴处理。</font></strong></p><p><strong><font color="#0000ff" size="3">7、未进行特殊声明的，只需提交公式即可，请按一定的格式进行。如<font color="#00ff00">【第一题】（公式）</font></font></strong></p><p><strong><font size="3"><font color="#ff0000">7、<u>如果有学员的头衔尚未更改的话，请在上交作业时注明组别及学号，否则一律不予批改！</u></font></font></strong></p><p><strong><u><font color="#ff0000" size="3"></font></u></strong>&nbsp;</p><p align="center"><font face="幼圆" color="#ffffff" size="5" style="BACKGROUND-COLOR: #000000;"><strong><u>回复可见操作方法：</u></strong></font></p><p align="center"><a href="http://www.excelpx.com/showimg.asp?BoardID=151&amp;filename=2009-10/200910172039841725.gif" target="_blank"><img title="dvubb" alt="图片点击可在新窗口打开查看" src="http://www.excelpx.com/showimg.asp?BoardID=151&amp;filename=2009-10/200910172039841725.gif" border="0"/></a></p><p align="center"><marquee scrollamount="3"><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=110056" target="_blank"><strong><font color="#f73809" size="5">EXCEL精英培训班级管理制度</font></strong></a></marquee></p>

[此贴子已经被作者于2010-3-18 18:57:59编辑过]

wcg21

<p>

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

</p><p>1组006号</p><p><font color="#ff0000"><strong>OK</strong></font></p>

[此贴子已经被一剑惊心于2010-3-23 18:43:45编辑过]

zghui2008

<p>

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

</p><p><strong><font color="#ff0000">OK</font></strong></p>

[此贴子已经被一剑惊心于2010-3-23 18:45:51编辑过]

yysusanna

<p>1组001交作业</p><p>

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

</p><p><strong><font color="#ff0000">OK</font></strong></p>

[此贴子已经被一剑惊心于2010-3-23 18:47:31编辑过]

tu343740603

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

</p><p>174：tu343740603&nbsp;&nbsp; 交作业了<strong><font color="#ff0000">OK</font></strong></p>

[此贴子已经被一剑惊心于2010-3-23 18:47:56编辑过]

xcslp

<p>

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

</p><p><table cellspacing="0" cellpadding="0" width="720" border="0" style="WIDTH: 540pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="10" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" width="72" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><div style="MIN-HEIGHT: 200px; WORD-WRAP: break-word;"><font face="Tahoma" size="2">第一题】：</font></div></td><td class="xl23" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" colspan="8" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="Tahoma" size="2">&nbsp; =(J4-2000)*LOOKUP((J4-2000),$D$7:$D$15,$E$7:$E$15)-LOOKUP((J4-2000),$D$7:$D$15,$F$7:$F$15)</font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" colspan="2" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="Tahoma" size="2">【第二题】：</font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" colspan="10" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="Tahoma" size="2">&nbsp; =LOOKUP(MID(G23,1,1),$B$22:$C$44)&amp;LOOKUP(MID(G23,2,1),$B$22:$C$44)&amp;IF(LEN(G23)=2,"",LOOKUP(MID(G23,3,1),$B$22:$C$44))</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" colspan="2" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="Tahoma" size="2">【第三题】：</font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"><font face="Tahoma" size="2"></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" colspan="6" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="Tahoma" size="2">&nbsp; =INDEX($E$52:$G$67,MATCH($J52,$D$52:$D$67,0),MATCH(K$51,$E$51:$G$51,0))</font></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl23" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td class="xl23" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td></tr></tbody></table></p>

无奈的单身

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

<strong><font color="#ff0000">OK</font></strong>[em17]

[此贴子已经被一剑惊心于2010-3-23 18:48:38编辑过]

echolan

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

<strong><font color="#ff0000">OK</font></strong>

[此贴子已经被一剑惊心于2010-3-23 18:49:42编辑过]

影月小筑

<p>1组008号</p><p>

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

<strong><font color="#ff0000">OK</font></strong>

[此贴子已经被一剑惊心于2010-3-23 18:50:04编辑过]

二壮壮

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

<strong><font color="#ff0000">OK</font></strong>

[此贴子已经被一剑惊心于2010-3-23 18:50:28编辑过]