函入5期第四讲作业上交专贴---(2组)
<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> </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&filename=2009-10/200910172039841725.gif" target="_blank"><img title="dvubb" alt="图片点击可在新窗口打开查看" src="http://www.excelpx.com/showimg.asp?BoardID=151&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><p>2组026 Greta交作业</p><p>**** Hidden Message *****</p><p></p>
[此贴子已经被一剑惊心于2010-2-2 19:36:55编辑过]
2组长027meg19850305交作业
<p>2组长027meg19850305交作业</p><p>**** Hidden Message *****</p>[此贴子已经被一剑惊心于2010-2-2 19:38:02编辑过]
交作业
<p>2组019号美丽心情2008交作业</p><p>**** Hidden Message *****</p><p></p>[此贴子已经被一剑惊心于2010-2-2 19:38:39编辑过]
【函5.2.029】作业
**** Hidden Message *****[此贴子已经被一剑惊心于2010-2-2 19:40:26编辑过]
函入5班2组024号交作业
<p>**** Hidden Message *****</p>[此贴子已经被一剑惊心于2010-2-2 19:40:50编辑过]
<p>年底了,好忙啊!昨天晚上加班总算今天有时间做作业了!</p><p>2组22号交作业</p><p>**** Hidden Message *****</p>
[此贴子已经被一剑惊心于2010-2-2 19:41:46编辑过]
<p>年底了,好忙啊!昨天晚上加班总算今天有时间做作业了!</p><p>2组22号交作业</p><p>**** Hidden Message *****</p>
<p><strong>函入5班2组023号交作业</strong></p><p>**** Hidden Message *****</p>
[此贴子已经被一剑惊心于2010-2-2 19:43:07编辑过]
2组017雨滴0531交作业
**** Hidden Message *****</p><span style="FONT-SIZE: 16pt; FONT-FAMILY: 仿宋_GB2312; mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-font-kerning: 1.0pt;"><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">1</span><span style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-ascii-font-family: Tahoma;">、美国式排名:</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">=RANK</span><span style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-ascii-font-family: Tahoma;">(</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">G5,G$5:G$15)<br/></span><span style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-ascii-font-family: Tahoma;">中国式排名:</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">=SUMPRODUCT((G$5:G$15>=G5)*(1/COUNTIF(G$5:G$15,G$5:G$15)))<br/>2</span><span style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-ascii-font-family: Tahoma;">、</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">=SUMIF(G5:G15,">=300")/COUNTIF(G5:G15,">=300")<br/>3</span><span style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-ascii-font-family: Tahoma;">、</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">=SUMPRODUCT((C5:C15>80)*(E5:E15>80))<br/>4</span><span style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-ascii-font-family: Tahoma;">、</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: Tahoma;">{=AVERAGE(IF((C5:C15>80)*(E5:E15>80),G5:G15,""))}</span></p></span>[此贴子已经被一剑惊心于2010-2-2 19:43:38编辑过]
页:
[1]
2