函数中级班练习题：编序号!

小笨蛋

<font color="#ff00ff"><strong><div class="msgheader">QUOTE:</div><div class="msgborder"><p><font color="#ff00ff"><strong>欢迎各位参与,前5名10个BB,</strong></font></p><p><font color="#ff00ff"><strong>请用回复贴上交答案,谢谢,附件有说明!</strong></font></p></div></strong></font> 8ZdiBfBp.rar (1.66 KB, 下载次数: 79)

2008-7-10 13:08 上传

点击文件名下载附件
函数中级班练习题：编序号! <br/>

xchw1818

<table cellspacing="0" cellpadding="0" width="216" border="0" xstr="" style="WIDTH: 162pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="3" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl22" width="72" height="23" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="MingLiU">部门</font></td><td class="xl22" width="72" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="MingLiU">客户</font></td><td class="xl22" width="72" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="MingLiU">序号</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39579" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="MingLiU">5月11日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="MingLiU">小明</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="MingLiU">1</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39579" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="MingLiU">5月11日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="MingLiU">小明</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="MingLiU">1</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39580" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="MingLiU">5月12日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">李刚</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">1</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39580" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月12日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">小明</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">2</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39580" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月12日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">小明</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">2</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39581" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月13日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">小明</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">3</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39581" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月13日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">小明</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">3</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39584" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月16日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">小明</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">4</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39586" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月18日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">小明</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">5</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39587" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月19日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">王五</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">1</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39587" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月19日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">王五</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">1</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39588" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月20日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">王五</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">2</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39589" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月21日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">李刚</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">2</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39589" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月21日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">李刚</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">2</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39589" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月21日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">小明</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">6</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39590" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月22日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">李刚</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">3</font></td></tr><tr height="23" style="HEIGHT: 17.25pt;"><td class="xl23" height="23" xnum="39595" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 17.25pt; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">5月27日</font></td><td class="xl22" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent;"><font face="PMingLiU">李刚</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: aqua;"><font face="PMingLiU">4</font></td></tr></tbody></table><p></p><p></p><p>这里的参考数据跟要求不一样呀..........(那个6)</p>

wayy

等着学习。[em04]

kachayu

学习

canlly

游客，如果您要查看本帖隐藏内容请回复

锐欣阁

<p>不会做</p>[em06]

MXQCHINA

<p>

游客，如果您要查看本帖隐藏内容请回复

</p>

willin2000

<p>学习一下.</p><p>

游客，如果您要查看本帖隐藏内容请回复

suye1010

看看，没有思路……

小笨蛋

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>willin2000</i>在2008-7-10 17:51:00的发言：</b><br/><p>学习一下.</p><p></p></div><p></p>[em17]学习了[em17]