Excel精英培训网

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

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

[复制链接]
发表于 2010-6-30 12:07 | 显示全部楼层 |阅读模式
<div style="LINE-HEIGHT: 22px; HEIGHT: 22px;"><div style="FLOAT: left;"><img alt="发贴心情" src="http://www.excelpx.com/skins/Default/topicface/face1.gif"/></div><b>【会计四期】第七讲上交作业贴(1-22号)</b></div><div style="LINE-HEIGHT: normal; MARGIN-TOP: 10px; TEXT-INDENT: 24px; MIN-HEIGHT: 200px; WORD-WRAP: break-word; FONT-SIZE: 9pt; WORD-BREAK: break-all;"><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-FAMILY: tahoma; COLOR: black; FONT-SIZE: 9pt;">
                                        <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><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="TEXT-INDENT: 18pt; BACKGROUND: white; WORD-BREAK: break-all;"><font size="3"><span><strong><font color="#3300ff">1、<font color="#ff0066">非本班成员严禁回复</font>,一经发现按抄袭论处,删贴扣币币;</font></strong></span><span lang="EN-US" style="FONT-FAMILY: tahoma; COLOR: black; FONT-SIZE: 9pt;"><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></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="TEXT-INDENT: 18pt; BACKGROUND: white; WORD-BREAK: break-all;"><font size="3"><span><strong><font color="#3300ff">2、作业上交截止时间为<font color="#ff0066">本周日下午17点</font>;</font></strong></span><span lang="EN-US" style="FONT-FAMILY: tahoma; COLOR: black; FONT-SIZE: 9pt;"><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></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="TEXT-INDENT: 18pt; BACKGROUND: white; WORD-BREAK: break-all;"><font size="3"><span><strong><font color="#3300ff">3、<font color="#ff0066">交白卷的视为未交作业</font>;</font></strong></span><span lang="EN-US" style="FONT-FAMILY: tahoma; COLOR: #ff6600;"><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></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="TEXT-INDENT: 18pt; BACKGROUND: white; WORD-BREAK: break-all;"><strong><font color="#3300ff"><font size="3"><span>4、上交好<font color="#ff0066">作业后再投票</font>(非本组成员严禁投票)。</span></font><span lang="EN-US" style="FONT-FAMILY: tahoma; COLOR: black; FONT-SIZE: 9pt;">
                                        </span></font></strong></p></div>
单选投票, 共有 16 人参与投票

距结束还有: 4936 天4 小时10 分钟

您所在的用户组没有投票权限
excel精英培训的微信平台,每天都会发送excel学习教程和资料。扫一扫明天就可以收到新教程
发表于 2010-6-30 12:15 | 显示全部楼层

[Power=1]<p>沙发</p><p>第三题,老师不准用他的公式,只好修改一下了</p><p>=mod(SUM(--($E$29:$E29&lt;&gt;$E$30:$E30)),2)&nbsp; 把n改成-- </p><p>好象变化不大 又改成=mod(SUMPRODUCT(--($E$29:$E29&lt;&gt;$E$30:$E30)),2)</p><p>变化还不大 再改成=iseven(SUMPRODUCT(--($E$29:$E29&lt;&gt;$E$30:$E30))) 其实公式原理都是一样的</p><p> JQ3ljC6w.rar (19.88 KB, 下载次数: 2)

mPZjtabQ.rar

19.75 KB, 下载次数: 2

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

回复

使用道具 举报

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

02021林玲玲

[Power=1]<p>&nbsp;<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">$B$6:$D$12<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp; </span></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">=AND($C6="</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">",$D6&lt;30)<span style="mso-spacerun: yes;">&nbsp;&nbsp; </span></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><span lang="EN-US"><font face="Calibri">$B$18:$D$24<span style="mso-spacerun: yes;">&nbsp;&nbsp; </span></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">=ISNUMBER(FIND(" ",$B18))</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><span lang="EN-US"><font face="Calibri">$B$30:$E$56</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><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=MOD(INT(SUM(1/COUNTIF($E$30:$E30,$E$30:$E30))),2)=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></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt;"><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=MOD(INT(SUM(1/COUNTIF($E$30:$E30,$E$30:$E30))),2)<span style="mso-spacerun: yes;">&nbsp;&nbsp; </span></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"><span style="mso-spacerun: yes;"><font face="Calibri">&nbsp;&nbsp;&nbsp; </font></span></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><span lang="EN-US"><font face="Calibri">$B$61:$B$65<span style="mso-spacerun: yes;">&nbsp; </span></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">=C61&gt;=LARGE($B$61:$G$65,3)<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp; </span></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;">选颜色为灰色&nbsp; </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;">&nbsp;&nbsp;&nbsp; </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">$D$61:$D$65<span style="mso-spacerun: yes;">&nbsp; </span></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">=E61&gt;=LARGE($B$61:$G$65,3)<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp; </span></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; TEXT-INDENT: 20.25pt;"><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">$F$61:$F$65<span style="mso-spacerun: yes;">&nbsp;&nbsp; </span></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">=G61&gt;=LARGE($B$61:$G$65,3)<span style="mso-spacerun: yes;">&nbsp;&nbsp; </span></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; TEXT-INDENT: 20.25pt;"><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;">重做第四题按顺序选$F$61:$F$65+$D$61:$D$65+$B$61:$B$65&nbsp; 公式=C61&gt;=LARGE($C$61:$G$65,3)</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 20.25pt;"><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>

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

【会计四期】第七讲上交作业贴(1-22号)
<br/><font color="#ff0000">第4题不适宜多区域,其它结果正确,第5题是按姓名排序,错误</font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 20.25pt;"><font color="#ff0000"></font>&nbsp;</p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 20.25pt;"><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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;tkgg93</font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 20.25pt;"><font color="#ff0000"></font>&nbsp;</p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 20.25pt;">&nbsp;

02021林玲玲

02021林玲玲
<br/></p>[/Power]
[此贴子已经被作者于2010-7-4 16:04:52编辑过]

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

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

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

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

使用道具 举报

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

01012交作业 请批阅 辛苦了

[Power=1]<p>第三题不用老师公式 搞不定 OTZ 还是依葫芦画瓢了...</p><p> R0xXzbPo.zip (18.22 KB, 下载次数: 1)
回复

使用道具 举报

发表于 2010-6-30 22:37 | 显示全部楼层

0217上交第七讲作业

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

使用道具 举报

发表于 2010-7-3 17:00 | 显示全部楼层

01005flash973

[Power=1]<p>因这段时间有些忙,还来不及看课件,先把会做的交了,</p><p>&nbsp;</p><p> 1c6E2gvy.zip (17.44 KB, 下载次数: 1)
回复

使用道具 举报

发表于 2010-7-3 21:11 | 显示全部楼层

我能浏览吗?
回复

使用道具 举报

发表于 2010-7-4 15:04 | 显示全部楼层

[Post=0][/Post]不知为什么?交的变成两次了。
[此贴子已经被作者于2010-7-4 15:16:38编辑过]
回复

使用道具 举报

发表于 2010-7-4 15:04 | 显示全部楼层

[Power=1]<p>01001 qYvIDHAG.rar (17.12 KB, 下载次数: 5)
回复

使用道具 举报

发表于 2010-7-4 16:42 | 显示全部楼层

02017交作业

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

使用道具 举报

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

本版积分规则

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

GMT+8, 2024-5-10 07:56 , Processed in 0.308812 second(s), 9 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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