[公告](二期)一系4班第五讲5组作业上交专贴

南仁海杨

<div style="MARGIN-TOP: 10px; FONT-SIZE: 9pt; MIN-HEIGHT: 200px; WORD-BREAK: break-all; TEXT-INDENT: 24px; LINE-HEIGHT: normal; WORD-WRAP: break-word;"><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">5组的同学来此交作业啦！！！！</span></strong></font></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"></span></strong></font>&nbsp;<font size="3"><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">作业上交要求<span lang="EN-US">:</span></span></strong><span lang="EN-US" style="FONT-SIZE: 9pt;"> <p></p></span></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><font size="5"><font color="#f70909"><strong><span lang="EN-US" style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">1</span></strong><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">、作业要：参见学委的作业贴里的要求，特别是最后一条</span></strong></font></font><span lang="EN-US" style="FONT-SIZE: 9pt;"><font color="#ff0000" size="5"> </font><p></p></span></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><strong><span lang="EN-US" style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">2</span></strong><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">、</span></strong></font><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;">按题贴出结果。</span></strong></p><p><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;"><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"><font color="#ff0000">&nbsp;&nbsp; 前面4个全对的BB分别为：<font size="4">5，4，3，2</font>，其他交了作业不全错的每人<font size="4">1</font>个BB。有效时间参见学委的作业贴</font></span></span></strong></p><p><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;"><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"></span></span></strong><strong><span style="FONT-SIZE: 10.5pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-size: 12.0pt;">非本组交作业的学员请勿跟贴，否则即删扣分。</span></strong></p></div>

零时代

<p>

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

</p><p><font color="#ff0033"><strong>以后请仔细看清题意！</strong></font></p>

[此贴子已经被一剑惊心于2008-10-11 21:48:38编辑过]

一剑惊心

标记

wodeguoguo

[em05]

hc_ys

<p>请假了，也要补课做作业</p>

zhuqingyan

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

</p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">第一题：<span lang="EN-US"> <p></p></span></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 18pt; mso-char-indent-count: 1.5;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">1.=LENB(A4)-LEN(A4) <p></p></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 18pt; mso-char-indent-count: 1.5;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">2.IF(LENB(LEFT(A4,1))=2,LEFT(A4,LENB(A4)-LEN(A4)),RIGHT(A4,LENB(A4)-LEN(A4))) <p></p></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">第二题：<span lang="EN-US"> <p></p></span></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 18pt; mso-char-indent-count: 1.5;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">1. =SUMPRODUCT((U5:U16="</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">张三<span lang="EN-US">")*(W5:W16&gt;0)) <p></p></span></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 18pt; mso-char-indent-count: 1.5;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">2. =SUMPRODUCT((U4:U16="</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">张三<span lang="EN-US">")*(V4:V16&gt;4),(W4:W16)) <p></p></span></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">第三题：<span lang="EN-US"> <p></p></span></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 18pt; mso-char-indent-count: 1.5;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">=IF(LEN(A94)=15,19&amp;MID(A94,7,6),MID(A94,7,8)) <font color="#3300ff">记得题目要求计算年龄,不是出生年份</font></span> </p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 18pt; mso-char-indent-count: 1.5;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';"></span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">第四题：<span lang="EN-US"> <p></p></span></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 18pt; mso-char-indent-count: 1.5;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">1.</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">自定义格式<span lang="EN-US"> [&gt;100]"100";[&lt;0]"0"; <p></p></span></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 12pt; mso-char-indent-count: 1.0;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';"><span style="mso-spacerun: yes;">&nbsp;</span>2. =IF(W98&lt;0,0,IF(W98&gt;100,100,W98)) <p></p></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 18pt; mso-char-indent-count: 1.5;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 隶书; mso-hansi-font-family: 'Arial Black';">3. =(W98&lt;0)*0+(W98&gt;100)*100+AND(W98&lt;=100,W98&gt;=0)*W98 <font color="#0000ff">此法绝对是共同的智慧</font> <p></p></span></p><p></p><p></p><p></p><p></p><p></p><p>[/hide][/hide][/hide][/hide]</p><p><font color="#ff0000"><strong>只是摸了一下5BB的边</strong></font></p>[em01]

[此贴子已经被一剑惊心于2008-10-13 9:49:57编辑过]

打劫你IQ

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

xu2yong

<p>交作业：</p><p>

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

</p><p><strong><font color="#ff0033">不错</font></strong></p>

[此贴子已经被一剑惊心于2008-10-15 19:58:49编辑过]

abcd7006

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

77041035苗

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

</p><p><strong><font color="#ff0000">答案从何而来?</font></strong></p>

[此贴子已经被一剑惊心于2008-10-16 21:26:12编辑过]