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

海烛

<p>&nbsp; <table cellspacing="0" cellpadding="0" width="609" border="0" xstr="" style="WIDTH: 457pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="8" width="72" style="WIDTH: 54pt;"></col><col></col><col></col><col></col><col width="33" style="WIDTH: 25pt; mso-width-source: userset; mso-width-alt: 1056;"></col><col></col><col></col><col></col></colgroup><tbody><tr height="33" style="HEIGHT: 24.95pt; mso-height-source: userset;"><td class="xl23" width="72" height="33" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: fuchsia 2pt double; WIDTH: 54pt; BORDER-BOTTOM: #ebe9ed; HEIGHT: 24.95pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">答题区：</font></td><td class="xl24" width="72" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ebe9ed; WIDTH: 54pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: white;">　</td><td class="xl24" width="72" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ebe9ed; WIDTH: 54pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: white;">　</td><td class="xl24" width="72" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ebe9ed; WIDTH: 54pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: white;">　</td><td class="xl24" width="72" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ebe9ed; WIDTH: 54pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: white;">　</td><td class="xl24" width="72" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ebe9ed; WIDTH: 54pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: white;">　</td><td class="xl24" width="72" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ebe9ed; WIDTH: 54pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: white;">　</td><td class="xl24" width="72" style="BORDER-RIGHT: #ebe9ed; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ebe9ed; WIDTH: 54pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: white;">　</td><td class="xl25" width="33" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ebe9ed; WIDTH: 25pt; BORDER-BOTTOM: #ebe9ed; BACKGROUND-COLOR: white;">　</td></tr><tr height="39" style="HEIGHT: 29.25pt; mso-height-source: userset;"><td class="xl26" width="609" colspan="9" height="39" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ebe9ed; BORDER-LEFT: fuchsia 2pt double; WIDTH: 457pt; BORDER-BOTTOM: #ebe9ed 0.5pt; HEIGHT: 29.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">1、选中红色区域,工具--保护--保护工作表--选定未锁定的单元格打勾--保护工作表及锁定的单元格内容打勾,输入密码</font></td></tr><tr height="45" style="HEIGHT: 33.75pt; mso-height-source: userset;"><td class="xl26" width="609" colspan="9" height="45" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ebe9ed; BORDER-LEFT: fuchsia 2pt double; WIDTH: 457pt; BORDER-BOTTOM: #ebe9ed 0.5pt; HEIGHT: 33.75pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">2、工具---选项---安全性---打开权限密码(输入密码)---保存---修改权限密码(根据需要输入密码)---保存</font></td></tr><tr height="33" style="HEIGHT: 24.95pt; mso-height-source: userset;"><td class="xl26" width="609" colspan="9" height="33" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ebe9ed; BORDER-LEFT: fuchsia 2pt double; WIDTH: 457pt; BORDER-BOTTOM: #ebe9ed 0.5pt; HEIGHT: 24.95pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">3、窗口---隐藏</font></td></tr><tr height="33" style="HEIGHT: 24.95pt; mso-height-source: userset;"><td class="xl26" width="609" colspan="9" height="33" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ebe9ed; BORDER-LEFT: fuchsia 2pt double; WIDTH: 457pt; BORDER-BOTTOM: #ebe9ed 0.5pt; HEIGHT: 24.95pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">4.文件---页面设置---工作表---打印标题—顶端标题行或左端标题列—确定</font></td></tr><tr height="33" style="HEIGHT: 24.95pt; mso-height-source: userset;"><td class="xl26" width="609" colspan="9" height="33" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ebe9ed; BORDER-LEFT: fuchsia 2pt double; WIDTH: 457pt; BORDER-BOTTOM: #ebe9ed 0.5pt; HEIGHT: 24.95pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">5、按住CTRL，移动鼠标或者视图---显示比例</font></td></tr><tr height="33" style="HEIGHT: 24.95pt; mso-height-source: userset;"><td class="xl26" width="609" colspan="9" height="33" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ebe9ed; BORDER-LEFT: fuchsia 2pt double; WIDTH: 457pt; BORDER-BOTTOM: #ebe9ed 0.5pt; HEIGHT: 24.95pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">6、工具—选项—保存—保存自动恢复，每隔10分钟—确定</font></td></tr><tr height="33" style="HEIGHT: 24.95pt; mso-height-source: userset;"><td class="xl26" width="609" colspan="9" height="33" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ebe9ed; BORDER-LEFT: fuchsia 2pt double; WIDTH: 457pt; BORDER-BOTTOM: #ebe9ed 0.5pt; HEIGHT: 24.95pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">7、在格式—工作表—背景—选择背景图片--插入</font></td></tr><tr height="44" style="HEIGHT: 33pt; mso-height-source: userset;"><td class="xl29" width="609" colspan="9" height="44" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ebe9ed; BORDER-LEFT: fuchsia 2pt double; WIDTH: 457pt; BORDER-BOTTOM: fuchsia 2pt double; HEIGHT: 33pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">8、文件---打开---在打开对话框下按CTRL键选定要打开的工作表,单击打开.如果要连续打开多个文件,可以按SHIFT键.</font></td></tr></tbody></table></p><br/>

[此贴子已经被作者于2008-8-10 17:29:53编辑过]

fay1107

<p>

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

</p>

海韵

<p>改正作业</p><p><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="xl25" width="72" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: fuchsia 2pt double; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">　</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl26" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td><td class="xl27" width="72" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial">　</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl28" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">1、选中红色区域—工具—保护—保护工作表—选定锁定单元格内勾勾去掉 然后保护整个工作表</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl28" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">2、工具—选项—安全性—打开权限密码（设置密码）—修改权限密码（根据需要）—确定</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl28" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">3、工具—选项—视图—把“工作表标签”勾去掉</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl28" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">4、文件—页面设置—打印标题—顶端标题行或左端标题列—确定</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl28" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">5、按住CTRL，移动鼠标</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl28" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">6、工具—选项—保存—保存自动恢复，每隔（填写10）分钟—确定</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl28" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">7、在格式—工作表—背景—选择背景图片—调整图片大小—打印</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl31" width="648" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 486pt; BORDER-BOTTOM: fuchsia 2pt double; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">8、文件—打开—选中多个工作薄—打开</font></td></tr></tbody></table></p>

leeky

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

haoyunqi

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

fsecho

<p>

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

</p>

[此贴子已经被作者于2008-8-10 23:49:31编辑过]

中国-龙

<p>答1： 把 不需要 保护的单元格选中，单击右键，单击“设置单元格格式”，在对话框中选择“保护”选项卡，将“锁定</p><p>”前的勾取消，单击确定。再单击“工具”，选择保护工作，输入密码单击确定。 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p><p>&nbsp;&nbsp;&nbsp;&nbsp;<br/>2、工具--选项---安全性--此工作薄的文件加密设置&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p><p>&nbsp;<br/>3、工具---选项---视图---在“窗口选项”下把工作表标签前的“√”去掉,然后再点击确定&nbsp;&nbsp;&nbsp;&nbsp;</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>4、文件-页面设置-工作表-顶端标题行-选择需要的顶端的区域。选择要打印区域-文件-打印区域-设置打印区域-然后选择</p><p>预工具调整是否超页根据需要调整页边距OK后请单击打印按钮。&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p><p>&nbsp;&nbsp;<br/>5、视图-显示比例-选择你要缩放的比例&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/>6、工具-选项-保存-设置-保存自动恢复信息每隔前面打“√”，并在后面输入10分钟</p><p></p>

中国-龙

是不是这样发作业贴哟?

vbyou127

dfdfd