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

南仁海杨

<p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;"><font size="5"><strong>8组的同学请来此上交作业<span lang="EN-US">，</span></strong></font></span> </p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><span lang="EN-US" style="FONT-SIZE: 9pt;">&nbsp;<font size="3"><strong><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">作业上交要求：</span></strong></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></p><p></p><p></p><p></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></p><p></p><p></p><p></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="5"><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><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></font></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>

xiaoni

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

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

[此贴子已经被一剑惊心于2008-11-5 22:24:16编辑过]

秋雨潇潇

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

&nbsp;&nbsp; 千呼万唤始出来，希望有个好成绩。</p><p><strong><font color="#ff0000">结果OK,但方法略显繁琐</font></strong></p>

[此贴子已经被一剑惊心于2008-11-5 22:25:43编辑过]

xiaoni

<p>老师第2问的条件格式，我写了公式忘记设置字体颜色、红色，加粗了。</p>

一剑惊心

标记

忧蓝

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

[此贴子已经被一剑惊心于2008-11-6 19:09:24编辑过]

DDCLJ

<p>作业答案：</p><p>

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

</p><p><strong><font color="#ff0000">很棒</font></strong></p>

[此贴子已经被一剑惊心于2008-11-6 19:10:40编辑过]

yyhangeng

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">

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

<font color="#0000ff">来源公式复杂化了</font></span></p></font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;">选中</span><span lang="EN-US">C5</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;">单元格，点击“数据”——“数据有效性”——“设置”，在“允许”选择“序列”，在“来源”中输入公式“</span><span lang="EN-US">=INDIRECT("</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;">数据</span><span lang="EN-US">!$A$1:$F$1")</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;">”，确定。剩下的不懂了，请老师多多指教</span><span lang="EN-US">[/hide]<font color="#0000ff">来源公式复杂化了</font></span></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;">选中</span><span lang="EN-US">C5</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;">单元格，点击“数据”——“数据有效性”——“设置”，在“允许”选择“序列”，在“来源”中输入公式“</span><span lang="EN-US">=INDIRECT("</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;">数据</span><span lang="EN-US">!$A$1:$F$1")</span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;">”，确定。剩下的不懂了，请老师多多指教</span><span lang="EN-US">[/hide]</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font color="#ff0033"><strong>加油</strong></font></span></p>

[此贴子已经被一剑惊心于2008-11-6 19:14:08编辑过]

sunshine-jn

学习学习

yanzixin121

[em05]