<p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 18pt; mso-char-indent-count: 2.0;"><span lang="EN-US" style="FONT-SIZE: 9pt;"><font face="Times New Roman">交作业:</font></span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 18pt; mso-char-indent-count: 2.0;"><span lang="EN-US" style="FONT-SIZE: 9pt;"></span> </p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 18pt; mso-char-indent-count: 2.0;"><span lang="EN-US" style="FONT-SIZE: 9pt;"><font face="Times New Roman">1.<span style="mso-spacerun: yes;"> </span>=COUNTIF(A1:A7,TRUE) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><font face="Times New Roman"><span lang="EN-US" style="mso-bidi-font-size: 10.5pt;">2.<span style="mso-spacerun: yes;"> </span></span><span lang="EN-US" style="FONT-SIZE: 9pt;">=COUNTIF(A1:A7,"<>*")</span><span lang="EN-US" style="mso-bidi-font-size: 10.5pt;"> <p></p></span></font></p><p></p><p></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><span lang="EN-US" style="mso-bidi-font-size: 10.5pt;"><font face="Times New Roman">3.<span style="mso-spacerun: yes;"> </span>=COUNTIF($E$12:$E$17,A12) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 42pt; mso-char-indent-count: 4.0;"><span lang="EN-US" style="mso-bidi-font-size: 10.5pt;"><font face="Times New Roman">=COUNTIF($E$12:$E$17,A13) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 42pt; mso-char-indent-count: 4.0;"><span lang="EN-US" style="mso-bidi-font-size: 10.5pt;"><font face="Times New Roman">=COUNTIF($E$12:$E$17,A14) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 42pt; mso-char-indent-count: 4.0;"><span lang="EN-US" style="mso-bidi-font-size: 10.5pt;"><font face="Times New Roman">=COUNTIF($E$12:$E$17,A15) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 42pt; mso-char-indent-count: 4.0;"><span lang="EN-US" style="mso-bidi-font-size: 10.5pt;"><font face="Times New Roman">=COUNTIF($E$12:$E$17,A16) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 42pt; mso-char-indent-count: 4.0;"><span lang="EN-US" style="mso-bidi-font-size: 10.5pt;"><font face="Times New Roman">=COUNTIF($E$12:$E$17,A17) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 42pt; mso-char-indent-count: 4.0;"><span lang="EN-US" style="mso-bidi-font-size: 10.5pt;"><font face="Times New Roman">=COUNTIF($E$12:$E$17,A18) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 42pt; mso-char-indent-count: 4.0;"><span lang="EN-US" style="mso-bidi-font-size: 10.5pt;"><font face="Times New Roman">=COUNTIF($E$12:$E$17,A19) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 42pt; mso-char-indent-count: 4.0;"><span lang="EN-US" style="mso-bidi-font-size: 10.5pt;"><font face="Times New Roman">=COUNTIF($E$12:$E$17,A20) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><span lang="EN-US" style="mso-bidi-font-size: 10.5pt;"><font face="Times New Roman">4. <span style="mso-spacerun: yes;"> </span>=COUNTIF(A23:A37,"<="&B22) <p></p></font></span></p><p></p><p></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; mso-char-indent-count: 2.0;"><span lang="EN-US" style="mso-bidi-font-size: 10.5pt;"><font face="Times New Roman">5. <span style="mso-spacerun: yes;"> </span>=COUNTIF(A41:A47,"?~~*") <p></p></font></span></p><p></p><p><font color="#2c9054" size="5">通过!</font>[em17]</p>
[此贴子已经被jyh197994于2008-6-4 16:24:35编辑过] |