[练习题]第4讲练习-vlookup1

格子布圣诞鹿

<p>[upload=rar]viewFile.asp?ID=55879[/upload]<br/></p><p><img alt="" src="http://www.excelpx.com/skins/Default/filetype/gif.gif" width="16" style="CURSOR: pointer;"/><a title="《[公告]函入班练习题制度》&lt;br&gt;作者：格子布圣诞鹿&lt;br&gt;发表于：2008-5-12 17:14:00&lt;br&gt;最后发贴：以下是引用佳家..." href="http://www.excelpx.com/forum.php?mod=viewthread&tid=52768" target="_blank"> <font color="#0000ff">[公告]函入班练习题制度</font></a></p><p>&nbsp;</p><p><font color="#ff0033" size="4">用回复可见作答</font></p><p>答案示例：</p><p><table cellspacing="0" cellpadding="0" width="323" border="0" xstr="" style="WIDTH: 242pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="63" style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2016;"></col><col width="64" style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2048;"></col><col width="59" style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 1888;"></col><col width="69" style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2208;"></col><col width="68" style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2176;"></col></colgroup><tbody><tr height="16" style="HEIGHT: 12pt;"><td class="xl29" align="center" width="323" colspan="5" height="16" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 242pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12pt; BACKGROUND-COLOR: #ffcc99; mso-ignore: colspan;"><font face="宋体" size="2">采购表</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl30" height="16" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12pt; BACKGROUND-COLOR: #ffcc99;"><font face="宋体" size="2">项目</font></td><td class="xl30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font face="宋体" size="2">采购数量</font></td><td class="xl30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font face="宋体" size="2">单价</font></td><td class="xl30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font face="宋体" size="2">折扣</font></td><td class="xl30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font face="宋体" size="2">合计</font></td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl31" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><font color="#800080" size="2">砖</font></td><td class="xl31" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font color="#800080" size="2">125</font></td><td class="xl32" xnum="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">￥20 </font></td><td class="xl33" xnum="0.06" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">6%</font></td><td class="xl32" xnum="2350" xfmla="=B3*C3*(1-D3)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">￥2,350 </font></td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl31" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><font color="#800080" size="2">木材</font></td><td class="xl31" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font color="#800080" size="2">200</font></td><td class="xl32" xnum="10" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">￥10 </font></td><td class="xl33" xnum="0.03" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">3%</font></td><td class="xl32" xnum="1940" xfmla="=B4*C4*(1-D4)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">￥1,940 </font></td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl31" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><font color="#800080" size="2">玻璃</font></td><td class="xl31" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font color="#800080" size="2">150</font></td><td class="xl32" xnum="30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">￥30 </font></td><td class="xl33" xnum="0.12" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">12%</font></td><td class="xl32" xnum="3960" xfmla="=B5*C5*(1-D5)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">￥3,960 </font></td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl31" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><font color="#800080" size="2">砖</font></td><td class="xl31" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font color="#800080" size="2">225</font></td><td class="xl32" xnum="20" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">￥20 </font></td><td class="xl33" xnum="0.06" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">6%</font></td><td class="xl32" xnum="4230" xfmla="=B6*C6*(1-D6)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">￥4,230 </font></td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl31" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><font color="#800080" size="2">木材</font></td><td class="xl31" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font color="#800080" size="2">50</font></td><td class="xl32" xnum="10" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">￥10 </font></td><td class="xl33" xnum="0" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">0%</font></td><td class="xl32" xnum="500" xfmla="=B7*C7*(1-D7)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">￥500 </font></td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl31" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;"><font color="#800080" size="2">玻璃</font></td><td class="xl31" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font color="#800080" size="2">500</font></td><td class="xl32" xnum="30" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">￥30 </font></td><td class="xl33" xnum="0.15" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">15%</font></td><td class="xl32" xnum="12750" xfmla="=B8*C8*(1-D8)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;"><font size="2">￥12,750 </font></td></tr></tbody></table></p>

[此贴子已经被作者于2008-6-24 15:43:34编辑过]

潇湘冰月

沙发，嘻嘻

万杰

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

精灵A

<p>呵呵</p>[em01]

我自信我快乐

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

blacktulip20

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

zhqandyzs

[em01]

潇湘冰月

<p>公式：</p><p>

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

</p><p>&nbsp;</p>

花木兰

先下载