9947题集3:技巧、函数综合题-平方数的输入并求值。
本帖最后由 爱疯 于 2013-4-1 21:57 编辑 <br /><br /><P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">要求:</SPAN><SPAN lang=EN-US><FONT face="Times New Roman"><SPAN style="mso-tab-count: 4"> </SPAN><P></P></FONT></SPAN>
<P></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN lang=EN-US><FONT face="Times New Roman">1</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、用两种不同的方法在单元格内输入一个数的平方(技巧),</SPAN><SPAN lang=EN-US>
<P></P></SPAN>
<P></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN lang=EN-US><SPAN style="mso-spacerun: yes"><FONT face="Times New Roman"> </FONT></SPAN></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">并用函数得到这个平方数的值(函数)。</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">"<SPAN style="mso-tab-count: 4"> </SPAN>
<P></P></FONT></SPAN>
<P></P>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN lang=EN-US><FONT face="Times New Roman">2</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、“计算结果”只能用函数达到,不得用</SPAN><SPAN lang=EN-US><FONT face="Times New Roman">VBA</FONT></SPAN><SPAN style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">,也不能定义名称。</SPAN><SPAN lang=EN-US><FONT face="Times New Roman"><SPAN style="mso-tab-count: 4"> </SPAN>
<P></P></FONT></SPAN>
<P></P>
<P><SPAN style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang=EN-US>3</SPAN><SPAN style="FONT-FAMILY: 宋体; FONT-SIZE: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-family: 'Times New Roman'">、最好能用</SPAN><SPAN style="FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA" lang=EN-US>GIF</SPAN><SPAN style="FONT-FAMILY: 宋体; FONT-SIZE: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-family: 'Times New Roman'">动画上交答案,或上传附件。</SPAN></P>
<P><SPAN style="FONT-FAMILY: 宋体; FONT-SIZE: 10.5pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-bidi-font-family: 'Times New Roman'">4、回贴请用“回复可见”。</SPAN></P>
<P>如下图:</P>
<P></P>
<P>BB奖励说明:</P>
<P>1、最佳答案只评最佳不送BB,BB送给最佳答案外的前三名正确答案。</P>
<P>2、如出现没用“回复可见”上交的正确答案,此贴不送BB!</P>
顶一下,顺便坐坐自己家的沙发……
**** Hidden Message *****
嗨,错别字很多啊,看来中文没学好
**** Hidden Message *****
**** Hidden Message *****
<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>無心</i>在2010-1-31 12:48:00的发言:</b><br/></div><p>技巧方法正确,但,函数有点投机,也怪我没说明白:用函数一般来讲都是要求<font face="黑体" color="#bb4444" size="4">一个公式下拉得到结果</font>,而不是一个一个单元输入,你的公式下拉后会出错。</p><p>不好意思,出题没经验,以后会慢慢改进的!!</p><p>能把上面这一点加进去再做一遍吗?</p><p>谢谢!!</p>
[此贴子已经被作者于2010-1-31 13:37:27编辑过]