【综合6期1班】第三讲补交作业贴 - Excel 综合班 - Excel精英培训网 - Powered by Discuz! Archiver

论坛 › Excel 综合班 › 【综合6期1班】第三讲补交作业贴

zhang84997 发表于 2009-10-31 10:29

【综合6期1班】第三讲补交作业贴

<p align="center"><font color="#ee0000" size="5">第三讲作业补交贴，下午18:00锁贴，请抓紧时间了。</font></p>

liuwenxin197 发表于 2009-10-31 10:43

<p>**** Hidden Message *****</p>

liuwenxin197 发表于 2009-10-31 10:44

我终于交作业了，虽然是补交，但是是我自己作的

futuer015 发表于 2009-10-31 11:26

<p>0107,怎么老是赶不上猫步呢!</p><p>**** Hidden Message *****</p>

zpa224 发表于 2009-10-31 11:48

**** Hidden Message *****

yimo 发表于 2009-10-31 12:15

**** Hidden Message *****

你在那里 发表于 2009-10-31 12:50

[练习题]交作业

**** Hidden Message *****

星星源 发表于 2009-10-31 12:58

[练习题]交作业

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman"><span style="mso-spacerun: yes;">  一</span></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"><a href="http://www.excelpx.com">www.excelpx.com</a></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 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";"><font face="Times New Roman">二</font>、</span><span lang="EN-US"><span style="mso-spacerun: yes;"><font face="Times New Roman">   </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">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></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><p><font face="Times New Roman"> </font></p></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">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">ctrl+F</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">--ctrl+A</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">=A15</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">ctrl+enter</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 class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><font face="Times New Roman"><span style="mso-spacerun: yes;"> 三个</span></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">10</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">ctrl+A</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;"><span lang="EN-US"><p><font face="Times New Roman"> </font></p></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";"><font face="Times New Roman">四</font>、一共有</span><span lang="EN-US"><font face="Times New Roman">24</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 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";"><font face="Times New Roman">五</font>、定位—对象—右击</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">5.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">5.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"><font face="Times New Roman"></font></span></p>

iwan2000 发表于 2009-10-31 14:53

**** Hidden Message *****

苦涩的李子 发表于 2009-10-31 16:09

**** Hidden Message *****

页: [1] 2

查看完整版本: 【综合6期1班】第三讲补交作业贴