Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
楼主: 大众甜品

[通知] 数组兴趣小组练习题15

[复制链接]
发表于 2007-7-18 18:29 | 显示全部楼层

没事,反正我都不懂
excel精英培训的微信平台,每天都会发送excel学习教程和资料。扫一扫明天就可以收到新教程
回复

使用道具 举报

发表于 2007-7-18 21:37 | 显示全部楼层

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>大众甜品</i>在2007-7-18 18:07:47的发言:</b><br/>唉!没看清楚就说难了,看来都热情不高,更有甚者说我要毁了兴趣小组?以后再不敢出题了,以免丢人现眼。[em06]</div><p>题目出得挻有意思的,需要考虑一哈,才能给个答案,允许一个答题的时间吧。 </p><p>题目难才有挑战性,这样才会吸引高手出招,这样才会振兴兴趣小组啊! </p><p>欢迎多出题,有好几期没有人出题了,谢谢你出题,给大家一个大脑运动的好机会!</p>
回复

使用道具 举报

发表于 2007-7-19 14:48 | 显示全部楼层
回复

使用道具 举报

发表于 2007-7-19 16:12 | 显示全部楼层

<table cellspacing="0" cellpadding="0" width="494" border="0" xstr="" style="WIDTH: 374pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="61" style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 1952;"></col><col width="56" style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 1792;"></col><col width="62" style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 1984;"></col><col width="42" style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1344;"></col><col span="3" width="49" style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1568;"></col><col span="3" width="42" style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1344;"></col></colgroup><tbody><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl31" width="494" colspan="10" height="21" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 374pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: olive;">查询表</td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl27" height="21" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: silver;"><font face="Arial Narrow">Item No.</font></td><td class="xl28" style="BORDER-RIGHT: windowtext 2pt double; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver;"><font face="Arial Narrow">QTY</font></td><td class="xl29" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver;"><font face="Arial Narrow">O.1</font></td><td class="xl30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver;"><font face="Arial Narrow">O.2</font></td><td class="xl30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver;"><font face="Arial Narrow">O.3</font></td><td class="xl30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver;"><font face="Arial Narrow">O.4</font></td><td class="xl30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver;"><font face="Arial Narrow">O.5</font></td><td class="xl30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver;"><font face="Arial Narrow">O.6</font></td><td class="xl30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver;"><font face="Arial Narrow">O.7</font></td><td class="xl30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver;"><font face="Arial Narrow">…</font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl24" height="21" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow">12021</font></td><td class="xl26" xnum="" style="BORDER-RIGHT: windowtext 2pt double; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow">600</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow">201</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow">202</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow">385</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow"> </font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow"> </font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow"> </font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow"> </font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow"> </font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl33" height="21" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #ff9900;"><font face="Arial Narrow">25952</font></td><td class="xl34" xnum="" style="BORDER-RIGHT: windowtext 2pt double; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ff9900;"><font face="Arial Narrow">300</font></td><td class="xl35" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ff9900;"><font face="Arial Narrow">P062</font></td><td class="xl33" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ff9900;"><font face="Arial Narrow"> </font></td><td class="xl33" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ff9900;"><font face="Arial Narrow"> </font></td><td class="xl33" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ff9900;"><font face="Arial Narrow"> </font></td><td class="xl33" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ff9900;"><font face="Arial Narrow"> </font></td><td class="xl33" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ff9900;"><font face="Arial Narrow"> </font></td><td class="xl33" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ff9900;"><font face="Arial Narrow"> </font></td><td class="xl33" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ff9900;"><font face="Arial Narrow"> </font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl24" height="21" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow">25351</font></td><td class="xl26" xnum="" style="BORDER-RIGHT: windowtext 2pt double; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow">200</font></td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow">P385</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow">P388</font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow"> </font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow"> </font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow"> </font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow"> </font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow"> </font></td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="Arial Narrow"> </font></td></tr></tbody></table><p>为什么25952项,在300的库量时的号不是P055,而是P062?[em06]</p><p>&nbsp;</p>
回复

使用道具 举报

 楼主| 发表于 2007-7-19 17:12 | 显示全部楼层

<p>回复jssy :<br/>因为此单已经出完,即L3处的2500是先出P055的数1000PCS,剩下的1500PCS是P062的,最后得到P062还剩500PCS没出,所以答案就是P062了。</p>
回复

使用道具 举报

发表于 2007-7-19 17:39 | 显示全部楼层

占位先...
回复

使用道具 举报

 楼主| 发表于 2007-7-21 11:13 | 显示全部楼层

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>xhsdham</i>在2007-7-20 22:59:11的发言:</b><br/><p>偶是实在理解不了题意</p><p>可以给个清晰明了的表达吗</p><p></p></div><p></p>已经再次修改,请下载!这次我想是最后一次修改了,如果还是看不懂的话,只好一个星期后提供答案。
回复

使用道具 举报

发表于 2007-7-20 22:59 | 显示全部楼层

<p>偶是实在理解不了题意</p><p>可以给个清晰明了的表达吗</p><p></p>
回复

使用道具 举报

 楼主| 发表于 2007-7-23 08:42 | 显示全部楼层

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>Luckyguy2008</i>在2007-7-22 10:29:35的发言:</b><br/>没做过库存管理,所以不太明白题意[em06][em06][em06]</div><p>&nbsp;</p><p>各位不好意思!出了一道自己才能明白题意的题目,答案已经上传,请大家参考一下。我的答案并不一定是唯一的答案,还是希望能够看到更多的思路,谢谢!</p>
回复

使用道具 举报

发表于 2007-7-22 10:29 | 显示全部楼层

没做过库存管理,所以不太明白题意[em06][em06][em06]
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2025-8-16 05:36 , Processed in 0.376527 second(s), 5 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表