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

万杰发表于 2008-8-5 09:42

【综合1系2期3班】9组同学在此跟帖上交第一讲作业，作业上交需采取回复贴方式！注意： 1、如果不采取回复贴方式，班级将采取惩罚措施!            2、请不要回复与作业无关的内容!            3、请不是我班或本组的学员不要跟帖，以便于组长统计与管理，谢谢!第一讲作业下载地址:<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>如何上传附件:  <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>如何发回复可见帖: <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>

月の宠儿 发表于 2008-8-5 09:50

沙发  不知道是不是只交答案 o(∩_∩)o... 这次先都交了好了**** Hidden Message *****第二问:不对哦!(这样只是保护了工作薄的结构窗口,并没有起到机密工作薄的目的)其他完成的很好,包括选做题(赞一个)通过!
[此贴子已经被万杰于2008-8-6 23:36:01编辑过]

轮回发表于 2008-8-5 11:45

我做好了，大家来看啦 问题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;">  原因：      excel表的行不能大于65536行，列不能大于256列，如果在65536行或256列里有数据，在前面插入行或列时即会引起溢出。</td></tr></tbody></table>问题2答案：<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;">到工具-选项-相应位置（网格线和行号列标打√）-确定</td></tr></tbody></table>
[此贴子已经被作者于2008-8-5 13:30:57编辑过]

轮回发表于 2008-8-5 11:48

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

jojo_0524 发表于 2008-8-5 14:11

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

**** Hidden Message ***** 第二问:没有达到机密工作薄的目的!第三问:没有理解题意!还有你的作业交在回复可见的外面了
[此贴子已经被万杰于2008-8-8 9:31:21编辑过]

LIQINGRU711 发表于 2008-8-5 16:49

交作业

交作业了

云烟发表于 2008-8-5 18:06

该交作业了

乐哥发表于 2008-8-5 18:07

回复：（万杰）【综合1系2期3班】第一讲作业上交帖(9组...

**** Hidden Message *****第八问:是题目本身的失误导致你回答有偏差!第七问:到时候我们再公布参考答案吧!其他完成的很好!
[此贴子已经被万杰于2008-8-8 9:37:36编辑过]

云烟发表于 2008-8-5 18:23

大家都好快

云烟发表于 2008-8-5 18:29

<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;">答题区：</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;">　</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;">　</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;">　</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;">　</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;">　</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;">　</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;">　</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;">　</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;">答题区：</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;">1、工具--保护--允许用户编辑区域--新建--设置红色区域单元格--确定--应用--保护工作表--设置密码--确定</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;">2、工具--保护--保护工作簿--设置密码--确定</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;">3、工具--选项--视图--工作表标签（勾掉）--确定</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;">4、文件--页面设置--工作表--顶端标题行（左端标题列）--选取需要设置的顶端标题行（左端标题列）区域--确定</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;">5、a、按住CTRL键，滑动鼠标滚轮，向前放大，向后缩小；b、直接修改菜单栏里中的比例</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;">6、工具--选项--保存--勾选保存自动恢复信息并设置时间10分钟--确定</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;">7、选取一个区域并复制--在另一个工作表中按住shift--编辑--粘贴图片--点击图片右键设置图片格式--颜色与线条--颜色--填充效果--图片--选择图片--确定</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;">8、a、按住CTRL打开选定指定多个工作表；b、按住SHIFT打开选定多个连续工作表<div></div></td></tr></tbody></table>

页: [1] 2 3

Excel精英培训网's Archiver