<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: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">第</span><span lang="EN-US"><font face="Times New Roman">1</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">题答案</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: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">第①种方法</span><span lang="EN-US"><font face="Times New Roman">:</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">单击行标</span><span lang="EN-US"><font face="Times New Roman">1,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">选中第一行</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">格式</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">行</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">行高</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">行高</span><span lang="EN-US"><font face="Times New Roman">:30\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">确定</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">第②种方法</span><span lang="EN-US"><font face="Times New Roman">:</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">右击行标</span><span lang="EN-US"><font face="Times New Roman">1\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">行高</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">行高</span><span lang="EN-US"><font face="Times New Roman">:30\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">确定</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">第③种方法</span><span lang="EN-US"><font face="Times New Roman">:</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">光标移到第一行与第二行行标之间</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">光标变为上下箭头光标</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">按左健不放</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">下拖</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">高度</span><span lang="EN-US"><font face="Times New Roman">:30(</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">像素</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"> </font></p></span></p><p><font face="Times New Roman"> </font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">第</span><span lang="EN-US"><font face="Times New Roman">2</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">题答案</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"> </font></p></span></p><p><font face="Times New Roman"> </font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">第</span><span lang="EN-US"><font face="Times New Roman">3</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">题答案</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: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">第①种方法</span><span lang="EN-US"><font face="Times New Roman">:</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">选中黄色区域</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">在名称框输入</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: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">第②种方法</span><span lang="EN-US"><font face="Times New Roman">:</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">选中黄色区域</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">插入</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">名称</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">定义</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">在当前工作薄中的名称</span><span lang="EN-US"><font face="Times New Roman">:BB\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">确定</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><font face="Times New Roman"> </font></p></span></p><p><font face="Times New Roman"> </font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">第</span><span lang="EN-US"><font face="Times New Roman">4</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">题答案</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: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">选中黄色区域</span><span lang="EN-US"><font face="Times New Roman">\ctrl+h\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">查找内容</span><span lang="EN-US"><font face="Times New Roman">:Excel</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">精英</span><span lang="EN-US"><font face="Times New Roman">,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">替换为</span><span lang="EN-US"><font face="Times New Roman">:Excel</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">精英培训</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">全部替换</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><font face="Times New Roman"> </font></p></span></p><p><font face="Times New Roman"> </font></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">第</span><span lang="EN-US"><font face="Times New Roman">5</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">题答案</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"> </font></p></span></p><p><font face="Times New Roman"> </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: "Times New Roman";"><span style="mso-list: Ignore;"><font face="Times New Roman">①<span style="FONT: 7pt "Times New Roman";"><font size="3"> </font></span></font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">选中蓝色单元格</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">右击</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">设置单元格格式</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">保护</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">勾选锁定与隐藏</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: "Times New Roman";"><span style="mso-list: Ignore;"><font face="Times New Roman">②<span style="FONT: 7pt "Times New Roman";"><font size="3"> </font></span></font></span></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">工具</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">保护</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">保护工作表</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">勾选保护工作表及锁定的单元格内容</span><span lang="EN-US"><font face="Times New Roman">\</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">确定</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编辑过] |