精英2段试题答案上传专贴(过期)

lpz001

<p>&nbsp;</p><p><br/></p><p>good ! <font color="#ef2121" size="5"><strong>通过</strong></font></p><p>函数3公式还可以更简单些.</p>

[此贴子已经被admin于2007-3-27 22:17:33编辑过]

draheart

<p>试做一下，不知道结果如何</p><p>技巧2第2问不会做[em04]</p><p>&nbsp;</p><p><br/></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 24pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">继续努力</span><span lang="EN-US" style="FONT-SIZE: 24pt; COLOR: blue;"><p></p></span></p><p><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">技巧三错了</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">,</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">其他也有没做全的</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">.</span></p>

[此贴子已经被飞雨飘于2007-3-28 14:24:35编辑过]

draheart

<p>刚才不知道为什么没有上传上来，再试试看</p><p>[em06]</p><h1><font color="#0000ff">&nbsp;继续努力</font></h1><p>技巧一未能替换为标准日期格式,技巧二第2\3题未做,技巧三错</p>

[此贴子已经被飞雨飘于2007-3-28 8:29:56编辑过]

lvyanfu

<p><br/>请指教。</p><p>&nbsp;</p><h1><font color="#0000ff">继续努力</font></h1><p>&nbsp;</p><p>技巧三错,函数二不显错误值有点穿空子,不过算对了.</p>

[此贴子已经被飞雨飘于2007-3-28 8:40:31编辑过]

chuxt

<br/><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 24pt; COLOR: red; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">通过</span><span lang="EN-US" style="FONT-SIZE: 24pt; COLOR: red;"><p></p></span></p><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">技巧一取巧了，不过有更简单的，函数二</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">$A$21</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">不行吧</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">,</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">估计是搞错了</span>

[此贴子已经被飞雨飘于2007-3-28 14:03:56编辑过]

huaweibalong

<p><br/><span style="FONT-SIZE: 24pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">继续努力</span></p><p><span style="FONT-SIZE: 24pt; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><font color="#000000">技巧三错</font></span></span></p>

[此贴子已经被飞雨飘于2007-3-28 13:58:39编辑过]

lvyanfu

<p><br/>重新上传技巧，请指正。谢谢。</p><p><span style="FONT-SIZE: 24pt; COLOR: red; FONT-FAMILY: 宋体; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">通过</span></p><p><span style="FONT-SIZE: 24pt; COLOR: red; FONT-FAMILY: 宋体; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">谢谢！</span></p>

[此贴子已经被作者于2007-3-28 14:31:50编辑过]

huaweibalong

找到原因，可惜今天不能上传了！<br/>

[此贴子已经被作者于2007-3-28 17:02:02编辑过]

gtyxx

<p><br/></p><p>技巧第3题，内容完成了，但数据前面的加无法搞出来。</p><p>请版主审查！</p><p>&nbsp;</p><p><font color="#1d1dc0" size="5">继续努力</font></p><p>函数正确,技巧题1你的转换只是显示,而不是转换实际内容.技巧2第三问怎么没做呢,技巧3没有达到题目要求.</p><p>小提示,完成技巧这三题的功能都在数据菜单中,你逐个试一下吧,看哪个是.呵呵.</p><p>&nbsp;</p>

[此贴子已经被long_xiang于2007-3-29 0:31:27编辑过]

仔仔

<p></p><p>交试卷!<br/>函数题目正确,第三题有更简单的方式</p><p><font color="#1d1dc0" size="5">继续努力</font></p><p>技巧题目1你是在取巧,如果不是有这么有规律的日期用这个方法就不行了,技巧3题目要求不能用组合,也尽量不要用手工输入的公式,这道题用基本功能就可以了,这三个技巧的解决方法都可以在数据菜单中找到,试试吧.</p><p>&nbsp;</p>

[此贴子已经被long_xiang于2007-3-29 0:37:26编辑过]