excel段位测试中心公告征段位试题

hxqzccct · 发表于 2007-6-9 15:13

very good

大众甜品 · 发表于 2007-6-7 14:29

不好意思！我也知道做得不太好。谢谢飞雨飘关注和做这道题目！很想知道您的答案，我知道你的QQ，我来加你[em07]

封州大少 · 发表于 2007-6-7 19:27

函数题,申请6--7段好象简单了点,不行的放就5段吧 <div class="msgheader">QUOTE:</div><div class="msgborder">多表查找，还是6——7段吧。请给付10个金币                      ——————飞雨飘</div>

[此贴子已经被飞雨飘于2007-6-8 8:04:42编辑过]

ldy · 发表于 2007-6-9 12:43

比 SS= "" 还要快，虽然很简单 但能考虑到ss="" 慢的话，水平至少在8段以上 <div class="msgheader">QUOTE:</div><div class="msgborder">考题？怎么定位？           ——————飞雨飘</div>

[此贴子已经被飞雨飘于2007-6-9 14:05:40编辑过]

gvntw · 发表于 2007-6-11 14:47

<div class="msgheader">QUOTE:</div><div class="msgborder">以下是引用大众甜品在2007-6-1 19:20:00的发言： 第一次发表<div class="msgheader">QUOTE:</div><div class="msgborder">感谢提供答案，请给付十个金币                        ——————飞雨飘</div>

[此贴子已经被飞雨飘于2007-6-12 8:35:38编辑过]

ldy · 发表于 2007-6-13 08:31

ＶＢＡ题　字符串分析提供两种解法，基于字符串、基于数组　算４段吧  <div class="msgheader">QUOTE:</div><div class="msgborder">很好的四段题，但如果需要测试的话，可提高为5段题。请给付10个金币                                       ——————飞雨飘</div>

[此贴子已经被飞雨飘于2007-6-13 11:58:40编辑过]

ldy · 发表于 2007-6-13 07:15

<table class="MsoNormalTable" cellspacing="0" cellpadding="0" width="457" border="0" style="WIDTH: 343pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 0cm 0cm 0cm;"><tbody><tr style="HEIGHT: 32.25pt; mso-yfti-irow: 4;"><td style="

ADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #ccffcc; BORDER-BOTTOM-COLOR: #ece9d8; PADDING-BOTTOM: 0cm; BORDER-TOP-COLOR: #ece9d8; PADDING-TOP: 0cm; HEIGHT: 32.25pt; BORDER-RIGHT-COLOR: #ece9d8;">中高级 </td><td width="401" style="

ADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; BORDER-LEFT-COLOR: #ece9d8; BACKGROUND: #ccffcc; BORDER-BOTTOM-COLOR: #ece9d8; PADDING-BOTTOM: 0cm; WIDTH: 301pt; BORDER-TOP-COLOR: #ece9d8; PADDING-TOP: 0cm; HEIGHT: 32.25pt; BORDER-RIGHT-COLOR: #ece9d8;">SQL、EXCEL与ACCESS数据库链接、ACTIVEX控件使用、集合应用。数组高级应用、界面设置、能编写完整的EXCEL应用程序和软件 </td></tr></tbody></table>VB高级应用，运行文本中的代码，代码写在工作表中，当然也可以写在文本文件中我曾在EH提问未果，花了不少精力才搞懂。ＥＨ提问贴　<a href="http://club.excelhome.net/dispbbs.asp?BoardID=2&ID=198619&replyID=&skin=0">http://club.excelhome.net/dispbbs.asp?BoardID=2&ID=198619&replyID=&skin=0</a>金币不能一个人赚，所以暂不提供答案呵呵也让其他会员有机会可以赚答案的金币。 具体段位考试中心定 A 列             B 列<table cellspacing="0" cellpadding="0" width="489" border="0" xstr="" style="WIDTH: 367pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="120" style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 3840;"></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col width="369" style="WIDTH: 277pt; mso-width-source: userset; mso-width-alt: 11808;"></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col></colgroup><tbody><tr height="39" style="HEIGHT: 29.25pt; mso-height-source: userset;"><td class="xl24" width="120" height="39" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 90pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 29.25pt; BACKGROUND-COLOR: transparent;">100</td><td class="xl25" width="369" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 277pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">dim t</td></tr><tr height="171" style="HEIGHT: 128.25pt;"><td class="xl24" height="171" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 128.25pt; BACKGROUND-COLOR: transparent;">200</td><td class="xl26" width="369" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 277pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">sub hhh1() t= timer sheets("sheet2").cells(1,1) = 10000 for i = 1 to 10 cells(i,1)= i *100 next msgbox timer - t hhh end sub</td></tr><tr height="27" style="HEIGHT: 20.25pt;"><td class="xl24" height="27" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;">300</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">sub hhh()</td></tr><tr height="27" style="HEIGHT: 20.25pt;"><td class="xl24" height="27" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;">400</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">sheets("sheet2").cells(1,1) = 10000</td></tr><tr height="27" style="HEIGHT: 20.25pt;"><td class="xl24" height="27" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;">500</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">for i = 1 to 10</td></tr><tr height="27" style="HEIGHT: 20.25pt;"><td class="xl24" height="27" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;">600</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">cells(i,1).font.ColorIndex = 7</td></tr><tr height="27" style="HEIGHT: 20.25pt;"><td class="xl24" height="27" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;">700</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">next</td></tr><tr height="27" style="HEIGHT: 20.25pt;"><td class="xl24" height="27" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;">800</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">msgbox timer - t</td></tr><tr height="27" style="HEIGHT: 20.25pt;"><td class="xl24" height="27" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;">900</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">end sub</td></tr><tr height="27" style="HEIGHT: 20.25pt;"><td class="xl24" height="27" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;">1000</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl27" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">以上是运行后的结果</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr></tbody></table> 附件的内容与上表相同   <div class="msgheader">QUOTE:</div><div class="msgborder">先付金币先，请给付15个金币                            ——————飞雨飘</div>

[此贴子已经被飞雨飘于2007-6-13 11:53:14编辑过]

飞雨飘 · 发表于 2007-6-19 14:26

<div class="msgheader">QUOTE:</div><div class="msgborder">回复：（ldy）中高级 SQL、EXCEL与ACCESS数据库链接、...</div>    有点不明白要求。

ldy · 发表于 2007-6-20 18:39

宏表法不符合要求。添加代码法，不完全符合，因为要信任对于 Visual Basic 项目的访问，VBE 还不能有密码保护。 有点搞不懂出题的意思,所以只做了添加,COLORINDEX没做,另外地100到1000是添加在当前工作表还是SHEET2?不要在意B列代码内容，此处的代码是供最终用户修改的，想给那个表的那个单元格赋值。是由最终用户决定的。我们要做的是要让B列的代码运行。

mirinda2007 · 发表于 2007-6-22 09:19

a 

		自动登录	找回密码
密码			注册

excel段位测试中心公告征段位试题

本帖子中包含更多资源

本帖子中包含更多资源

本帖子中包含更多资源

本帖子中包含更多资源

本帖子中包含更多资源

回复：（ldy）中高级 SQL、EXCEL与ACCESS数据库链接、...

本帖子中包含更多资源