4组10讲作业上交帖

ZBKYOYO

<p><strong><font size="4">会计班4组 7月7日&nbsp; 10讲作业上交贴！交作业请用回复贴否则做作弊处理</font></strong></p><p><strong><font color="#ff3300" size="4"></font></strong></p><p><strong><font color="#ff3300" size="4">没有交作业不要跟贴，否则一律视作作弊处理。</font></strong></p>

ZBKYOYO

<p>

游客，如果您要查看本帖隐藏内容请回复

xCPwbZVQ.rar (18.15 KB, 下载次数: 21)

2008-7-8 18:03 上传

点击文件名下载附件
4组10讲作业上交帖 </p><p><font color="#ff0000">很好啊，适合自己的，就是最好的。</font></p>

[此贴子已经被秦始皇于2008-7-11 23:54:14编辑过]

jingtian

<p>&nbsp;</p><p> rFMzvygo.rar (102.67 KB, 下载次数: 18)

2008-7-10 23:06 上传

点击文件名下载附件
4组10讲作业上交帖 </p><p><br/>&nbsp;</p><p><font color="#ff0000">很漂亮，整体功能都很不错。</font></p><p><font color="#ff0000">提一点小建议：查询表里的按姓名查找了，那个工号就没必要再设有效性了，应该与其它信息一样，按姓名自动查找更合理。</font></p><br/>

[此贴子已经被北部湾于2008-7-15 12:04:30编辑过]

秦始皇

看看

北部湾

看看

jingtian

谢谢秦老师的指点!

shiwn

学习一下!

风的足迹

<p> XMNKoR8k.rar (18.32 KB, 下载次数: 6)

2008-7-12 23:37 上传

点击文件名下载附件
4组10讲作业上交帖 <br/></p><p></p><p><font color="#ff0000">大风8错，用了宏做工资条[em17]</font></p><p><font color="#ff0000">　　　　　　　　　　　　　　　　北部湾</font></p>

[此贴子已经被北部湾于2008-7-15 12:02:50编辑过]

myxiaolong

<p> Gaft1cAl.rar (22.17 KB, 下载次数: 7)

2008-7-13 07:53 上传

点击文件名下载附件
4组10讲作业上交帖 <br/></p><p><font color="#ff0000">8错，用了DSUM函数把工资汇总，方便做账<img alt="" src="http://www.excelpx.com/Skins/Default/emot/em17.gif" align="middle" border="0"/></font></p><p><font color="#ff0000">　　　　　　　　　　　　　　　　北部湾</font></p>

[此贴子已经被北部湾于2008-7-15 12:03:47编辑过]

尹娟

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">第一题：</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span lang="EN-US" style="mso-fareast-font-family: 'Times New Roman';"><span style="mso-list: Ignore;"><font face="Times New Roman">1．<span style="FONT: 7pt 'Times New Roman';">&nbsp; </span></font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">选取范围（</span><span lang="EN-US"><font face="Times New Roman">O3</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">：</span><span lang="EN-US"><font face="Times New Roman">O212</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">）</span><span lang="EN-US"><font face="Times New Roman">CRTL</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">（</span><span lang="EN-US"><font face="Times New Roman">Q3</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">：</span><span lang="EN-US"><font face="Times New Roman">Q212</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">）</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span lang="EN-US" style="mso-fareast-font-family: 'Times New Roman';"><span style="mso-list: Ignore;"><font face="Times New Roman">2．<span style="FONT: 7pt 'Times New Roman';">&nbsp; </span></font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">编辑</span><span lang="EN-US"><font face="Times New Roman">—</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">清除</span><span lang="EN-US"><font face="Times New Roman">—</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">格式</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span lang="EN-US" style="mso-fareast-font-family: 'Times New Roman';"><span style="mso-list: Ignore;"><font face="Times New Roman">3．<span style="FONT: 7pt 'Times New Roman';">&nbsp; </span></font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">编辑</span><span lang="EN-US"><font face="Times New Roman">—</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">替换</span><span lang="EN-US"><font face="Times New Roman">—</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">查找内容（</span><span lang="EN-US"><font face="Times New Roman">/</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">）</span><span lang="EN-US"><font face="Times New Roman">--</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">替换为（</span><span lang="EN-US"><font face="Times New Roman">-</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">）</span><span lang="EN-US"><font face="Times New Roman">--</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">全部替换</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span lang="EN-US" style="mso-fareast-font-family: 'Times New Roman';"><span style="mso-list: Ignore;"><font face="Times New Roman">4．<span style="FONT: 7pt 'Times New Roman';">&nbsp; </span></font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">格式</span><span lang="EN-US"><font face="Times New Roman">—</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">单元格</span><span lang="EN-US"><font face="Times New Roman">—</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">分类（日期）</span><span lang="EN-US"><font face="Times New Roman">--</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">类型（</span><span lang="EN-US"><font face="Times New Roman">3-14</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">）</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><font face="Times New Roman"></font></p></span></p><p><font face="Times New Roman"></font></p><p></p><p><font face="Times New Roman"></font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">每二题：</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman">1</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">．选取</span><span lang="EN-US"><font face="Times New Roman">G14</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">单元格</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman">2</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">．输入公式：</span><span lang="EN-US"><font face="Times New Roman">=IF(H14&gt;0,IF(LEN($O$14)&gt;0,$O14),0)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman">3</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">．将公式自制或拖动到其他需要的单元格内</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><font face="Times New Roman"></font></p></span></p><p><font face="Times New Roman"></font></p><p></p><p><font face="Times New Roman"></font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">第三题：</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">应该用数据透视表可以达到需要的效果吧，但我不太会，做了半天也没做出来。</span></p><p>&nbsp;</p><p><font color="#ff0000">8错　1、2正确但还有更简便的方法。3不能用数据透视表，而是多层函数套嵌</font></p><p><font color="#ff0000">　　知难而上，赞一个[em17]</font></p><p><font color="#ff0000">　　　　　　　　　　　　　　　　　　　　　　　　　　　　　北部湾</font></p>

[此贴子已经被北部湾于2008-7-15 12:05:50编辑过]