<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 11pt; FONT-FAMILY: 宋体; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥;">第一题:</span><font face="Times New Roman"><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;">B12=</span><span lang="EN-US"> </span><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;">SUM(B6:B11)</span></font><span style="FONT-SIZE: 11pt; FONT-FAMILY: 宋体; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥;">;</span><font face="Times New Roman"><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;">C6=</span><span lang="EN-US"> </span><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;">C$12/$B$12*$B6</span></font><span style="FONT-SIZE: 11pt; FONT-FAMILY: 宋体; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥;">;</span><font face="Times New Roman"><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;">G6=</span><span lang="EN-US"> </span><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;">G$12/$B$12*$B6 <p></p></span></font></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 11pt; FONT-FAMILY: 宋体; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥;">第二题:</span><font face="Times New Roman"><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;">B30=</span><span lang="EN-US"> </span><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;">SUMIF(A21:D29,"??R*",B21:E29) <p></p></span></font></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 11pt; FONT-FAMILY: 宋体; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥;">第三题:</span><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;"><font face="Times New Roman">A37=OFFSET($K$5,,,COUNTA($K:$K)-1) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 11pt; FONT-FAMILY: 宋体; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥;">第四题:</span><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;"><font face="Times New Roman">B37=IF($A37="","",(VLOOKUP($A37,$K$5:$L$12,2,0))) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 11pt; FONT-FAMILY: 宋体; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥;">第五题:</span><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;"><font face="Times New Roman">C48=INDEX($K$5:$K$12,MATCH(LARGE($L$5:$L$12,ROW(1:1)),$L$5:$L$12,)) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;"><font face="Times New Roman"><span style="mso-spacerun: yes;"> </span>D48=LARGE($L$5:$L$12,ROW(1:3)) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-SIZE: 11pt; FONT-FAMILY: 宋体; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥;">第六题:</span><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;"><font face="Times New Roman">=SUMPRODUCT((B57:B68="A1")*(C57:C68="</font></span><span style="FONT-SIZE: 11pt; FONT-FAMILY: 宋体; mso-ascii-font-family: ˎ̥; mso-hansi-font-family: ˎ̥;">冰箱</span><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: ˎ̥;"><font face="Times New Roman">")*E57:E68*F57:F68) <p></p></font></span></p><p></p><p><font color="#1111ee">正确</font></p>
[此贴子已经被ZBKYOYO于2008-5-31 20:00:26编辑过] |