Excel精英培训网

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

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

[复制链接]
发表于 2008-8-9 22:03 | 显示全部楼层

交作业

游客,如果您要查看本帖隐藏内容请回复
</p><p><font color="#ff0033" size="4">第二问:另一种方法也正确</font></p><p><font color="#ff0033" size="4">完美通过!</font></p><p>&nbsp;</p>[em17][em17][em17]
[此贴子已经被万杰于2008-8-9 22:21:28编辑过]
回复

使用道具 举报

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

<p>
游客,如果您要查看本帖隐藏内容请回复
</p><p><font face="隶书" color="#ff0066" size="4">请不要回复与作业无关的内容</font></p>
[此贴子已经被万杰于2008-8-9 22:24:22编辑过]
回复

使用道具 举报

发表于 2008-8-9 22:13 | 显示全部楼层

交作业

<table height="396" width="575" style="WIDTH: 431.25pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="63"></col><col width="64"></col><col width="64"></col><col width="64"></col><col width="64"></col><col width="64"></col><col width="64"></col><col width="64"></col><col width="64"></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>
回复

使用道具 举报

发表于 2008-8-9 22:13 | 显示全部楼层

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

使用道具 举报

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

交作业了

游客,如果您要查看本帖隐藏内容请回复
</p><p><strong><font color="#ff0033" size="4">通过!</font></strong></p><p><strong><font color="#ff0033" size="4">头衔没有改!</font></strong></p>
[此贴子已经被万杰于2008-8-12 9:46:04编辑过]
回复

使用道具 举报

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

交作业
游客,如果您要查看本帖隐藏内容请回复
</p><p><strong><font color="#ff0033" size="4">通过!头衔没有改</font></strong></p>
[此贴子已经被万杰于2008-8-12 9:47:34编辑过]
回复

使用道具 举报

发表于 2008-8-11 00:03 | 显示全部楼层

游客,如果您要查看本帖隐藏内容请回复
</p><strong><font color="#ff0033" size="4"><p><strong><font color="#ff0033" size="4">第八题是同时打开多个工作薄文件!</font></strong></p><p>其他完成的很好</p></font></strong>
[此贴子已经被万杰于2008-8-12 9:49:24编辑过]
回复

使用道具 举报

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

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

使用道具 举报

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

使用道具 举报

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

使用道具 举报

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

本版积分规则

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

GMT+8, 2024-6-6 21:22 , Processed in 0.263347 second(s), 6 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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