|
交作业咯 3033学员
[Power=1]<p>必做题:1、=OFFSET(INDIRECT("B"&MATCH($I5,$B$3:$B$37,)+2),MATCH(J$4,$C$3:$C$7,)-1,5,,)下拉、右拉</p><p>2、=VLOOKUP($I$43,B41:F52,MATCH($I$44,B40:F40,),)或=INDEX(C41:F52,MATCH(I43,B41:B52,),MATCH(I44,C40:F40,))</p><p>3、 <table width="144" border="0" cellspacing="0" cellpadding="0" style="WIDTH: 108pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="67" style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2144;"></col><col></col><col width="77" style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2464;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td width="144" height="19" class="xl66" colspan="2" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff; WIDTH: 108pt; HEIGHT: 14.25pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">查找辅助区域</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">成绩</font></td><td class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ccffff; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">考评结果</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="Helv" size="2">0</font></td><td class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ccffff; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="Helv" size="2">不及格</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="Helv" size="2">60</font></td><td class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ccffff; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="Helv" size="2">合格</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="Helv" size="2">70</font></td><td class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ccffff; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="Helv" size="2">中</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="Helv" size="2">80</font></td><td class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ccffff; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="Helv" size="2">良</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" class="xl66" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ccffff; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="宋体" size="2">90</font></td><td class="xl67" style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #ccffff; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid;"><font face="Helv" size="2">优</font></td></tr></tbody></table>=LOOKUP(C56,$F$65:$G$69)下拉</p><p>4、=INDIRECT("B"&ROW($B$72)+(ROW()-74)*2+COLUMN(B2)-2)下拉右拉</p><p>选做题:1、=INDIRECT("r"&ROUNDUP(ROW(A1)/3,)+4&"c"&MOD(ROW(A1)-1,3)+2,)下拉</p><p>2、=VLOOKUP("*"&F24&"*",IF({1,0},$C$24:$C$31,$B$24:$B$31),2,)下拉</p><p><font color="#ee3d11">全对!</font></p><p><font color="#ee3d11">——dgxsdr</font></p>[/Power]
[此贴子已经被dgxsdr于2010-6-20 19:53:34编辑过] |
|