【会计四期】第十讲上交作业贴（1-22号）

無心

<p><font size="5">请大家使用威望帖交作业，不要用回复可见，如果没交正确，可以重复编辑，不要重复发贴。</font></p><p><font color="#000000" size="5"><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=129699" target="_blank">威望帖的发帖方法</a></font></p><p><font size="3"><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;"><p><strong></strong></p></span></font></p><p><strong></strong></p><p></p><p><strong></strong></p><p></p><p><strong></strong></p><p></p><p><strong></strong></p><p></p><p><strong></strong></p><p></p><p><strong></strong></p><p></p><p><strong></strong></p><p></p><p><strong></strong></p><p></p><p><strong></strong></p><p></p><p><strong></strong></p><p></p><p><strong></strong></p><p><strong></strong></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><span><strong><font color="#3300ff">1、<font color="#ff0066">非本班成员严禁回复</font>，一经发现按抄袭论处，删贴扣币币；</font></strong></span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;"><strong><font color="#3300ff"><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></strong><br/>&nbsp;&nbsp;&nbsp;&nbsp; <p><strong><font color="#3300ff"></font></strong></p></span></font></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p><strong><font color="#3300ff"></font></strong></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><span><strong><font color="#3300ff">2、作业上交截止时间为<font color="#ff0066">本周日下午17点</font>；</font></strong></span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;"><strong><font color="#3300ff"><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></strong><br/>&nbsp;&nbsp;&nbsp;&nbsp; <p><strong><font color="#3300ff"></font></strong></p></span></font></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p><strong><font color="#3300ff"></font></strong></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><font size="3"><span><strong><font color="#3300ff">3、<font color="#ff0066">交白卷的视为未交作业</font>；</font></strong></span><span lang="EN-US" style="COLOR: #ff6600; FONT-FAMILY: tahoma;"><strong><font color="#3300ff"><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></strong><br/>&nbsp;&nbsp;&nbsp;&nbsp; <p><strong><font color="#3300ff"></font></strong></p></span></font></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p></p><p><strong><font color="#3300ff"></font></strong></p><p><strong><font color="#3300ff"></font></strong></p><p style="BACKGROUND: white; WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><strong><font color="#3300ff"><font size="3"><span>4、上交好<font color="#ff0066">作业后再投票</font>(非本组成员严禁投票)。</span></font><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: black; FONT-FAMILY: tahoma;"><br/></span></font></strong></p>

yuang68

[Power=1]<p>11号</p><p> bYL9hREV.rar (9.07 KB, 下载次数: 2)

2010-7-21 07:00 上传

点击文件名下载附件
【会计四期】第十讲上交作业贴（1-22号） <br/><font color="#ff3300">结果正确</font></p><p><font color="#ff3300">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></p>[/Power]

[此贴子已经被tkgg93于2010-7-25 8:08:51编辑过]

wangxiangru

<p>kkkk</p><p><font color="#ff3300">按一楼规定，扣50BB</font></p><p><font color="#ff3300">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></p>

[此贴子已经被tkgg93于2010-7-21 8:56:57编辑过]

穿拖鞋乱舞

[Power=1]<p> sUbpaodN.zip (10.19 KB, 下载次数: 1)

2010-7-21 13:45 上传

点击文件名下载附件
【会计四期】第十讲上交作业贴（1-22号） </p><p><br/><font color="#ff0000">已做题目正确</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></p>[/Power]

[此贴子已经被tkgg93于2010-7-25 8:04:56编辑过]

林玲玲

[Power=1]<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">第一题：第一步：自定义格式：</span><span lang="EN-US"><font face="Calibri">[</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">红色</span><span lang="EN-US"><font face="Calibri">][&lt;80]###;[</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">颜色</span><span lang="EN-US"><font face="Calibri">48][&lt;90]###;[</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">颜色</span><span lang="EN-US"><font face="Calibri">8]0.00;[</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">黑色</span><span lang="EN-US"><font face="Calibri">]@</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 115.5pt; TEXT-INDENT: -115.5pt; mso-char-indent-count: -11.0;"><span lang="EN-US"><span style="mso-spacerun: yes;"><font face="Calibri">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">第二步：条件</span><span lang="EN-US"><font face="Calibri">1</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">：介于</span><span lang="EN-US"><font face="Calibri">70</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">与</span><span lang="EN-US"><font face="Calibri">79</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">为粉红；条件</span><span lang="EN-US"><font face="Calibri">2</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">：介于</span><span lang="EN-US"><font face="Calibri">60</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">与</span><span lang="EN-US"><font face="Calibri">69</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">为绿色；条件</span><span lang="EN-US"><font face="Calibri">3</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">：介于</span><span lang="EN-US"><font face="Calibri">50</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">与</span><span lang="EN-US"><font face="Calibri">59</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">为蓝色</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 115.5pt; TEXT-INDENT: -115.5pt; mso-char-indent-count: -11.0;"><span lang="EN-US"><span style="mso-spacerun: yes;"><font face="Calibri">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">第三步：查找</span><span lang="EN-US"><font face="Calibri">#*</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">实体颜色为褐色</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 115.5pt; TEXT-INDENT: -115.5pt; mso-char-indent-count: -11.0;"><span lang="EN-US"><span style="mso-spacerun: yes;"><font face="Calibri">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">第二题：</span><span lang="EN-US"><font face="Calibri">=VLOOKUP(B39,$B$29:$J$35,MATCH(C39,$B$29:$J$29,),)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 115.5pt; TEXT-INDENT: -115.5pt; mso-char-indent-count: -11.0;"><span lang="EN-US"><font face="Calibri"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>=OFFSET($B$29,MATCH(B39,$B$30:$B$34,),MATCH(C39,$C$29:$J$29,),,)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 115.5pt; TEXT-INDENT: -115.5pt; mso-char-indent-count: -11.0;"><span lang="EN-US"><font face="Calibri"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>=INDEX($D$30:$H$34,MATCH(B39,$B$30:$B$34,),MATCH(C39,$D$29:$H$29,))</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 115.5pt; TEXT-INDENT: -115.5pt; mso-char-indent-count: -11.0;"><span lang="EN-US"><font face="Calibri"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>=INDIRECT("R"&amp;MATCH(B39,$B$1:$B$34,)&amp;"C"&amp;MATCH(C39,$A$29:$J$29,),)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 115.5pt; TEXT-INDENT: -115.5pt; mso-char-indent-count: -11.0;"><span lang="EN-US"><font face="Calibri"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>=SUMPRODUCT(($B$30:$B$34=B39)*($D$29:$H$29=C39)*$D$30:$H$34)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 115.5pt; TEXT-INDENT: -115.5pt; mso-char-indent-count: -11.0;"><span lang="EN-US"><span style="mso-spacerun: yes;"><font face="Calibri">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;">第三题：</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 115.5pt; TEXT-INDENT: -94.5pt; mso-char-indent-count: -9.0; mso-para-margin-left: 2.0gd;"><span lang="EN-US"><font face="Calibri">=RIGHT(B47,SUMPRODUCT(--(ISNUMBER(--MID(B47,ROW(INDIRECT("1:"&amp;LEN(B47))),1)))))</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 115.5pt; TEXT-INDENT: -94.5pt; mso-char-indent-count: -9.0; mso-para-margin-left: 2.0gd;"><span lang="EN-US"><font face="Calibri" color="#ff0000">正确</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 115.5pt; TEXT-INDENT: -94.5pt; mso-char-indent-count: -9.0; mso-para-margin-left: 2.0gd;"><span lang="EN-US"><font face="Calibri" color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></span></p>[/Power]

[此贴子已经被tkgg93于2010-7-25 8:01:33编辑过]

zhanglijun_1

[Power=1]<p> mHEttQJU.rar (8.79 KB, 下载次数: 1)

2010-7-21 16:08 上传

点击文件名下载附件
【会计四期】第十讲上交作业贴（1-22号） <br/></p><p>02020&nbsp; zhanglijun_1 第一题不会做</p><p><font color="#ff0000">已做题目正确</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></p>[/Power]

[此贴子已经被tkgg93于2010-7-25 7:59:33编辑过]

dtxczjzmp

[Power=1]<p> 0KdyIuul.zip (12.06 KB, 下载次数: 1)

2010-7-23 21:58 上传

点击文件名下载附件
【会计四期】第十讲上交作业贴（1-22号） </p><p><font color="#ff0000">第2题 公式下拉结果出错，不具通用性</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font><br/></p>[/Power]

[此贴子已经被tkgg93于2010-7-25 7:53:55编辑过]

hnnyfcykl

[Power=1]<p>01001&nbsp; hnnyfcykl 交作业 DaLtCsy2.rar (7.69 KB, 下载次数: 1)

2010-7-24 17:32 上传

点击文件名下载附件
【会计四期】第十讲上交作业贴（1-22号） <br/><font color="#ff3300">结果正确</font></p><p><font color="#ff3300">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></p>[/Power]

[此贴子已经被tkgg93于2010-7-25 7:48:52编辑过]

lgfcl1

[Power=1]<p> HBZzfTOy.rar (15.1 KB, 下载次数: 1)

2010-7-24 19:12 上传

点击文件名下载附件
【会计四期】第十讲上交作业贴（1-22号） </p><p><font color="#ff0000">第1题 好像少1种颜色</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93<br/></font></p>[/Power]

[此贴子已经被tkgg93于2010-7-25 7:44:54编辑过]

flash973

[Power=1]<p> Vr8tLZFA.zip (10.04 KB, 下载次数: 1)

2010-7-24 21:39 上传

点击文件名下载附件
【会计四期】第十讲上交作业贴（1-22号） <br/>请教了前辈才写出来的[em04]</p><p><font color="#ff0000">第1题 只见3种颜色</font></p><p><font color="#ff0000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tkgg93</font></p>[/Power]

[此贴子已经被tkgg93于2010-7-25 7:36:42编辑过]