函快二期2班第1讲作业上交帖子001-065

轩辕轼轲 · 发表于 2010-12-4 09:30

1：作业尽量通过自己思考独立完成，不会的可在同学之间私聊讨论，禁止在QQ群公开索要答案。2：作业以回复可见方式提交，上交后不得编辑修改，否则按抄袭论。同时请在回帖时写上自己的学号吧3：禁止非本组学员回复，任何以马甲抄袭他人作业一经发现，删帖、扣BB。4：有不能正确修改头衔的学员，请在作业贴或者签名中注明组别和学号。作业上交以后再投票。回复可见及头衔修改操作方法见：<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=114926">http://www.excelpx.com/forum.php?mod=viewthread&tid=114926</a>  <table cellspacing="0" cellpadding="0" width="552" border="0" style="WIDTH: 414pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="54" style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1728;"></col><col width="111" style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 3552;"></col><col width="387" style="WIDTH: 290pt; mso-width-source: userset; mso-width-alt: 12384;"></col></colgroup><tbody><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" width="54" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600 0.5pt solid; BORDER-LEFT: #ff6600 0.5pt solid; WIDTH: 41pt; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">学号</td><td class="xl24" width="111" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600 0.5pt solid; BORDER-LEFT: #ff6600; WIDTH: 83pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">论坛ID</td><td class="xl25" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600 0.5pt solid; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">批语</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">113</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">sys31yy</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">全部正确，占错沙发了</td></tr><tr height="30" style="HEIGHT: 22.5pt;"><td class="xl24" height="30" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 22.5pt; BACKGROUND-COLOR: transparent;">20</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">liujatihc</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">附加题要求是一个公式。其他的都正确。第一题你多写了个括号，但是不影响计算结果。</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">22</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">乐满地</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">全部正确。</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">35</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">zlq0351</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">除了选做题外，其他都正确。</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">75</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">想入菲-菲</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">除了选做题外，其他都正确。选做题要求用一个公式实现，能右拉下拉</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">24</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">bearfu</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">除了选做题外，其他都正确。选做题要求用一个公式实现，能右拉下拉</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">43</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">冰淇淋甜筒</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">除了选做题外，其他都正确。选做题要求用一个公式实现，能右拉下拉</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">17</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">hetaojicheng</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">除了选做题外，其他都正确。选做题要求用一个公式实现，能右拉下拉</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">31</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">anchangmei</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">除了选做题外，其他都正确。选做题要求用一个公式实现，能右拉下拉</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">14</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">懒踏踏</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">全部正确。</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">3</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">lj687</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">一道题都没有做就上传了，是不是忘记保存了？</td></tr><tr height="60" style="HEIGHT: 45pt;"><td class="xl24" height="60" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 45pt; BACKGROUND-COLOR: transparent;">48</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">☆好望角☆</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">第一题的价格是要引用C5单元格的，不能手动输入进公式的，另外两个的公式虽然做出效果了，但是给你提个建议，IF函数需要返回一个数值的时候，直接写数值就好了，比如IF(1<2,20,0)，而没必要IF(1<2,"20","0")。选做题未做。</td></tr><tr height="30" style="HEIGHT: 22.5pt;"><td class="xl24" height="30" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 22.5pt; BACKGROUND-COLOR: transparent;">147</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">yuliang-1918</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">除了选做题外，其他都正确。选做题要求用一个公式实现，能右拉下拉。不过你坐错板凳了。</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">33</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">单车代步</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">除了选做题外，其他都正确。选做题未做。</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">32</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">菲菲猪</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><div xmlnsmasterjs="Kissogram" xmlnsmsxsl="urn:schemas-microsoft-com:xslt">全部正确。</div></td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">50</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">SZHPBS</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">三题都正确。选做题未做。</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">25</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">toby991</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">除了选做题外，其他都正确。选做题要求用一个公式实现，能右拉下拉</td></tr><tr height="15" style="HEIGHT: 11.25pt;"><td class="xl24" height="15" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600 0.5pt solid; BORDER-BOTTOM: #ff6600 0.5pt solid; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent;">8</td><td class="xl26" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;">闭家锁</td><td class="xl27" width="387" style="BORDER-RIGHT: #ff6600 0.5pt solid; BORDER-TOP: #ff6600; BORDER-LEFT: #ff6600; WIDTH: 290pt; BORDER-BOTTOM: #ff6600 0.5pt solid; BACKGROUND-COLOR: transparent;"><div xmlnsmasterjs="Kissogram" xmlnsmsxsl="urn:schemas-microsoft-com:xslt">全部正确。</div></td></tr></tbody></table>

GBzY1yN6.rar (2.48 KB, 下载次数: 12)

sys31yy · 发表于 2010-12-4 09:34

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

轩辕轼轲 · 发表于 2010-12-4 09:35

请各位看清楚学号，对号入座哈，这个帖子是收001-065作业的！

sys31yy · 发表于 2010-12-4 09:36

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

<div class="msgheader">QUOTE:</div><div class="msgborder">全部正确不过你好像错占沙发了                                    -------轩辕轼轲   2010-12-05</div>

[此贴子已经被轩辕轼轲于2010-12-5 19:54:51编辑过]

liujatihc · 发表于 2010-12-4 09:39

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

你的论坛头衔没改，改了头衔再批改你的作业，去这个帖子交点班费<div><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=150063">http://www.excelpx.com/forum.php?mod=viewthread&tid=150063</a>
</div><div><div class="msgheader">QUOTE:</div><div class="msgborder">附加题要求是一个公式。其他的都正确。不过第一题你多写了个括号，但是不影响计算结果。                                    -------轩辕轼轲   2010-12-05</div></div>

[此贴子已经被轩辕轼轲于2010-12-5 19:59:24编辑过]

苏洋 · 发表于 2010-12-4 09:46

学习，加油

乐满地 · 发表于 2010-12-4 09:51

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

<div class="msgheader">QUOTE:</div><div class="msgborder">全部正确。                                    -------轩辕轼轲   2010-12-05</div>

[此贴子已经被轩辕轼轲于2010-12-5 20:04:20编辑过]

zlq0351 · 发表于 2010-12-4 09:57

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

lMaGLJrx.rar (18.71 KB, 下载次数: 1)

想入菲-菲 · 发表于 2010-12-4 10:54

交作业了05  075，我不会改头衔[em04]

想入菲-菲 · 发表于 2010-12-4 10:58

交作业了05  075，我不会改头衔<img title="dvubb" alt="图片点击可在新窗口打开查看" src="http://www.excelpx.com/Skins/Default/emot/em04.gif" align="middle" border="0" complete="complete"/>去看看班务帖里有详细的说明，你还没用回复可见交作业

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

<div class="msgheader">QUOTE:</div><div class="msgborder">除了附加题外，其他都正确。附加题要求用一个公式实现，能右拉下拉                                    -------轩辕轼轲   2010-12-05</div>

[此贴子已经被轩辕轼轲于2010-12-5 20:10:50编辑过]

		自动登录	找回密码
密码			注册

[通知] 函快二期2班第1讲作业上交帖子001-065

沙发哦!

晕了,高兴过头没带附件!

函快2班20#liujatihc

函快2期2班02022:乐满地交作业

函数快速入门二班报到