【综合1系2期3班】第一讲作业上交帖(9组)

万杰

<p><font size="5"><strong>【综合1系2期3班】9组同学在此跟帖上交第一讲作业，作业上交需采取回复贴方式！</strong></font></p><p><font color="#ff0066" size="4"><strong>注意： 1、如果不采取回复贴方式，班级将采取惩罚措施!</strong></font></p><p><font color="#ff0066" size="4"><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; 2、请不要回复与作业无关的内容!</strong></font></p><p><font color="#ff0066" size="4"><strong>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 3、请不是我班或本组的学员不要跟帖，以便于组长统计与管理，谢谢!</strong></font></p><p>第一讲作业下载地址:<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=65935" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=65935" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=65935" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=65935" target="_blank">http://www.excelpx.com/forum.php?mod=viewthread&tid=65935</a><a></a><a></a><a></a></p><p>如何上传附件:&nbsp; <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=154"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=154" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=154" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=154" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=154" target="_blank">http://www.excelpx.com/forum.php?mod=viewthread&tid=154</a><a></a><a></a><a></a><a></a></p><p>如何发回复可见帖: <a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=50825"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=50825" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=50825" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=50825" target="_blank"></a><a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=50825" target="_blank">http://www.excelpx.com/forum.php?mod=viewthread&tid=50825</a><a></a><a></a><a></a><a></a></p>

月の宠儿

<p>沙发[em34]&nbsp; 不知道是不是只交答案 o(∩_∩)o... 这次先都交了好了</p><p>

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

</p><p><strong><font color="#ff0033" size="4">第二问:不对哦!(这样只是保护了工作薄的结构窗口,并没有起到机密工作薄的目的)</font></strong></p><p><strong><font color="#ff0033" size="4">其他完成的很好,包括选做题(赞一个)</font></strong></p><p><strong><font color="#ff0033" size="4">通过!</font></strong></p>[em17][em17][em17][em17][em17]

[此贴子已经被万杰于2008-8-6 23:36:01编辑过]

轮回

<p>我做好了，大家来看啦 UXOFJNXb.rar (20.8 KB, 下载次数: 5)

2008-8-5 11:45 上传

点击文件名下载附件
【综合1系2期3班】第一讲作业上交帖(9组) <br/>问题1答案： <table cellspacing="0" cellpadding="0" width="936" border="0" xstr="" style="WIDTH: 702pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="13" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="936" colspan="13" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 702pt; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font face="宋体" color="#ff0000">&nbsp;&nbsp;原因：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; excel表的行不能大于65536行，列不能大于256列，如果在65536行或256列里有数据，在前面插入行或列时即会引起溢出。</font></td></tr></tbody></table></p><p>问题2答案：</p><p><table cellspacing="0" cellpadding="0" width="360" border="0" xstr="" style="WIDTH: 270pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="5" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="360" colspan="5" height="19" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: #ebe9ed; BORDER-LEFT: #ebe9ed; WIDTH: 270pt; BORDER-BOTTOM: #ebe9ed; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体" color="#ff0000">到工具-选项-相应位置（网格线和行号列标打√）-确定</font></td></tr></tbody></table></p>

[此贴子已经被作者于2008-8-5 13:30:57编辑过]

轮回

还有其它的，组长，哦，我知道答案了[em09]

jojo_0524

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

EV13yBdS.rar (12.18 KB, 下载次数: 7)

2008-8-5 14:42 上传

点击文件名下载附件
回复：【综合1系2期3班】第一讲作业上交帖(9组) <br/></p><strong><font color="#f70938" size="4"><p><strong><font color="#f70938" size="4">第二问:没有达到机密工作薄 的目的!</font></strong></p><p>第三问:没有理解题意!</p><p>还有你的作业交在回复可见的外面了</p></font></strong>

[此贴子已经被万杰于2008-8-8 9:31:21编辑过]

LIQINGRU711

交作业了

云烟

该交作业了

乐哥

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

</p><p><strong><font color="#f70938" size="4">第八问:是题目本身的失误导致你回答有偏差!</font></strong></p><p>[em04][em04]</p><p><strong><font color="#f70938" size="4">第七问:到时候我们再公布参考答案吧!</font></strong></p><p><font color="#ff0066" size="4"><strong>其他完成的很好!</strong></font></p>

[此贴子已经被万杰于2008-8-8 9:37:36编辑过]

云烟

大家都好快

云烟

<table cellspacing="0" cellpadding="0" width="648" border="0" xstr="" style="WIDTH: 486pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="9" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="20" style="HEIGHT: 15pt; mso-height-source: userset;"><td class="xl23" width="72" height="20" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: fuchsia 2pt double; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; HEIGHT: 15pt; BACKGROUND-COLOR: white;"><font color="#0000ff">答题区：</font></td><td class="xl24" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl24" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl24" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl24" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl24" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl24" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl24" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl25" width="72" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl26" width="72" height="47" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: fuchsia 2pt double; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><div style="MIN-HEIGHT: 200px; WORD-WRAP: break-word;"><font color="#0000ff">答题区：</font></div></td><td class="xl27" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;">　</td><td class="xl27" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;">　</td><td class="xl27" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;">　</td><td class="xl27" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;">　</td><td class="xl27" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;">　</td><td class="xl27" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;">　</td><td class="xl27" width="72" style="BORDER-RIGHT: #f4f4f4; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;">　</td><td class="xl28" width="72" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #f4f4f4; WIDTH: 54pt; BORDER-BOTTOM: #f4f4f4; BACKGROUND-COLOR: white;">　</td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl29" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #f4f4f4; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #f4f4f4; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">1、工具--保护--允许用户编辑区域--新建--设置红色区域单元格--确定--应用--保护工作表--设置密码--确定</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl29" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #f4f4f4; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #f4f4f4; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">2、工具--保护--保护工作簿--设置密码--确定</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl29" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #f4f4f4; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #f4f4f4; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">3、工具--选项--视图--工作表标签（勾掉）--确定</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl29" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #f4f4f4; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #f4f4f4; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">4、文件--页面设置--工作表--顶端标题行（左端标题列）--选取需要设置的顶端标题行（左端标题列）区域--确定</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl29" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #f4f4f4; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #f4f4f4; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">5、a、按住CTRL键，滑动鼠标滚轮，向前放大，向后缩小；b、直接修改菜单栏里中的比例</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl29" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #f4f4f4; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #f4f4f4; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">6、工具--选项--保存--勾选保存自动恢复信息并设置时间10分钟--确定</font></td></tr><tr height="55" style="HEIGHT: 41.25pt; mso-height-source: userset;"><td class="xl29" width="648" colspan="9" height="55" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #f4f4f4; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #f4f4f4; HEIGHT: 41.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">7、选取一个区域并复制--在另一个工作表中按住shift--编辑--粘贴图片--点击图片右键设置图片格式--颜色与线条--颜色--填充效果--图片--选择图片--确定</font></td></tr><tr height="33" style="HEIGHT: 24.75pt; mso-height-source: userset;"><td class="xl32" width="648" colspan="9" height="33" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #f4f4f4; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: fuchsia 2pt double; HEIGHT: 24.75pt; BACKGROUND-COLOR: white;"><font color="#0000ff">8、a、按住CTRL打开选定指定多个工作表；b、按住SHIFT打开选定多个连续工作表</font><div></div></td></tr></tbody></table>