【会计四期】第八讲补交作业贴

無心

<p><font size="5">请写明补交原因，组号，学号，</font></p><p><font size="5">与2010年7月12日星期一17:00锁帖。</font></p><p><font size="5">之后未交作业同学，一律按班规处分。</font></p><p><font size="5">作业请使用威望帖，威望设置为1。</font></p><p><font size="4">（请不是本班级的不要跟帖，否则一律删帖）</font></p><br/><script type="text/javascript"></script><script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"></script><script></script>

zhanglijun_1

[Power=1]<p>02020&nbsp; zhanglijun_1</p><p>补交作业，因单位加班不能上网未能按时交作业,请老师原谅。</p> gLDn0vV1.rar (29 KB, 下载次数: 1)

2010-7-11 23:43 上传

点击文件名下载附件
【会计四期】第八讲补交作业贴 <br/>[/Power]

[此贴子已经被tkgg93于2010-7-12 8:10:34编辑过]

hnnyfcykl

[Power=1]<p>补交作业，因单位工作忙未能按时交作业,请领导原谅。</p>01001 hnnyfcykl<br/> vKshIlt8.rar (25.7 KB, 下载次数: 1)

2010-7-12 00:59 上传

点击文件名下载附件
【会计四期】第八讲补交作业贴 <br/>[/Power]

wen191244510

[Power=1]<p>1、选中：B5：E14，自动筛选。在品名中选 中A产品和空白就OK了</p><p>2、总数：=SUMPRODUCT(SUBTOTAL(9,OFFSET($H$23:$H$34,ROW($H$1:$H$12)-1,-1,1)))</p><p>正品、赠品、 促销品==SUMPRODUCT(($H$23:$H$34=C20)*SUBTOTAL(9,OFFSET($H$23:$H$34,ROW($H$1:$H$12)-1,-1,1)))右拉&nbsp; 正品合计：=SUMIF(H23:H34,"正品",G23:G34)‘赠品合计：=SUMIF(H23:H34,"赠品",G23:G34)</p><p>3、高级筛选：条件格式为 <table border="0" cellspacing="0" cellpadding="0" width="144" style="WIDTH: 108pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="2" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl65" height="19" width="72" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 54pt; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">品种</font></td><td class="xl65" width="72" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">客户</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl66" height="19" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">EP佳酒四星</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">　</font></td></tr></tbody></table>OR <table border="0" cellspacing="0" cellpadding="0" width="144" style="WIDTH: 108pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="2" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl66" height="19" width="72" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 54pt; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">　</font></td><td class="xl65" width="72" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">客户</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl67" height="19" align="center" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2">TRUE</font></td><td class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2">　</font></td></tr></tbody></table></p><p>4、高级筛选的条件： <table border="0" cellspacing="0" cellpadding="0" width="97" style="WIDTH: 73pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="97" style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3104;"></col></colgroup><tbody><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl63" height="17" width="97" align="center" style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 73pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8;"><font size="2">=NOT(OR(LEFT(B59,1)="公",LEFT(B59,1)="东",LEFT(B59,1)="北"))</font></td></tr></tbody></table>或者 <table border="0" cellspacing="0" cellpadding="0" width="216" style="WIDTH: 162pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="3" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl65" height="19" width="72" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 54pt; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><a name="RANGE!B36:D37"><font size="2" face="宋体">姓名</font></a></td><td class="xl65" width="72" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">姓名</font></td><td class="xl65" width="72" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font size="2" face="宋体">姓名</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl66" height="19" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">&lt;&gt;*公*</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">&lt;&gt;*东*</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体">&lt;&gt;*北*</font></td></tr></tbody></table></p><p>5、选中有隐藏的区域，指向行号，变为黑十字后双击鼠标。另一种就是取消筛选。</p><p>图表没听明白。</p>[/Power]

yiyi_1221

[Power=1]<p>01007：yiyi_1221 </p><p>又晚交作业了，哎~ 作业有一点难，我还不够努力~！</p><p> ltOtofBp.rar (38.11 KB, 下载次数: 1)

2010-7-12 16:01 上传

点击文件名下载附件
【会计四期】第八讲补交作业贴 <br/></p>[/Power]

wyfleiyang

[Power=1] dXnAQQ1a.rar (23.4 KB, 下载次数: 1)

2010-7-12 16:20 上传

点击文件名下载附件
【会计四期】第八讲补交作业贴 <br/>[/Power]

呐记忆

[Power=1] lLGEDytJ.rar (29.3 KB, 下载次数: 1)

2010-7-12 16:31 上传

点击文件名下载附件
【会计四期】第八讲补交作业贴 <br/>[/Power]