[公告]excel级别测试参与指南(8段已开卷)

兰色幻想 · 发表于 2007-3-25 10:17

1-7段试题下载:http://www.excelpx.com/forum.php?mod=forumdisplay&fid=96&page=1经常了几个月的筹划,论坛Excel级别考试终于要出台了。下面是具体的说明和规则： 一、级别是怎么划分的？      把Excel分为三大功能：技巧，函数，VBA，每个功能根据难易程度分为5个级别：入门级、初级、中级、中高级和高级。然后再由这三大功能块组成11个段位，详见下表。例：考2段需要通过的测试题为“EXCEL技巧初级“和”函数入门”题。<table cellspacing="0" cellpadding="0" width="350" border="0" style="WIDTH: 263pt; BORDER-COLLAPSE: collapse;"><tbody><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" width="51" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 38pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #ffcc99;">段位</td><td class="xl24" width="93" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 70pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;">Excel技巧</td><td class="xl24" width="125" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 94pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;">函数</td><td class="xl24" width="81" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; WIDTH: 61pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;">VBA</td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl25" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #ccffcc;">1段</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">入门</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">入门</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl25" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #ccffcc;">2段</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">初级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">入门</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl25" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #ccffcc;">3段</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">初级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">初级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl25" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #ccffcc;">4段</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">初级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">入门</td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl25" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #ccffcc;">5段</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">初级</td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl25" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #ccffcc;">6段</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中级</td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl25" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #ccffcc;">7段</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中高级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中高级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中级</td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl25" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #ccffcc;">8段</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中高级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中高级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中高级</td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl25" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #ccffcc;">9段</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">高级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中高级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中高级</td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl25" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #ccffcc;">名人</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">高级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">高级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">中高级</td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl25" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #ccffcc;">天元</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">高级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">高级</td><td class="xl26" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-LEFT-COLOR: windowtext; BORDER-TOP-COLOR: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">高级</td></tr></tbody></table>

[此贴子已经被作者于2010-3-20 10:30:09编辑过]

nmgjmw · 发表于 2007-3-27 14:31

努力

lfspecter · 发表于 2007-3-27 14:53

函数题其实有很多的答案，是不是只要实现功能，得到结果就可以呢？

兰色幻想 · 发表于 2007-3-25 10:19

附：三大功能的级别说明： 1、技巧等级说明： <table class="MsoNormalTable" cellspacing="0" cellpadding="0" width="459" border="0" style="WIDTH: 344pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 0cm 0cm 0cm;"><tbody><tr style="HEIGHT: 26.25pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td width="68" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0cm; BACKGROUND: #99ccff; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 51pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt;">Excel技巧 </td><td width="391" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0cm; BACKGROUND: #99ccff; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 293pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt;">级别说明 </td></tr><tr style="HEIGHT: 31.5pt; mso-yfti-irow: 1;"><td style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 31.5pt; BACKGROUND-COLOR: transparent;">入门级 </td><td width="391" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 293pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 31.5pt; BACKGROUND-COLOR: transparent;">表格边框设置及调整、单元格输入、选取及设置、工作表操作、EXCEL界面结构调整 </td></tr><tr style="HEIGHT: 26.25pt; mso-yfti-irow: 2;"><td style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; BACKGROUND: #ffff99; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt;">初级 </td><td width="391" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; BACKGROUND: #ffff99; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 293pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt;">自动筛选、分列、分类汇总、定义名称、打印技巧、合并计算、选择性粘贴等功能的基础应用 </td></tr><tr style="HEIGHT: 26.25pt; mso-yfti-irow: 3;"><td style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent;">中级 </td><td width="391" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 293pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent;">单元格自定义格式、数据有效性、条件格式使用、高级筛选基础应用、窗体工具控箱的使用 </td></tr><tr style="HEIGHT: 26.25pt; mso-yfti-irow: 4;"><td style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; BACKGROUND: #ffff99; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt;">中高级 </td><td width="391" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; BACKGROUND: #ffff99; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 293pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 26.25pt;">图表、数据透视表熟练应用、单变量求解、高级筛选的公式设置 </td></tr><tr style="HEIGHT: 26.25pt; mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><td style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent;">高级 </td><td width="391" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 293pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent;">图表高级应用、数据透视表高级应用、规划求解等高级应用 </td></tr></tbody></table>2、函数等级说明： <table class="MsoNormalTable" cellspacing="0" cellpadding="0" width="100%" border="0" style="WIDTH: 100%; BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 0cm 0cm 0cm;"><tbody><tr style="HEIGHT: 14.25pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td width="13%" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 13%; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">入门 </td><td width="87%" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 87%; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">会用SUM MIN MAX 等函数进行基础的公式的编写，知道相对引用绝对引用的应用 </td></tr><tr style="HEIGHT: 14.25pt; mso-yfti-irow: 1;"><td width="13%" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 13%; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">初级 </td><td width="87%" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 87%; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">可以应用VLOOK,MATCH,INDEX,SUMIF,COUNTIF，FIND等函数进行基础的查询，求和 </td></tr><tr style="HEIGHT: 14.25pt; mso-yfti-irow: 2;"><td width="13%" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 13%; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">中级 </td><td width="87%" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 87%; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">可以用组合两个以上的函数进行多条件查询与求和的运算；以及数组库函数，lookup函数的综合应用；及简单数组公式的应用 </td></tr><tr style="HEIGHT: 14.25pt; mso-yfti-irow: 3;"><td width="13%" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 13%; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">中高级 </td><td width="87%" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 87%; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">掌握内存数组，熟练运用MMULT,FREQUENCY,LOOKUP,SUBTATOL等函数进行数组公式的综合应用 </td></tr><tr style="HEIGHT: 14.25pt; mso-yfti-irow: 4; mso-yfti-lastrow: yes;"><td width="13%" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 13%; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">高级 </td><td width="87%" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 87%; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">能综合应用几乎所有常用的函数进行包括三维引用，内存数组等综合的数组公式 </td></tr></tbody></table>3、VBA等级说明 <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: 22.5pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td width="56" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0cm; BACKGROUND: silver; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 42pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 22.5pt;">VBA </td><td width="401" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 0cm; BACKGROUND: silver; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 301pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 22.5pt;">级别说明 </td></tr><tr style="HEIGHT: 35.25pt; mso-yfti-irow: 1;"><td style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 35.25pt; BACKGROUND-COLOR: transparent;">入门级 </td><td width="401" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 301pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 35.25pt; BACKGROUND-COLOR: transparent;">使用宏、了解VBE编辑器、基础语句、初步使用变量、单元格、工作表的表示方法、MSGBOX、INPUTBOX函数的使用 </td></tr><tr style="HEIGHT: 32.25pt; mso-yfti-irow: 2;"><td style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; BACKGROUND: #ccffcc; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 32.25pt;">初级 </td><td width="401" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; BACKGROUND: #ccffcc; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 301pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 32.25pt;">能编写简单应用程序、自定义函数、常用语句的的熟练应用、初步使用窗体与控件、EXCEL对象常用属性、方法、对象、会使用事件程序 </td></tr><tr style="HEIGHT: 36pt; mso-yfti-irow: 3;"><td style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 36pt; BACKGROUND-COLOR: transparent;">中级 </td><td width="401" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 301pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 36pt; BACKGROUND-COLOR: transparent;">文件与文件夹处理、VBA数组的初步应用、熟悉窗体与控件操作、自定义菜单和工具栏、能熟练编写局部VBA应用程序 </td></tr><tr style="HEIGHT: 32.25pt; mso-yfti-irow: 4;"><td style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; BACKGROUND: #ccffcc; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 32.25pt;">中高级 </td><td width="401" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; BACKGROUND: #ccffcc; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 301pt; PADDING-TOP: 0cm; BORDER-BOTTOM: #ece9d8; HEIGHT: 32.25pt;">SQL、EXCEL与ACCESS数据库链接、ACTIVEX控件使用、集合应用。数组高级应用、界面设置、能编写完整的EXCEL应用程序和软件 </td></tr><tr style="HEIGHT: 31.5pt; mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><td style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 31.5pt; BACKGROUND-COLOR: transparent;">高级 </td><td width="401" style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT: 0cm; BORDER-TOP: #ece9d8; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: #ece9d8; WIDTH: 301pt; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 31.5pt; BACKGROUND-COLOR: transparent;">数据库的深层操作、类模块、API函数、OFFICE协同开发 </td></tr></tbody></table>

[此贴子已经被admin于2007-3-25 11:15:59编辑过]

兰色幻想 · 发表于 2007-3-25 10:20

二、试题是怎么出的？    为了尽量保证试题的权威性和大众性，试题是由论坛几十名版主根据自身的特长合力而出。试题答案会在本期考试结束后再行公布，期间不允许会员在论坛其他位置张贴试题答案。三、如何参加等级考试？      论坛最近新添加了试题下载和上传版块，试题到<a href="http://www.excelpx.com/forum.php?mod=forumdisplay&fid=96">『Excel竟赛与考级试题』</a>版块下载，做完后每个试题贴都会提供上传试题的贴子链接。答案上传的版块是<a href="http://www.excelpx.com/forum.php?mod=forumdisplay&fid=97">『Excel试题答案上传』 </a>版，不允许上传到非指定版块，违者取消考试资格。 <img src="http://www.excelpx.com/skins/default/filetype/jpg.gif" border="0" alt=""/>此主题相关图片如下： <a id="ImgSpan" href="http://www.excelpx.com/UploadFile/2007-3/20073259422866734.jpg" target="_blank"><img alt="按此在新窗口浏览图片" src="http://www.excelpx.com/UploadFile/2007-3/20073259422866734.jpg" border="0"/></a> 四、如何确定考试通过？      会员在指定的版块上传答案后，论坛会指派特定的版主进行阅题，通过后（90%以上正确率）会在该贴标注通过的字样，如果没有通过。则会标明“下次努力”的字样。      除上述外，论坛还会定期公布通过考试的各级别名称，并且会给通过的会员授予该段位的称号，该称号会显示在会员的头像下方。如下图： <img src="http://www.excelpx.com/skins/default/filetype/jpg.gif" border="0" alt=""/>此主题相关图片如下： <a id="ImgSpan" href="http://www.excelpx.com/UploadFile/2007-3/20073259521457404.jpg" target="_blank"><img alt="按此在新窗口浏览图片" src="http://www.excelpx.com/UploadFile/2007-3/20073259521457404.jpg" border="0"/></a>

7dong502 · 发表于 2007-3-25 10:40

支持支持！！！！[em01][em01][em01]

苦菜花 · 发表于 2007-3-25 10:52

上等级谁都喜欢！[em04]

zzhandecho · 发表于 2007-3-25 11:45

怕怕

流星 · 发表于 2007-3-25 11:50

支持

zhao_2521 · 发表于 2007-3-25 12:05

好，实在是太好了．

[此贴子已经被作者于2007-3-25 12:23:55编辑过]

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