【会计四期】第四讲上交作业贴（23-44号）

無心

<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>&nbsp;<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><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">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">
                                        </font></strong><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><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">
                                        </font></strong><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><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">
                                        </font></strong><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><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;">
                                </span></font></strong></p><br/><script type="text/javascript"></script><script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"></script><script></script>

林玲玲

<p>[Power=1]</p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><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">=VLOOKUP(J$4,OFFSET($B$2,MATCH($I5,$B$3:$B$37,0),1,5,5),5,0)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">2=VLOOKUP(I43,B41:F52,MATCH(I44,B40:F40,),) =INDEX(C41:F52,MATCH(I43,B41:B52,),MATCH(I44,C40:F40,))</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><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">=VLOOKUP(C56,$F$65:$G$69,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">0</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">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">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">90</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Calibri">4</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">=INDIRECT("B"&amp;ROW()*2-76+COLUMN(A1)-1)</font></span></p><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></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><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">=OFFSET($B$5,INT((ROW(A1)-1)/3),MOD(ROW(A1)-1,3),,)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><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">=VLOOKUP("*"&amp;F24&amp;"*",CHOOSE({1,2},$C$24:$C$31,$B$24:$B$31),2,)</font></span></p><p><p>[/Power]</p></p>

小灰太狼

<p>[Power=1] 66stcGFE.rar (20.27 KB, 下载次数: 1)

2010-6-8 21:43 上传

点击文件名下载附件
【会计四期】第四讲上交作业贴（23-44号） </p><p><font color="#dd4822">全对！</font></p><p><font color="#dd4822">——dgxsdr</font>
                <br/>[/Power]</p>

[此贴子已经被dgxsdr于2010-6-10 13:47:47编辑过]

hwsh1002

<p>[Power=1]</p><p>谢谢老师！</p><p> 3Ii0SXQF.rar (20.66 KB, 下载次数: 1)

2010-6-9 15:14 上传

点击文件名下载附件
【会计四期】第四讲上交作业贴（23-44号） </p><p><font color="#dd2222">作业2的第2解不够通用</font></p><p><font color="#dd2222">算全对了！</font></p><p><font color="#dd2222">——dgxsdr</font></p><p><br/>[/Power]</p>

[此贴子已经被dgxsdr于2010-6-10 16:09:08编辑过]

hx910

[Power=1]<p>02028&nbsp; hx910</p><p></p><p>作业1：=VLOOKUP(J$4,OFFSET($C$3,MATCH($I5,$B$3:$B$37,0)-1,,5,5),5,0)</p><p>作业2 =OFFSET($B$40,MATCH(I43,$B$41:$B$52,0),MATCH(I44,$C$40:$F$40,0),,)&nbsp; <font color="#ff0000">单一公式时没必要用绝对引用，此处OFFSET函数的后2个参数可省略不写</font></p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =INDEX(C41:F52,MATCH(I43,$B$41:$B$52,0),MATCH(I44,$C$40:$F$40,0))</p><p>&nbsp;&nbsp;&nbsp;&nbsp; =VLOOKUP(I43,B41:F52,MATCH(I44,C40:F40)+1,0)</p><p>作业3 =LOOKUP(C56,{0,"不及格";60,"合格";70,"中";80,"良";90,"优"})</p><p>作业4 =INDIRECT("B"&amp;COLUMN(BR1)+ROW(A1)*2)</p><p>选做1&nbsp; =OFFSET($B$5,INT((ROW(A1)-1)/3),MOD(ROW(A1)-1,3),,)&nbsp; <font color="#ff0000">此处OFFSET函数的后2个参数可省略不写</font></p><p>选做2：=VLOOKUP("*"&amp;F24&amp;"*",IF({1,0},$C$24:$C$31,$B$24:$B$31),2,0)</p><p><font color="#f70909">算全对了！</font></p><p><font color="#f70909">——dgxsdr</font></p>[/Power]

[此贴子已经被dgxsdr于2010-6-10 16:21:59编辑过]

真永远

[Power=1]<p>[UserCP=1]1、=VLOOKUP(J$4,OFFSET($B$2,MATCH($I5,$B$3:$B$37,),1,5,5),5,)<br/>2、=INDEX(C41:F52,MATCH(I43,B41:B52,0),MATCH(I44,C40:F40,0))<br/>&nbsp;&nbsp;&nbsp;&nbsp;<br/><br/>=VLOOKUP(I43,B41:F52,MATCH(I44,B40:F40,1),1)&nbsp; <font color="#ee1111">慎用模糊查找</font><br/>3、=VLOOKUP($C56,$F$65:$G$69,2,1)<br/>4、=INDIRECT("B"&amp;<br/>amp;<br/>amp;2*ROW()-3+COLUMN(A70)-74)</p><p><font color="#f70909">继续努力！</font></p><p><font color="#f70909">——dgxsdr</font></p><p>[/UserCP]</p>[/Power]

[此贴子已经被dgxsdr于2010-6-14 16:56:15编辑过]

EZD

<p>[Power=1]</p><p></p><p></p><p> ncMeCFXI.rar (22.1 KB, 下载次数: 1)

2010-6-10 09:45 上传

点击文件名下载附件
【会计四期】第四讲上交作业贴（23-44号） </p><p><font color="#ee1111">第1题有点取巧</font></p><p><font color="#ee1111">第4题和选作1都可以再简化一下！</font></p><p><font color="#ee1111">总体不错！</font></p><p><font color="#ee1111">——dgxsdr</font></p><p><br/>[/Power]</p>

[此贴子已经被dgxsdr于2010-6-10 16:35:46编辑过]

随缘wy

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

2010-6-12 09:05 上传

点击文件名下载附件
【会计四期】第四讲上交作业贴（23-44号） </p><p><font color="#ff0000">全对</font></p><p><font color="#ff0000">——dgxsdr<br/></font>[/Power]</p>

[此贴子已经被dgxsdr于2010-6-14 14:32:06编辑过]

wyfleiyang

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

2010-6-12 16:30 上传

点击文件名下载附件
【会计四期】第四讲上交作业贴（23-44号） </p><p><font color="#ee1111">作业2只提供了一个公式</font></p><p><font color="#ee1111">作业3未作</font></p><p><font color="#ee1111">选作题未作</font></p><p><font color="#ee1111">继续努力！</font></p><p><font color="#ee1111">——dgxsdr<br/></font>[/Power]</p>

[此贴子已经被dgxsdr于2010-6-14 14:35:17编辑过]