Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
查看: 18207|回复: 82

有奖题:带三个MM开车去兜风-循环法练习

[复制链接]
发表于 2008-5-18 10:32 | 显示全部楼层 |阅读模式
<p align="center" style="TEXT-ALIGN: center;"><span style="FONT-SIZE: 24pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">年龄趣题:带三个</font></span><span lang="EN-US" style="FONT-SIZE: 24pt; FONT-FAMILY: Arial;">MM</span><span style="FONT-SIZE: 24pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">开车去兜风</font></span><span lang="EN-US" style="FONT-SIZE: 24pt; FONT-FAMILY: Arial;"><br/></span><font size="3"><span lang="EN-US" style="FONT-FAMILY: Arial;">“</span><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">你在忙什么,小马</font></span><span lang="EN-US" style="FONT-FAMILY: Arial;">”</span><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">老教授随意地说,这时他的这位朋友正一口气喝完剩下的咖啡,站起来要走!</font></span></font><span lang="EN-US" style="FONT-FAMILY: Arial;"><br/><font size="3">“</font></span><font size="3"><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">准备带三个女孩去兜风</font></span><span lang="EN-US" style="FONT-FAMILY: Arial;">”</span><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">小马答道。</font></span></font><span lang="EN-US" style="FONT-FAMILY: Arial;"><br/></span><font size="3"><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">老教授笑了:</font></span><span lang="EN-US" style="FONT-FAMILY: Arial;">“</span><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">原来如此!敢问三位佳丽芳龄几许?</font></span></font><font size="3"><span lang="EN-US" style="FONT-FAMILY: Arial;">”<br/></span><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">小马思考片刻说:</font></span><span lang="EN-US" style="FONT-FAMILY: Arial;">“</span><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">把她们年龄的乘积是</font></span><span lang="EN-US" style="FONT-FAMILY: Arial;">2450</span><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">,可她们的年龄的和恰是您年龄的</font></span><span lang="EN-US" style="FONT-FAMILY: Arial;">1/2”</span><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">。</font></span></font><span lang="EN-US" style="FONT-FAMILY: Arial;"><br/></span><font size="3"><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">老教授摇了摇头说:非常有趣,但对她们的年龄仍然有疑问。</font></span><span lang="EN-US" style="FONT-FAMILY: Arial;">”</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: Arial;"> <p></p></span></font></p><p></p><p></p><p><font size="3"><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">现在让大家用</font></span><span lang="EN-US" style="FONT-FAMILY: Arial;">VBA</span><font face="宋体"><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;">程序帮老教授算一下三个女孩的年龄!</span><span lang="EN-US" style="FONT-FAMILY: Arial;"> <p></p></span></font></font></p><p></p><p></p><p><font face="宋体"><span style="FONT-SIZE: 10pt; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;">己知:</span><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: Arial;"> <p></p></span></font></p><p></p><p></p><p><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">条件</font></span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: #f70909; FONT-FAMILY: Arial;">1</span><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">:小雪</font></span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: #f70909; FONT-FAMILY: Arial;">*</span><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">小月</font></span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: #f70909; FONT-FAMILY: Arial;">*</span><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">小丽</font></span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: #f70909; FONT-FAMILY: Arial;">=2450</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: Arial;"> <p></p></span></p><p></p><p></p><p><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">条件</font></span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: #f70909; FONT-FAMILY: Arial;">2</span><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">:小雪</font></span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: #f70909; FONT-FAMILY: Arial;">+</span><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">小月</font></span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: #f70909; FONT-FAMILY: Arial;">+</span><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">小丽</font></span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: #f70909; FONT-FAMILY: Arial;">=</span><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">老教授年龄的一半</font></span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: Arial;"> <p></p></span></p><p></p><p></p><p><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">条件</font></span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: #f70909; FONT-FAMILY: Arial;">3</span><font face="宋体"><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;">:小雪年龄最小,小月年龄居中,小丽年龄最大</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: Arial;"> <p></p></span></font></p><p></p><p></p><p><font face="宋体"><span style="FONT-SIZE: 10pt; COLOR: #4111ff; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;">提示:女孩的年龄<personname productid="和老" wst="on"></personname>和老<personname></personname>教授年龄范围是一个重要的附助条件。</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: Arial;"> <p></p></span></font></p><p></p><p></p><p><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">我统一一下变量:</font></span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: #f70909; FONT-FAMILY: Arial;">M1</span><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">代表小雪,</font></span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: #f70909; FONT-FAMILY: Arial;">M2</span><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">代表小月,</font></span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: #f70909; FONT-FAMILY: Arial;">M3</span><span style="FONT-SIZE: 10pt; COLOR: #f70909; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">代表小丽</font></span><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: Arial;">&nbsp;&nbsp;&nbsp;&nbsp; </span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: Arial;"><p></p></span></p><p></p><p></p><p><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: Arial;">&nbsp;&nbsp;&nbsp;&nbsp;</span><font size="3"><span lang="EN-US" style="FONT-FAMILY: Arial;"> 1</span><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">、回贴时要用回复可见方式。<span style="COLOR: blue;">粘贴</span></font></span><span lang="EN-US" style="COLOR: blue; FONT-FAMILY: Arial;">VBA</span><span style="COLOR: blue; mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">代码既可。</font></span><span style="FONT-FAMILY: Arial;"> <span lang="EN-US"><p></p></span></span></font></p><p></p><p></p><p><font size="3"><span lang="EN-US" style="FONT-FAMILY: Arial;">&nbsp;&nbsp;&nbsp;&nbsp; 2</span><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">、正确答案每人奖励</font></span><span lang="EN-US" style="FONT-FAMILY: Arial;">5</span><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">个金币,</font></span><span lang="EN-US" style="FONT-FAMILY: Arial;">VBA</span><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;"><font face="宋体">入门的学员加奖</font></span><span lang="EN-US" style="FONT-FAMILY: Arial;">10</span><font face="宋体"><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;">个金币。</span><span lang="EN-US" style="FONT-FAMILY: Arial;"> <p></p></span></font></font></p><p></p><p></p><p><font size="3"><span lang="EN-US" style="FONT-FAMILY: Arial;">&nbsp;&nbsp;&nbsp;&nbsp; 3</span><font face="宋体"><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;">、由于回贴后你就可以看到其他答案,所以不允许二次回复和编辑原贴子。</span><span lang="EN-US" style="FONT-FAMILY: Arial;"> <p></p></span></font></font></p><p></p><p></p><p><font size="3"><span lang="EN-US" style="FONT-FAMILY: Arial;">&nbsp;&nbsp;&nbsp;&nbsp; 4</span><font face="宋体"><span style="mso-bidi-font-family: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial;">、违反上面规定回贴的,倒扣两个金币</span><span lang="EN-US" style="FONT-FAMILY: Arial;"> <p></p></span></font></font></p><p></p><p></p><p><span lang="EN-US" style="FONT-SIZE: 10pt; FONT-FAMILY: Arial;">
游客,如果您要查看本帖隐藏内容请回复
<p></p></span></p><p></p><p></p>
[此贴子已经被作者于2008-5-18 15:23:25编辑过]
 楼主| 发表于 2008-5-18 11:10 | 显示全部楼层

占个位,如果没有人做出来,备以后发问题分析![em01]
回复

使用道具 举报

发表于 2008-5-18 11:25 | 显示全部楼层

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

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?注册

x
回复

使用道具 举报

发表于 2008-5-18 11:41 | 显示全部楼层

不需要知道老教授的年龄吗?学习一下。
回复

使用道具 举报

发表于 2008-5-18 11:59 | 显示全部楼层

学习一下VBA
回复

使用道具 举报

发表于 2008-5-18 12:28 | 显示全部楼层

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

使用道具 举报

发表于 2008-5-18 12:37 | 显示全部楼层

有意思
回复

使用道具 举报

发表于 2008-5-18 14:03 | 显示全部楼层

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

[此贴子已经被作者于2008-5-18 16:11:45编辑过]
回复

使用道具 举报

发表于 2008-5-18 14:48 | 显示全部楼层

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

使用道具 举报

发表于 2008-5-18 15:13 | 显示全部楼层

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

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-4-29 05:00 , Processed in 0.419142 second(s), 4 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表