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

一剑惊心

<p><font color="#0000ff" size="3"><strong>1、作业尽量独立完成，如有疑问，学员之间可互相学习，但严禁在论坛上公开发贴求助作业题目。</strong></font></p><p><font color="#0000ff" size="3"><strong>2、<font size="4">以回复可见的方式上传作业，一经上传，不得进行二次编辑，否则进行删贴处理！未进行回复可见方式上传作业的，一律删贴并不予批改！</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">[move]<strong><font color="#f73809" size="5">EXCEL精英培训班级管理制度</font></strong>[/move]</p>

喜多多

<p>

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

</p><p>想look别人的作业一下。非常有这个冲动。</p><p><strong><font color="#ff0000">干嘛交这么早？</font></strong></p>[em07]

[此贴子已经被一剑惊心于2010-1-26 20:26:10编辑过]

wyg791019

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

</p><p><strong><font color="#ff0000">加油</font></strong></p>

[此贴子已经被一剑惊心于2010-1-26 20:28:07编辑过]

cr123

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

[此贴子已经被作者于2010-1-23 20:16:23编辑过]

hxy_nt_ls

<p>4组050交作业</p><p>

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

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

[此贴子已经被一剑惊心于2010-1-26 20:30:31编辑过]

学海泛舟

<p>4组049：学海泛舟&nbsp; 交作业</p><div class="real_blog" id="veryContent" style="TEXT-INDENT: 0em; HEIGHT: auto! important;"><table id="blogContentTable" cellspacing="0" cellpadding="0" style="TABLE-LAYOUT: fixed; WIDTH: 100%; POSITION: relative;"><tbody><tr><td valign="top" style="WORD-WRAP: break-word;"><div id="blogContainer" style="OVERFLOW: hidden; POSITION: relative; HEIGHT: 100%;"><img id="paperPicArea0" src="http://imgcache.qq.com/ac/b.gif" style="DISPLAY: none;" alt=""/>
                                                        <div id="paperTitleArea" align="center"><span id="paperTitle" style="DISPLAY: block; FONT-WEIGHT: bolder; WORD-BREAK: break-all;"></span></div><img id="paperPicArea" src="http://imgcache.qq.com/ac/b.gif" style="DISPLAY: none;" alt=""/>
                                                        <div id="blogDetailDiv" style="FONT-SIZE: 16px;"><p><table cellspacing="0" cellpadding="0" width="834" border="0" style="WIDTH: 626pt; BORDER-COLLAPSE: collapse;"><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" width="93" height="19" style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; WIDTH: 70pt; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体">第一部分1）</font></td><td width="741" style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; WIDTH: 556pt; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><p><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;</span>=SUMPRODUCT(($B:$B=J$5)*($C:$C=$I6),$D:$D)</font></p></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>2）</font></td><td style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><p><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;</span>=SUM(IF(($E$2:$E$1400&gt;4)*($C$2:$C$1400="A"),F2:F1400))三键</font></p></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3）</font></td><td style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;</span>=SUM(((C2:C1400="A")+(C2:C1400="B")+(C2:C1400="C"))*(B2:B1400=I30)*(F2:F1400))三键</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"></font></td><td style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体">&nbsp;注：I30=甲 </font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><p><font face="宋体"></font></p><p><font face="宋体">第二部分1）</font></p></td><td style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><p><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;</span></font></p><p><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;</span>=SUM(ROW(1:500)*2-1)三键</font></p></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"></font></td><td style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;</span>=SUMPRODUCT((MOD(ROW(1:1000),2)=1)*(ROW(1:1000)))</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"></font></td><td style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;</span>=SUM(IF(MOD(ROW(1:1000),2)=1,ROW(1:1000)))三键</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;</span>2）</font></td><td style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;</span>=MOD(ROW(1:6)-1,3)+1三键</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"></font></td><td style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;</span>=ROUNDUP(ROW(A1:A6)/2,0)-1三键</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3）</font></td><td style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;</span>=IF({1,0,0},D50:D58,IF({0,1,0},C50:C58,B50:B58))三键</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"></font></td><td style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0;"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;</span>=CHOOSE({1,2,3},D50:D58,C50:C58,B50:B58)三键</font></td></tr></tbody></table></p></div></div></td></tr></tbody></table></div>

quanwang_lu

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

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

[此贴子已经被一剑惊心于2010-1-26 20:32:48编辑过]

sctcp

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

lnbFiohF.rar (33.93 KB, 下载次数: 0)

2010-1-25 20:17 上传

点击文件名下载附件
函入5期第三讲作业上交专贴－－－（4组） <br/>

nalin

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

[此贴子已经被一剑惊心于2010-1-26 20:34:20编辑过]

加倍珍惜

<p>这次作业，基本不会，只做了一点，但是还要交的！</p><p>

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

</p><p></p><p><strong><font color="#ff0000">最起码你所交的答案都是正确的，支持你一下</font></strong></p>

[此贴子已经被一剑惊心于2010-1-26 20:36:09编辑过]