精英5段试题答案上传专贴

jx1680000

<p><strong><font face="Verdana" color="#61b713">paopao</font></strong></p><p><strong><font face="Verdana" color="#61b713"><table cellspacing="0" cellpadding="0" width="1120" border="0" xstr="" style="WIDTH: 843pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="61" style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 1952;"></col><col></col><col width="93" style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 2976;"></col><col></col><col width="40" style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1280;"></col><col></col><col width="55" style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1760;"></col><col></col><col width="110" style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 3520;"></col><col></col><col width="31" style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 992;"></col><col></col><col width="56" style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 1792;"></col><col></col><col width="83" style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2656;"></col><col></col><col width="72" style="WIDTH: 54pt;"></col><col></col><col width="35" style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1120;"></col><col></col><col width="32" style="WIDTH: 24pt; mso-width-source: userset; mso-width-alt: 1024;"></col><col></col><col width="98" style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3136;"></col><col></col><col width="89" style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 2848;"></col><col></col><col width="34" style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1088;"></col><col></col><col width="61" style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 1952;"></col><col></col><col width="106" style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3392;"></col><col></col><col width="54" style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1728;"></col><col></col><col width="10" style="WIDTH: 8pt; mso-width-source: userset; mso-width-alt: 320;"></col><col></col></colgroup><tbody><tr height="20" style="HEIGHT: 15pt; mso-height-source: userset;"><td class="xl23" width="1120" colspan="18" height="20" style="BORDER-RIGHT: #ff6600 1.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #ff6600 1.5pt solid; WIDTH: 843pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="黑体" color="#ff6600">第十七问:在纵向A4纸上打印数据区（B64:R78）</font></td></tr><tr height="20" style="HEIGHT: 15pt; mso-height-source: userset; mso-outline-level: 1;"><td class="xl29" width="1120" colspan="18" height="20" style="BORDER-RIGHT: #ff6600 1.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #ff6600 1.5pt solid; WIDTH: 843pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">要求:不调页边距,不调列宽行高.</font></td></tr><tr height="20" style="HEIGHT: 15pt; mso-height-source: userset; mso-outline-level: 1;"><td class="xl26" width="1120" colspan="18" height="20" style="BORDER-RIGHT: #ff6600 1.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #ff6600 1.5pt solid; WIDTH: 843pt; BORDER-BOTTOM: #d4d0c8 0.5pt; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font size="2"><font color="#ff0000"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp; </span>注: 不需文字说明,只要达到预览在一张纸上就可.</font></font></font></td></tr></tbody></table></font></strong></p><p></p><p>这个没有达到要求！</p><p>&nbsp;</p><p>楼上几位好强呀！</p><p>后生可畏！！！</p><p>心里都害怕了，我晕！</p>

[此贴子已经被作者于2007-4-16 15:26:29编辑过]

戏子

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>jx1680000</i>在2007-4-16 15:23:59的发言：</b><br/><p><strong><font face="Verdana" color="#61b713">paopao</font></strong></p><p><strong><font face="Verdana" color="#61b713"><table cellspacing="0" cellpadding="0" width="1120" border="0" xstr="" style="WIDTH: 843pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="61" style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 1952;"></col><col></col><col></col><col></col><col width="93" style="WIDTH: 70pt; mso-width-source: userset; mso-width-alt: 2976;"></col><col></col><col></col><col></col><col width="40" style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1280;"></col><col></col><col></col><col></col><col width="55" style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1760;"></col><col></col><col></col><col></col><col width="110" style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 3520;"></col><col></col><col></col><col></col><col width="31" style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 992;"></col><col></col><col></col><col></col><col width="56" style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 1792;"></col><col></col><col></col><col></col><col width="83" style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2656;"></col><col></col><col></col><col></col><col width="72" style="WIDTH: 54pt;"></col><col></col><col></col><col></col><col width="35" style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1120;"></col><col></col><col></col><col></col><col width="32" style="WIDTH: 24pt; mso-width-source: userset; mso-width-alt: 1024;"></col><col></col><col></col><col></col><col width="98" style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3136;"></col><col></col><col></col><col></col><col width="89" style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 2848;"></col><col></col><col></col><col></col><col width="34" style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1088;"></col><col></col><col></col><col></col><col width="61" style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 1952;"></col><col></col><col></col><col></col><col width="106" style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3392;"></col><col></col><col></col><col></col><col width="54" style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1728;"></col><col></col><col></col><col></col><col width="10" style="WIDTH: 8pt; mso-width-source: userset; mso-width-alt: 320;"></col><col></col><col></col><col></col></colgroup><tbody><tr height="20" style="HEIGHT: 15pt; mso-height-source: userset;"><td class="xl23" width="1120" colspan="18" height="20" style="BORDER-RIGHT: #ff6600 1.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #ff6600 1.5pt solid; WIDTH: 843pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="黑体" color="#ff6600">第十七问:在纵向A4纸上打印数据区（B64:R78）</font></td></tr><tr height="20" style="HEIGHT: 15pt; mso-height-source: userset; mso-outline-level: 1;"><td class="xl29" width="1120" colspan="18" height="20" style="BORDER-RIGHT: #ff6600 1.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #ff6600 1.5pt solid; WIDTH: 843pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">要求:不调页边距,不调列宽行高.</font></td></tr><tr height="20" style="HEIGHT: 15pt; mso-height-source: userset; mso-outline-level: 1;"><td class="xl26" width="1120" colspan="18" height="20" style="BORDER-RIGHT: #ff6600 1.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #ff6600 1.5pt solid; WIDTH: 843pt; BORDER-BOTTOM: #d4d0c8 0.5pt; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font size="2"><font color="#ff0000"><font face="宋体"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp; </span>注: 不需文字说明,只要达到预览在一张纸上就可.</font></font></font></td></tr></tbody></table></font></strong></p><p></p><p>这个没有达到要求！</p><p>&nbsp;</p><p>楼上几位好强呀！</p><p>后生可畏！！！</p><p>心里都害怕了，我晕！</p><br/></div><p></p><p>&nbsp;</p><p>技巧中这题算是最简单的啦</p><p>呵呵~~</p>

lpz001

<p><br/></p><p>技巧题是我的弱项，我也不知猴年马月能做出来，先传上函数与VBA的答案，聊以自慰！</p><p>[em04][em04]</p><p>===================================</p><p>【VBA】通过&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----element</p><p>===================================</p><p>********************************************************</p><p>&nbsp;&nbsp;&nbsp; [函数]&nbsp; 函数3错误.</p><p><font color="#ff0000" size="5">请继续努力.</font>&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; ----笔锋侠</p><p>********************************************************</p>

[此贴子已经被bifengxia于2007-4-17 14:23:54编辑过]

超级兔子

<p><br/>最后交VBA。前面的批注得到了不少提示[em07]</p><p>********************************************************</p><p><font color="#ff0000" size="5">[函数] 通过</font>&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; </p><p>&nbsp; 函数做得非常好.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----笔锋侠</p><p>********************************************************</p><p><font color="#f70909" size="4"><strong>技巧通过</strong></font></p><p><font size="2">技巧第一问有些问题,没有达下如下要求:</font></p><p><font size="2">注:如果姓名为空值，保证序号也为空值；行增加或删除"序号列"会自动更新.（"A100 1※"以此值开始）</font></p><p><font size="2">即,当姓名为空时,下面的序号和上面序号是应该是连续的.</font></p><p><font color="#f70909" size="4"><strong>VBA通过</strong><font color="#000000">[em17]</font></font></p><p>&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; ------admin</p><p><font color="#dd2c00" size="5"><strong>恭喜通过５段</strong></font></p>[em23][em23]

[此贴子已经被admin于2007-4-18 11:51:13编辑过]

zjxia889

<p><br/>

[此贴子已经被作者于2007-4-18 14:22:02编辑过]

detifo

<p>VBA2没有理解意思，现已修改完成.<font color="#ff0000">技巧好了没有人看啊？老师帮我看看吧。。</font></p><p><br/></p><p></p><p>====================================</p><p>虽然VBA2还是没用到Worksheet_Change事件，但结果正确。</p><p>【VBA】通过</p><p>====================================</p><p></p><p>********************************************************</p><p>&nbsp;&nbsp;&nbsp; [函数]&nbsp; 函数1和函数3稍微有点复杂，但结果正确。</p><p><font color="#ff0000" size="5">[函数] 通过.</font>&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; ----笔锋侠</p><p>********************************************************</p><p><font color="#ff0000"><strong>技巧通过</strong></font></p><p><font color="#ff0000"><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -------------戏子</strong></font></p><p>&nbsp;</p><p>&nbsp;</p><p><font color="#ff0000" size="5">五段通过</font></p><p><font color="#ff0000" size="5"></font>&nbsp;</p><p><font color="#ff0000" size="5">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#000000" size="2">&nbsp;&nbsp; ————飞雨飘</font></font></p>

[此贴子已经被飞雨飘于2007-4-19 12:57:27编辑过]

dlzy123

<p>刚刚过了4段，5段做的我头昏眼花，问一下，综合题可不可以用辅助列？</p>[em06]

蓝桥玄霜

<p><br/></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';"><font color="#0909f7" size="5">继续努力</font></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 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><span lang="EN-US"><font face="Times New Roman">6</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">12</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">13</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">14</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">90%</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">90%</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">16</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">17</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">VBA</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman">VBA</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">VBA</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">ComboBox1</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 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 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>

[此贴子已经被飞雨飘于2007-4-18 15:56:24编辑过]

shaoy5

<p></p><p><font face="宋体">第三题没有做好，显示了太多空格－－－－－－－－还是想不出来</font></p><p><font face="宋体">第十六题没有做－－－－－－－－－－－－还是不知道怎么下手</font></p><p><font face="宋体">其它的改正了，或者简化了</font><br/></p><p>第三题其实可以直接输入就可以了，不必引用单元格区域</p><p>十六题是个选做题，无仿</p><p>技巧通过</p><p><font color="#d63108" size="5"><strong>祝贺顺利通过５段考试</strong></font></p><p>&nbsp;</p>

[此贴子已经被admin于2007-4-19 11:25:44编辑过]

杨副官

<p>还有技巧14没做 ，也交卷了，做了一天需要休息了。</p><p><br/></p><p>&nbsp;</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>可以算通过了吧．</p><p>函数ＯＫ了．</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><span lang="EN-US"><font face="Times New Roman">OK</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">VBA</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">VBA</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">ComboBox1</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 style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';"></span>&nbsp;</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';"><font color="#f70909" size="5">通过！！</font></span></p>

[此贴子已经被飞雨飘于2007-4-18 16:52:46编辑过]