Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
查看: 4125|回复: 14

【会计四期】第四讲上交作业贴(1-22号)

[复制链接]
发表于 2010-6-8 21:39 | 显示全部楼层 |阅读模式
<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>
单选投票, 共有 16 人参与投票

距结束还有: 4914 天7 小时59 分钟

您所在的用户组没有投票权限
发表于 2010-6-8 21:44 | 显示全部楼层

抢到沙发了

[Power=1]第一题 =OFFSET($B$2,MATCH($I5,$B$3:$B$37,0)+MATCH(J$4,$C$3:$C$7,0)-1,5)<br/>第二题 =VLOOKUP(I43,B41:F52,MATCH(I44,C40:F40)+1,0)<br/>第三题 =VLOOKUP(C56,$F$65:$G$69,2) 在辅助列成绩里分别输0 60 70 80 90<br/>第四题 =INDIRECT("b"&amp;COLUMN(A1)+ROW(A1)*2+69)<br/>选做一 =INDEX($B$5:$D$10,INT((ROW(A4)-1)/3),MOD(ROW(),3)+1)<br/>选做二 =VLOOKUP("*"&amp;F24&amp;"*",IF({1,0},$C$24:$C$31,$B$24:$B$31),2,) <p> nuU6MMRT.rar (20.72 KB, 下载次数: 1)

Pvuwx5Fi.rar

20.72 KB, 下载次数: 1

抢到沙发了

回复

使用道具 举报

发表于 2010-6-8 21:44 | 显示全部楼层

02021林玲玲

[Power=2]<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>&nbsp;&nbsp;&nbsp;&nbsp;<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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 正确</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;&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-6-14 16:39:36编辑过]
回复

使用道具 举报

发表于 2010-6-9 12:06 | 显示全部楼层

2组 016 lgfcl1

<p>[Power=1] gQWEHhEc.rar (20.86 KB, 下载次数: 1)
回复

使用道具 举报

发表于 2010-6-9 14:14 | 显示全部楼层

01012 交作业,请批阅,辛苦了

[Power=2]<p>&nbsp; 9iD3iRRT.rar (23 KB, 下载次数: 1)
回复

使用道具 举报

发表于 2010-6-9 21:28 | 显示全部楼层

01005flash973

[Power=2]<p> KpcLU91F.zip (20.52 KB, 下载次数: 1)
回复

使用道具 举报

发表于 2010-6-9 21:40 | 显示全部楼层

[Power=2]<p></p><p>谢谢学委!</p><p><font color="#0000ff">选做题1可考虑用offset</font><br/></p><p>&nbsp;</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; 正确</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; tkgg93</font><br/></p>[/Power]
[此贴子已经被tkgg93于2010-6-14 16:42:24编辑过]
回复

使用道具 举报

发表于 2010-6-10 02:35 | 显示全部楼层

02017上交第四讲作业

<p>[Power=1] 1HzKn1OZ.zip (21.03 KB, 下载次数: 1)
回复

使用道具 举报

发表于 2010-6-10 21:26 | 显示全部楼层

1组 013号 echolan 交作业

[Power=2]<p> eDNRCmWl.rar (20.74 KB, 下载次数: 1)
回复

使用道具 举报

发表于 2010-6-11 11:12 | 显示全部楼层

1组 002号 w8888822 交作业

<p>[Power=1] bWeEu2Gu.zip (20.82 KB, 下载次数: 1)
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-5-10 13:39 , Processed in 0.392796 second(s), 9 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表