Excel精英培训网

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

【新手4班】第二讲(321~402)作业上交贴

[复制链接]
发表于 2010-10-23 16:58 | 显示全部楼层

新4班326号第2讲作业

<p>新4班326号第2讲作业</p><p><table cellspacing="0" cellpadding="0" width="952" border="0" style="WIDTH: 714pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="76" style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2432;"></col><col></col><col width="84" style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 2688;"></col><col></col><col span="11" width="72" style="WIDTH: 54pt;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt; mso-height-source: userset;"><td class="xl69" width="76" height="19" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff 1pt solid; BORDER-LEFT: #ffffff 1pt solid; WIDTH: 57pt; BORDER-BOTTOM: #ffffff; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl70" width="84" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff 1pt solid; BORDER-LEFT: #ffffff; WIDTH: 63pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl70" width="72" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff 1pt solid; BORDER-LEFT: #ffffff; WIDTH: 54pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl70" width="72" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff 1pt solid; BORDER-LEFT: #ffffff; WIDTH: 54pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl70" width="72" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff 1pt solid; BORDER-LEFT: #ffffff; WIDTH: 54pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl70" width="72" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff 1pt solid; BORDER-LEFT: #ffffff; WIDTH: 54pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl70" width="72" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff 1pt solid; BORDER-LEFT: #ffffff; WIDTH: 54pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl70" width="72" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff 1pt solid; BORDER-LEFT: #ffffff; WIDTH: 54pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl70" width="72" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff 1pt solid; BORDER-LEFT: #ffffff; WIDTH: 54pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl70" width="72" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff 1pt solid; BORDER-LEFT: #ffffff; WIDTH: 54pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl70" width="72" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff 1pt solid; BORDER-LEFT: #ffffff; WIDTH: 54pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl71" width="72" style="BORDER-RIGHT: #ffffff 1pt solid; BORDER-TOP: #ffffff 1pt solid; BORDER-LEFT: #ffffff; WIDTH: 54pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td width="72" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; WIDTH: 54pt; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="30" style="HEIGHT: 22.5pt; mso-height-source: userset;"><td class="xl72" align="left" colspan="6" height="30" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff 1pt solid; BORDER-BOTTOM: #ffffff; HEIGHT: 22.5pt; BACKGROUND-COLOR: #c7edcc; mso-ignore: colspan;"><font face="宋体">
游客,如果您要查看本帖隐藏内容请回复
</font></td></tr><tr height="119" style="HEIGHT: 89.25pt; mso-height-source: userset;"><td class="xl82" width="880" colspan="12" height="119" style="BORDER-RIGHT: #ffffff 1pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff 1pt solid; WIDTH: 660pt; BORDER-BOTTOM: #ffffff; HEIGHT: 89.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"><br/></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl74" height="19" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff 1pt solid; BORDER-BOTTOM: #ffffff; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><p><font face="宋体"> </font></p><p><font face="宋体"></font></p><p><font face="宋体" color="#ff0000">通过</font></p></td><td class="xl68" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><p><font face="宋体"></font></p><p><font face="宋体"></font></p><p><font face="宋体"></font></p><p><font face="宋体"></font></p><p><font face="宋体"></font></p><p><font face="宋体"></font></p></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl75" style="BORDER-RIGHT: #ffffff 1pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl74" height="19" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff 1pt solid; BORDER-BOTTOM: #ffffff; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td><td class="xl75" style="BORDER-RIGHT: #ffffff 1pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"><font face="宋体"></font></td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl76" height="20" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff 1pt solid; BORDER-BOTTOM: #ffffff 1pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl77" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff 1pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl77" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff 1pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl77" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff 1pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl77" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff 1pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl77" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff 1pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl77" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff 1pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl77" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff 1pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl77" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff 1pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl77" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff 1pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl77" style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff 1pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td class="xl78" style="BORDER-RIGHT: #ffffff 1pt solid; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff 1pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体"> </font></td><td style="BORDER-RIGHT: #ffffff; BORDER-TOP: #ffffff; BORDER-LEFT: #ffffff; BORDER-BOTTOM: #ffffff; BACKGROUND-COLOR: transparent;"></td></tr></tbody></table></p>
[此贴子已经被wjc2090742于2010-10-25 15:49:10编辑过]
excel精英培训的微信平台,每天都会发送excel学习教程和资料。扫一扫明天就可以收到新教程
回复

使用道具 举报

发表于 2010-10-23 17:15 | 显示全部楼层
提示: 作者被禁止或删除 内容自动屏蔽
回复

使用道具 举报

发表于 2010-10-23 17:59 | 显示全部楼层

新4班324号第2讲作业

游客,如果您要查看本帖隐藏内容请回复
QCdUcTLp.rar (16.84 KB, 下载次数: 0)
回复

使用道具 举报

发表于 2010-10-23 18:18 | 显示全部楼层

<p><strong><font face="Arial Narrow" color="#ff0000" size="4">新4班<font color="#0909f7">345</font>号第2讲作业</font></strong></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">第</span><span lang="EN-US"><font face="Times New Roman">1</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">题答案</span><span lang="EN-US"><font face="Times New Roman">:</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">第①种方法</span><span lang="EN-US"><font face="Times New Roman">:</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">单击行标</span><span lang="EN-US"><font face="Times New Roman">1,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">选中第一行</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">格式</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">行</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">行高</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">行高</span><span lang="EN-US"><font face="Times New Roman">:30\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">确定</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">第②种方法</span><span lang="EN-US"><font face="Times New Roman">:</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">右击行标</span><span lang="EN-US"><font face="Times New Roman">1\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">行高</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">行高</span><span lang="EN-US"><font face="Times New Roman">:30\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">确定</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">第③种方法</span><span lang="EN-US"><font face="Times New Roman">:</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">光标移到第一行与第二行行标之间</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">光标变为上下箭头光标</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">按左健不放</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">下拖</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">高度</span><span lang="EN-US"><font face="Times New Roman">:30(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">像素</span><span lang="EN-US"><font face="Times New Roman">40)</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><font face="Times New Roman">&nbsp;</font></p></span></p><p><font face="Times New Roman">&nbsp;</font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">第</span><span lang="EN-US"><font face="Times New Roman">2</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">题答案</span><span lang="EN-US"><font face="Times New Roman">:</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman">Ctrl+A\delete</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><font face="Times New Roman">&nbsp;</font></p></span></p><p><font face="Times New Roman">&nbsp;</font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">第</span><span lang="EN-US"><font face="Times New Roman">3</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">题答案</span><span lang="EN-US"><font face="Times New Roman">:</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">第①种方法</span><span lang="EN-US"><font face="Times New Roman">:</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">选中黄色区域</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">在名称框输入</span><span lang="EN-US"><font face="Times New Roman">AA</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">第②种方法</span><span lang="EN-US"><font face="Times New Roman">:</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">选中黄色区域</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">插入</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">名称</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">定义</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">在当前工作薄中的名称</span><span lang="EN-US"><font face="Times New Roman">:BB\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">确定</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><font face="Times New Roman">&nbsp;</font></p></span></p><p><font face="Times New Roman">&nbsp;</font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">第</span><span lang="EN-US"><font face="Times New Roman">4</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">题答案</span><span lang="EN-US"><font face="Times New Roman">:</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">选中黄色区域</span><span lang="EN-US"><font face="Times New Roman">\ctrl+h\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">查找内容</span><span lang="EN-US"><font face="Times New Roman">:Excel</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">精英</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">替换为</span><span lang="EN-US"><font face="Times New Roman">:Excel</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">精英培训</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">全部替换</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><font face="Times New Roman">&nbsp;</font></p></span></p><p><font face="Times New Roman">&nbsp;</font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">第</span><span lang="EN-US"><font face="Times New Roman">5</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">题答案</span><span lang="EN-US"><font face="Times New Roman">:</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><shapetype id="_x0000_t75" coordsize="21600,21600" ospt="75" opreferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"></shapetype><stroke joinstyle="miter"></stroke><stroke></stroke><formulas></formulas><f eqn="if lineDrawn pixelLineWidth 0"></f><f></f><f eqn="sum @0 1 0"></f><f></f><f eqn="sum 0 0 @1"></f><f></f><f eqn="prod @2 1 2"></f><f></f><f eqn="prod @3 21600 pixelWidth"></f><f></f><f eqn="prod @3 21600 pixelHeight"></f><f></f><f eqn="sum @0 0 1"></f><f></f><f eqn="prod @6 1 2"></f><f></f><f eqn="prod @7 21600 pixelWidth"></f><f></f><f eqn="sum @8 21600 0"></f><f></f><f eqn="prod @7 21600 pixelHeight"></f><f></f><f eqn="sum @10 21600 0"></f><f></f><formulas></formulas><path oextrusionok="f" gradientshapeok="t" oconnecttype="rect"></path><path></path><lock vext="edit" aspectratio="t"></lock><lock></lock><shapetype></shapetype><shape id="_x0000_i1025" type="#_x0000_t75" style="WIDTH: 351pt; HEIGHT: 263.25pt;"></shape><imagedata src="file:///C:\Users\lenovo\AppData\Local\Temp\msohtml1\02\clip_image001.jpg" otitle="9999"></imagedata><font face="Times New Roman"></font><imagedata></imagedata><shape></shape></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><font face="Times New Roman">&nbsp;</font></p></span></p><p><font face="Times New Roman">&nbsp;</font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span lang="EN-US" style="mso-fareast-font-family: &quot;Times New Roman&quot;;"><span style="mso-list: Ignore;"><font face="Times New Roman">①<span style="FONT: 7pt &quot;Times New Roman&quot;;"><font size="3">&nbsp;&nbsp;&nbsp;&nbsp; </font></span></font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">选中蓝色单元格</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">右击</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">设置单元格格式</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">保护</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">勾选锁定与隐藏</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 18pt; TEXT-INDENT: -18pt; mso-list: l0 level1 lfo1; tab-stops: list 18.0pt;"><span lang="EN-US" style="mso-fareast-font-family: &quot;Times New Roman&quot;;"><span style="mso-list: Ignore;"><font face="Times New Roman">②<span style="FONT: 7pt &quot;Times New Roman&quot;;"><font size="3">&nbsp;&nbsp;&nbsp;&nbsp; </font></span></font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">工具</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">保护</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">保护工作表</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">勾选保护工作表及锁定的单元格内容</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">确定</span></p><p></p><p></p><p></p><p></p><p></p><p></p><p><font color="#ff0000">第2题错误,通过</font></p>
[此贴子已经被wjc2090742于2010-10-25 15:51:45编辑过]
回复

使用道具 举报

发表于 2010-10-23 21:55 | 显示全部楼层

新4班394号 第二讲作业

游客,如果您要查看本帖隐藏内容请回复
</p><p></p><p></p><p><font color="#ff0000">第2、5题错误</font></p>
[此贴子已经被wjc2090742于2010-10-25 15:53:08编辑过]
回复

使用道具 举报

发表于 2010-10-23 22:48 | 显示全部楼层

<p>我来也</p>
回复

使用道具 举报

发表于 2010-10-23 23:04 | 显示全部楼层

<p><table cellspacing="0" cellpadding="0" width="885" border="0" style="WIDTH: 664pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="76" style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2432;"></col><col></col><col width="84" style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 2688;"></col><col></col><col span="5" width="72" style="WIDTH: 54pt;"></col><col></col><col width="65" style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2080;"></col><col></col><col width="84" style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 2688;"></col><col></col><col span="3" width="72" style="WIDTH: 54pt;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" width="448" colspan="6" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; WIDTH: 336pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #d7d7d7; mso-ignore: colspan;">第1题:将第1<font class="font5">行的行高设为30,写出</font><font class="font0">3</font><font class="font5">种的操作方法。</font></td><td class="xl67" width="72" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 54pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" width="65" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 49pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" width="84" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 63pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" width="72" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 54pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" width="72" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 54pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl69" width="72" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 54pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td></tr><tr height="80" style="HEIGHT: 60pt; mso-height-source: userset;"><td class="xl72" width="885" colspan="12" height="80" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; WIDTH: 664pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 60pt; BACKGROUND-COLOR: transparent;">答:1<font class="font0">.把鼠标放在第一行的行头,单击右键,在对话框中输入30,确定就行了。2.是选中第一行,点击格式,再点行高,在对话框中输入30确定就行了。3.将鼠标移到第一行和第二行和标题的交界处,成双向拖拉箭头状时,按住左键向下,即可调整行高。<br/></font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl70" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"> </td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td class="xl71" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"> </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" colspan="5" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #d7d7d7; mso-ignore: colspan;">第2题:<font class="font7">写出快速删除表中所有对象的操作过程。</font></td><td class="xl67" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl69" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl75" colspan="12" height="19" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">答:用鼠标点击左上角的行与列的相交处,再单击右键,点删除就行了。</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl70" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"> </td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td class="xl71" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"> </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" colspan="7" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #d7d7d7; mso-ignore: colspan;">第3题:用两种方法将下图黄色区域定义名称,名分别为AA和BB。</td><td class="xl67" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl69" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl70" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"> </td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td class="xl71" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"> </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl70" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"> </td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td class="xl71" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"> </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" colspan="8" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #d7d7d7; mso-ignore: colspan;">第4题:写出将黄色区域中的"Excel精英"替换成"Excel精英培训"的操作过程。</td><td class="xl67" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl67" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td><td class="xl69" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: #d7d7d7;"> </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl70" colspan="12" height="19" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; mso-ignore: colspan;">答:先选中黄色区域,点编辑,再点查找-<font class="font0">Excel</font><font class="font5">精英</font><font class="font0">--在霍霍换对话框中输入--Excel精英培训--再点完全替换。就行了。</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl70" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"> </td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"></td><td class="xl71" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"> </td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl68" colspan="12" height="19" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: #d7d7d7; mso-ignore: colspan;">第<font class="font7">5题:将下面黄色区域中有公式的单元格用蓝色底纹表示并把公式隐藏起来(选中有公式的单元格时,编辑栏不出现公式),请说出操作过程:</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl78" width="885" colspan="12" height="19" style="BORDER-RIGHT: purple 1pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: purple 1pt solid; WIDTH: 664pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><p>答:首先选中带有公式的表格,第一步单击工具条中的“格式”单击“单元格”展开菜单中的“保护”取消“锁定”对话框中的∨对钩OK确定;<br/><br/>第二步单击表格对话框中的“编辑”单击展开菜单的“定位”单击展开菜单的“定位条件”单击“公式”对话框中的“圆点”OK确定;<br/><br/>第三步单击表格对话框中的“工具”在展开菜单中鼠标指向“保护”对话框单击“允许用户编辑区域”在展开对话框中单击“新建” 在展开对话框中单击“引用单元格”框中的“方框红箭头”按住“ctrl”键,选择你要编辑的区域选好后单击“方框红箭头”回到新建区域对话框按“确定”回到“允许用户编辑区域”对话框单击“应用”单击“保护工作表”输入你常用的“密码”确定退出。完成隐藏公式目的又能进行有效的编辑。<br/><br/></p><p></p><p></p><p></p><p></p><p><font color="#ff0000">第2题错误,通过</font></p></td></tr></tbody></table></p>
[此贴子已经被wjc2090742于2010-10-25 15:56:16编辑过]
回复

使用道具 举报

发表于 2010-10-24 11:06 | 显示全部楼层

新手4班393第二次作业

<p>
游客,如果您要查看本帖隐藏内容请回复
</p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p><font color="#ff0000">第2题错误,通过</font></p>
[此贴子已经被wjc2090742于2010-10-25 15:57:02编辑过]
回复

使用道具 举报

发表于 2010-10-24 11:34 | 显示全部楼层

<p><strong><font face="Arial Narrow" color="#ff0000" size="4">新4班<font color="#0909f7">379</font>号第2讲作业</font></strong></p><p>
游客,如果您要查看本帖隐藏内容请回复
</p><p></p><p></p><p></p><p></p><p></p><p></p><p><font color="#ff0000">通过</font></p>
[此贴子已经被wjc2090742于2010-10-25 15:57:59编辑过]
回复

使用道具 举报

发表于 2010-10-24 12:14 | 显示全部楼层

<p>新4班327号 尘尘123交作业:</p><p><table cellspacing="0" cellpadding="0" width="1691" border="0" style="WIDTH: 1268pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="1691" style="WIDTH: 1268pt; mso-width-source: userset; mso-width-alt: 54112;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td width="1691" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 1268pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第一题:1、在行号上点击右键,在出现的菜单里选择行高,输入30;2、点击“格式”,选择“行”,再选择行高,输入30;3、鼠标放在两个行号间,点击左键向下拉动至数值显示为30.</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第二题:点击行号和列号交叉处的空白框,点击右键后,再点击“删除”。</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第三题:方法一:选定区域,在名称框中输入“AA”,然后回车即可;方法二:点击插入-名称-定义,在对话框中输入BB,用下方“引用位置”处选择区域,然后点击确定即可!</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第四题:选中黄色区域,按下“Ctrl+F”,在出现的“查找和替换”框中点击替换,再“查找内容”中输入“Excel精英”,在“替换为”中输入“Excel精英培训”,再点击下方的“替换”即可。</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第五题:选中黄色区域,按下“Ctrl+G”,在出现的对话框中点击“定位条件”,然后选择“公式”,确定后,再点击格式,点击单元格格式的“图案”,选择蓝色;然后点击工具-保护-保护工作表就可隐藏公式了。</td></tr></tbody></table></p><p></p><p></p><p></p><p></p><p><font color="#ff0000">第2题错误,通过</font></p>
[此贴子已经被wjc2090742于2010-10-25 15:58:36编辑过]
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2024-4-30 13:37 , Processed in 0.689286 second(s), 10 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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