danielcm 发表于 2007-4-21 16:08

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

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">为了完善论坛等级考核,需要不断更新考题内容,现大量征集段位考题,请会员踊跃参加,审批版主认可后,可得到奖励。</span><span lang="EN-US" style="FONT-SIZE: 14pt;"> <p></p></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">具体要求:需注明上传得是几段题,同时附有答案,如果不附答案但题非常好,可获同等奖励。</span><span lang="EN-US" style="FONT-SIZE: 14pt;"> <p></p></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">奖励金额:</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">5000</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">金币</span><span lang="EN-US" style="FONT-SIZE: 14pt;"> <p></p></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">审批版主:飞雨飘、</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">bifengxia</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">、戏子、</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">element</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">、兰色幻想、</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">longxiang</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">、</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">admin <p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">奖励方法:跟贴上传段位考题,根据审批版主的认可奖励若干金币。</span><span lang="EN-US" style="FONT-SIZE: 14pt;"> <p></p></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">具体为:</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">1-3</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">段题每题奖</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">1~5</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">个金币</span><span lang="EN-US" style="FONT-SIZE: 14pt;"> <p></p></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; TEXT-INDENT: 21pt;"><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">4-6</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">段题每题奖</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">5~10</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">个金币</span><span lang="EN-US" style="FONT-SIZE: 14pt;"> <p></p></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; TEXT-INDENT: 21pt;"><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">6</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">段以上题每题奖</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">10~20</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">个金币</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman"><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;</span> <p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; TEXT-INDENT: 21pt;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">另注:如出题精彩,另嘉奖</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">20~50</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">个不等金币</span><span lang="EN-US" style="FONT-SIZE: 14pt;"> <p></p></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">审批时间:跟贴3天内审批。</span><span lang="EN-US" style="FONT-SIZE: 14pt;"> <p></p></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">发放期限:审批3天内发放</span><span lang="EN-US" style="FONT-SIZE: 14pt;"> <p></p></span></p><p></p><p></p><p></p><p></p><p></p><p></p>
[此贴子已经被admin于2007-7-1 2:01:01编辑过]

流星 发表于 2007-4-21 22:46

支持!

烟雨江南 发表于 2007-4-21 22:55

支持一下

封州大少 发表于 2007-5-5 15:17

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>laoyebin</i>在2007-5-5 13:30:16的发言:</b><br/><p>看看这道题目怎么样</p><p>&nbsp;</p><br/></p><p>大少兄提供的答案很好,<font color="#f70909">建议也奖励5个金币</font></p>
[此贴子已经被long_xiang于2007-5-6 11:59:41编辑过]

laoyebin 发表于 2007-5-5 15:35

<p>昨天在EH上还看到一道题目,做了半天没做出来</p><p>大少帮个忙做一下,传个答案上来</p><p>&nbsp;</p><br/>

hongsj0576 发表于 2007-5-6 14:08

<p>顶顶</p><p></p>

detifo 发表于 2007-4-22 21:08

<div class="msgheader">QUOTE:</div><div class="msgborder"><p>汗!请把文件改为2000格式为好.</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></div><p>不好意思,没有注意存成了2007的.重新来一个!<br/></p><p>===============================================================</p><p>不错,共计一段题两题(一段1\2算一题吧),二段题两题.合计需发放金币<font color="#ff0000" size="4">4*5=20</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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -------------飞雨飘</p>
[此贴子已经被飞雨飘于2007-4-23 8:18:43编辑过]

封州大少 发表于 2007-5-5 21:17

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>laoyebin</i>在2007-5-5 15:35:54的发言:</b><br/><p>昨天在EH上还看到一道题目,做了半天没做出来</p><p>大少帮个忙做一下,传个答案上来</p><p>&nbsp;</p><br/></div><p>劳兄,不好意思,这题不加辅助列的话我是做不了了,你另请高明吧 </p><p>关键是文本连接函数不支持数组,请熟悉VBA的朋友做一下吧,我不会</p>

封州大少 发表于 2007-5-3 14:03

<p>为网友做的一道函数题,觉得挺有意思的,看看可作几段考题否?</p><p><br/></p><p>答案不一定最佳,只供参考!</p><p>&nbsp;</p><p>这道题有一定难度,可以作为7-8段考题</p><p>建议奖励<font color="#ee1111" size="5">15</font>个金币</p>
[此贴子已经被admin于2007-5-6 13:03:49编辑过]

zjxia889 发表于 2007-4-22 07:42

页: [1] 2 3 4 5 6 7 8 9 10
查看完整版本: excel段位测试中心公告征段位试题