Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
123
返回列表 发新帖
楼主: 万杰

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

[复制链接]
发表于 2008-8-6 21:51 | 显示全部楼层

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

使用道具 举报

发表于 2008-8-6 22:30 | 显示全部楼层

游客,如果您要查看本帖隐藏内容请回复
</p><p><font color="#ff0033" size="5"><strong>通过!</strong></font></p>
[此贴子已经被万杰于2008-8-7 9:42:08编辑过]
回复

使用道具 举报

发表于 2008-8-9 09:41 | 显示全部楼层

我爱交作业咯<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 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 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 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 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 color="#0000ff">4、在文件选项里选“页面设置”(不要在打印预览里设置), <br/>选工作表标签, <br/>在打印标题里项端标题行设置为你想设订的行头,比如“$1:$2”, <br/>在左端标题列里设置为你想设订的列头,比如“$A:$A”, <br/>点确定。</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 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 color="#0000ff">6、在工具栏选项中保存选项</font></td></tr></tbody></table>
回复

使用道具 举报

发表于 2008-8-9 20:52 | 显示全部楼层

交作业了,就是不知道能不能全对。

游客,如果您要查看本帖隐藏内容请回复
[em03]</p><p><font color="#ff0033" size="4"><strong>第二问:并没有达到加密工作薄的目的</strong></font></p><p><strong><font color="#ff0033" size="4">第三问:理解有误</font></strong></p><p><strong><font color="#ff0033" size="4">第七问:背景不能打印</font></strong></p>
[此贴子已经被万杰于2008-8-10 16:07:26编辑过]
回复

使用道具 举报

发表于 2008-8-9 21:00 | 显示全部楼层

游客,如果您要查看本帖隐藏内容请回复
</p><p><font color="#ff0033" size="4"><strong>不是一组的吧?</strong></font></p>
[此贴子已经被万杰于2008-8-12 9:39:52编辑过]
回复

使用道具 举报

发表于 2008-8-10 12:10 | 显示全部楼层

交作业

<table height="396" width="575" style="WIDTH: 431.25pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="63"></col><col></col><col></col><col></col><col width="64"></col><col></col><col></col><col></col><col width="64"></col><col></col><col></col><col></col><col width="64"></col><col></col><col></col><col></col><col width="64"></col><col></col><col></col><col></col><col width="64"></col><col></col><col></col><col></col><col width="64"></col><col></col><col></col><col></col><col width="64"></col><col></col><col></col><col></col><col width="64"></col><col></col><col></col><col></col></colgroup><tbody><tr height="20"><td class="et13" width="63" height="20" style="BORDER-TOP: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; BORDER-LEFT: #ff00ff 2pt double; WIDTH: 47.25pt; COLOR: #0000ff; FONT-STYLE: normal; HEIGHT: 15pt; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;">答题区:</td><td class="et14" width="64" height="20" style="BORDER-TOP: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; WIDTH: 48pt; COLOR: #000000; FONT-STYLE: normal; HEIGHT: 15pt; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;"></td><td class="et14" width="64" height="20" style="BORDER-TOP: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; WIDTH: 48pt; COLOR: #000000; FONT-STYLE: normal; HEIGHT: 15pt; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;"></td><td class="et14" width="64" height="20" style="BORDER-TOP: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; WIDTH: 48pt; COLOR: #000000; FONT-STYLE: normal; HEIGHT: 15pt; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;"></td><td class="et14" width="64" height="20" style="BORDER-TOP: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; WIDTH: 48pt; COLOR: #000000; FONT-STYLE: normal; HEIGHT: 15pt; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;"></td><td class="et14" width="64" height="20" style="BORDER-TOP: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; WIDTH: 48pt; COLOR: #000000; FONT-STYLE: normal; HEIGHT: 15pt; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;"></td><td class="et14" width="64" height="20" style="BORDER-TOP: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; WIDTH: 48pt; COLOR: #000000; FONT-STYLE: normal; HEIGHT: 15pt; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;"></td><td class="et14" width="64" height="20" style="BORDER-TOP: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; WIDTH: 48pt; COLOR: #000000; FONT-STYLE: normal; HEIGHT: 15pt; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;"></td><td class="et15" width="64" height="20" style="BORDER-RIGHT: #ff00ff 2pt double; BORDER-TOP: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; WIDTH: 48pt; COLOR: #000000; FONT-STYLE: normal; HEIGHT: 15pt; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;"></td></tr><tr height="47"><td class="et16" width="567" colspan="9" height="47" style="BORDER-RIGHT: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; BORDER-LEFT: #ff00ff 2pt double; WIDTH: 425.25pt; COLOR: #0000ff; BORDER-BOTTOM: #ff00ff 0.5pt dotted; FONT-STYLE: normal; WHITE-SPACE: normal; HEIGHT: 35.25pt; TEXT-ALIGN: left; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;">1、在"工具"菜单栏选"保护"选"允许用户编辑区域",再点"确定"。</td></tr><tr height="47"><td class="et16" width="567" colspan="9" height="47" style="BORDER-RIGHT: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; BORDER-LEFT: #ff00ff 2pt double; WIDTH: 425.25pt; COLOR: #0000ff; BORDER-BOTTOM: #ff00ff 0.5pt dotted; FONT-STYLE: normal; WHITE-SPACE: normal; HEIGHT: 35.25pt; TEXT-ALIGN: left; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;">2、在"工具"菜单栏选"保护"点击"保护工作簿",输入密码即可.</td></tr><tr height="47"><td class="et16" width="567" colspan="9" height="47" style="BORDER-RIGHT: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; BORDER-LEFT: #ff00ff 2pt double; WIDTH: 425.25pt; COLOR: #0000ff; BORDER-BOTTOM: #ff00ff 0.5pt dotted; FONT-STYLE: normal; WHITE-SPACE: normal; HEIGHT: 35.25pt; TEXT-ALIGN: left; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;">3、选择"工具"→"选项"→把工作表标签的选勾去掉即可。</td></tr><tr height="47"><td class="et16" width="567" colspan="9" height="47" style="BORDER-RIGHT: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; BORDER-LEFT: #ff00ff 2pt double; WIDTH: 425.25pt; COLOR: #0000ff; BORDER-BOTTOM: #ff00ff 0.5pt dotted; FONT-STYLE: normal; WHITE-SPACE: normal; HEIGHT: 35.25pt; TEXT-ALIGN: left; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;">4、选择"文件"→"页面设置"→选“工作表”,在顶端标题行或左端标题列选中要打印的标题,点击确定。</td></tr><tr height="47"><td class="et16" width="567" colspan="9" height="47" style="BORDER-RIGHT: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; BORDER-LEFT: #ff00ff 2pt double; WIDTH: 425.25pt; COLOR: #0000ff; BORDER-BOTTOM: #ff00ff 0.5pt dotted; FONT-STYLE: normal; WHITE-SPACE: normal; HEIGHT: 35.25pt; TEXT-ALIGN: left; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;">5、可在"窗口"菜单栏选择"拆分"即可.</td></tr><tr height="47"><td class="et16" width="567" colspan="9" height="47" style="BORDER-RIGHT: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; BORDER-LEFT: #ff00ff 2pt double; WIDTH: 425.25pt; COLOR: #0000ff; BORDER-BOTTOM: #ff00ff 0.5pt dotted; FONT-STYLE: normal; WHITE-SPACE: normal; HEIGHT: 35.25pt; TEXT-ALIGN: left; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;">6、选择"工具"→"选项"→在保存选项里选"第一次保存生成文件",选"定时备份,时间间隔:十分钟"即可.</td></tr><tr height="47"><td class="et16" width="567" colspan="9" height="47" style="BORDER-RIGHT: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; BORDER-LEFT: #ff00ff 2pt double; WIDTH: 425.25pt; COLOR: #0000ff; BORDER-BOTTOM: #ff00ff 0.5pt dotted; FONT-STYLE: normal; WHITE-SPACE: normal; HEIGHT: 35.25pt; TEXT-ALIGN: left; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;">7、选中需要打印的表格范围,复制,按住Shift键单击“编辑”菜单,“粘贴图片”。然后在这个图片上右键-设置图片格式-颜色与线条,打开“填充”项下的“颜色”下拉框,填充效果-图片-选择图片。<br/></td></tr><tr height="47"><td class="et19" width="567" colspan="9" height="47" style="BORDER-RIGHT: #ff00ff 2pt double; FONT-WEIGHT: 400; FONT-SIZE: 12pt; BACKGROUND: #ffffff; VERTICAL-ALIGN: bottom; BORDER-LEFT: #ff00ff 2pt double; WIDTH: 425.25pt; COLOR: #0000ff; BORDER-BOTTOM: #ff00ff 2pt double; FONT-STYLE: normal; WHITE-SPACE: normal; HEIGHT: 35.25pt; TEXT-ALIGN: left; TEXT-DECORATION: none; mso-pattern: #000000 none; mso-protection: locked visible;">8、在"窗口"菜单中选"重排窗口或者是并排比较"命令,即可.</td></tr></tbody></table><p>&nbsp;</p><p><font color="#f70938" size="4"><strong>第一问:没有表达清楚</strong></font></p><p><font color="#f70938" size="4"><strong>第二问:没有达到加密工作薄的目的</strong></font></p><p><strong><font color="#f70938" size="4">第五问:是快速改变工作表的显示比例</font></strong></p><p><strong><font color="#f70938" size="4">第八问:题目本来有误(不怪你们)</font></strong></p><p>&nbsp;</p><p><strong><font color="#ff0033" size="4">另外你上交作业不是回复可见帖,下次不改正要受到惩罚!</font></strong></p>
[此贴子已经被万杰于2008-8-10 16:28:23编辑过]
回复

使用道具 举报

发表于 2008-8-10 21:54 | 显示全部楼层

<p>:)抱歉,我没看上交作业扫盲贴,争取下回学会.</p><p>&nbsp;</p><p><strong><font color="#ff0033" size="4">不要回复与作业无关的内容</font></strong></p>
[此贴子已经被万杰于2008-8-12 9:40:38编辑过]
回复

使用道具 举报

发表于 2016-1-31 18:16 | 显示全部楼层
fdfddf
回复

使用道具 举报

发表于 2016-8-29 10:01 | 显示全部楼层
122222
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2024-6-7 04:25 , Processed in 0.320475 second(s), 4 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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