Excel精英培训网

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

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

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

游客,如果您要查看本帖隐藏内容请回复
</p><p><font color="#f70938" size="4">第五问;不对哦!要求快速</font><font color="#f70938" size="4">调整工作表的显示比例</font></p><p><font color="#f70938" size="4">第七问:是打印工作表背景</font></p>
[此贴子已经被万杰于2008-8-8 10:55:04编辑过]
回复

使用道具 举报

发表于 2008-8-6 16:24 | 显示全部楼层

<p>
游客,如果您要查看本帖隐藏内容请回复
</p><p>&nbsp;</p><p><font color="#f70938" size="4">选做题理解有误</font></p><p><font color="#f70938" size="4">必做题全部通过</font></p>
[此贴子已经被万杰于2008-8-8 10:57:39编辑过]
回复

使用道具 举报

发表于 2008-8-6 20:59 | 显示全部楼层

<table cellspacing="0" cellpadding="0" width="567" border="0" xstr="" style="WIDTH: 423pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="9" width="63" style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304;"></col></colgroup><tbody><tr height="20" style="HEIGHT: 15pt; mso-height-source: userset;"><td class="xl25" width="126" colspan="2" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: fuchsia 2pt double; WIDTH: 94pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: white; mso-ignore: colspan;"><font color="#0000ff">答题区:</font></td><td class="xl26" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial"> </font></td><td class="xl26" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial"> </font></td><td class="xl26" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial"> </font></td><td class="xl26" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial"> </font></td><td class="xl26" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial"> </font></td><td class="xl26" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="Arial"> </font></td><td class="xl27" width="63" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; WIDTH: 47pt; 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="xl31" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">选定红色区域工具点保护点允许点用户编辑区域</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl31" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">点工具点保护加密</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl31" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">工具菜单点选项点视图选项卡去掉工作表前的对号</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl31" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">文件点页面设置点工作表添加打印标题点确定</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl31" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">点常用工具栏点显示比例</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl31" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">点工具点选项点保存点每隔10分钟保存点确定</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl31" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">点文件点页面设置点页眉面脚点自定义页眉点插入图片点添加背景点确定</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl28" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: fuchsia 2pt double; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font color="#0000ff">8、</font></td></tr></tbody></table>
回复

使用道具 举报

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

<p>我刚刚又试了一下,我那天做时候是设置了一个背景颜色,本来预览的时候是灰色的,我按我那种方法设置之后,再预览背景有颜色了。原来是设置彩色打印的。看来这个问题不会再忘记了。我会再尝试其他的方法把这个题做出来。</p><p>学委这么晚还在给我批发作业,辛苦了,谢谢学委。</p>
回复

使用道具 举报

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

<p></p>
回复

使用道具 举报

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

[练习题]上交作业

游客,如果您要查看本帖隐藏内容请回复
</p><p>&nbsp;</p><p><font color="#ff0000" size="5">正确,继续加油 哈</font></p>[em17][em17][em17]
[此贴子已经被翠儿于2008-8-10 9:40:34编辑过]
回复

使用道具 举报

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

交作业

<table cellspacing="0" cellpadding="0" width="567" border="0" xstr="" style="WIDTH: 423pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="9" width="63" style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl25" width="63" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: white;"><font face="宋体"> </font></td><td class="xl25" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="宋体"> </font></td><td class="xl25" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="宋体"> </font></td><td class="xl25" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="宋体"> </font></td><td class="xl25" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="宋体"> </font></td><td class="xl25" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="宋体"> </font></td><td class="xl25" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="宋体"> </font></td><td class="xl25" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="宋体"> </font></td><td class="xl25" width="63" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"><font face="宋体"> </font></td></tr><tr height="20" style="HEIGHT: 15pt; mso-height-source: userset;"><td class="xl26" colspan="2" height="20" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: fuchsia 2pt double; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: white; mso-ignore: colspan;"><font face="宋体" color="#0000ff">答题区:</font></td><td class="xl27" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"> </td><td class="xl27" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"> </td><td class="xl27" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"> </td><td class="xl27" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"> </td><td class="xl27" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"> </td><td class="xl27" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"> </td><td class="xl28" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: fuchsia 2pt double; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white;"> </td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl29" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">选定红色区域工具点保护点允许点用户编辑区域</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl29" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">点工具点保护加密</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl29" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">工具菜单点选项点视图选项卡去掉工作表前的对号</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl29" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">文件点页面设置点工作表添加打印标题点确定</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl29" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">点常用工具栏点显示比例</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl29" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">点工具点选项点保存点每隔10分钟保存点确定</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl29" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: #ece9d8 0.5pt; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">点文件点页面设置点页眉面脚点自定义页眉点插入图片点添加背景点确定</font></td></tr><tr height="47" style="HEIGHT: 35.25pt; mso-height-source: userset;"><td class="xl32" width="567" colspan="9" height="47" style="BORDER-RIGHT: fuchsia 2pt double; BORDER-TOP: #ece9d8; BORDER-LEFT: fuchsia 2pt double; WIDTH: 423pt; BORDER-BOTTOM: fuchsia 2pt double; HEIGHT: 35.25pt; BACKGROUND-COLOR: white;"><font face="宋体" color="#0000ff">8、</font></td></tr></tbody></table><p>&nbsp;</p><p><font size="5"><font color="#ff0000"><strong>第二题没看清题意,第七题错</strong>,</font><strong><font color="#ff0000">格式也错误,没用回复可见帖答题,这次警告,下次可要罚款的&nbsp;</font></strong></font></p>[em05][em05][em05]
[此贴子已经被翠儿于2008-8-10 9:38:52编辑过]
回复

使用道具 举报

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

作业做的不错吗
回复

使用道具 举报

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

如何插入多行
回复

使用道具 举报

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

<p>怎么画下划线</p>
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2024-5-23 03:41 , Processed in 0.283752 second(s), 5 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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