hccj2008
发表于 2007-5-24 14:52
看看先
兰仪
发表于 2007-5-24 16:10
<p>支持，谢谢了！</p>
paq20070501
发表于 2007-5-24 16:32
<p>哪里有下载的啊</p>
燕子11
发表于 2007-5-24 16:36
<p>谢谢 </p><p></p>
lesson
发表于 2007-5-24 23:32
<p>好贴</p><p></p>
happyzxh
发表于 2007-5-25 08:33
<p>谢谢!</p>
happyzxh
发表于 2007-5-25 08:35
谢谢!谢谢!
非常感谢!
liuhuanfa
发表于 2007-5-25 09:20
<p>板凳也借用一下</p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">第</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman">5</font></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">章</span><span lang="EN-US" style="COLOR: #993300;"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">数据查找与多表核对技术</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></b></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.1<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">手工查找</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.1.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">使用通配符查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.1.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">精确查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.1.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">按颜色查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.2<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">按方向查找</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.2.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">单向查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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">VLOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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">HLOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">3.<span style="mso-tab-count: 1;"> </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">INDEX+MATCH</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.2.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">双向查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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">INDEXT+MATCH</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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">VLOOKUP+MATCH</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">3.<span style="mso-tab-count: 1;"> </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">OFFSET+MATCHE</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.2.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">双列查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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">VLOOKUP+</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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">INDEX+MATCH</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">3.<span style="mso-tab-count: 1;"> </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">LOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.3<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">特殊位置查找</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.3.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">查找最后一个非空单元格</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.3.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">查找最后一个相同值</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.3.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">查找并返回最大前三名的记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.3.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">查找并显示图片</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.4<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">模糊查找</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.4.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">字符模糊查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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">VLOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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">LOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.4.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">字母大小写匹配查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.4.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">最接近值的查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.4.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">数值区间查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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">VLOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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">LOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.5<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">数据表的查询</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">提取整行不重复的记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">按某几列提取不重复的记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">筛选两表重复记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">筛选两表不重复记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.5<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">筛选包含某字符串的记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.6<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">筛选最大前五名记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.7<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">自动完成高级筛选</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.6<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">表与表之间的核对</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><font face="Times New Roman"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US">5.6.1<span style="mso-tab-count: 1;"> </span></span><chsdate></chsdate><chsdate></chsdate><span lang="EN-US">VLOOKUP</span></font><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">函数查询法</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.6.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">条件格式法</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.6.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">合并计算法</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.7<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">本章小结</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">第</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman">6</font></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">章</span><span lang="EN-US" style="COLOR: #993300;"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">日期与时间处理技术</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></b></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">6.1<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">日期间隔计算</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.1.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">计算两个日期相隔天数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.1.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">计算两个日期相隔月数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.1.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">计算两个日期相隔年数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">6.2<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">推算日期</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.2.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">返回若干天前（后）的日期</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.2.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">返回若干月前（后）的日期</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.2.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">返回若干年前（后）的日期</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">6.3<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">推算天数</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.3.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">计算指定月份天数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.3.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">计算期间内工作日天数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.3.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">计算期间内周日天数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">6.4<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">时间间隔计算</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.4.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><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">24</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.4.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><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">24</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.4.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><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">24</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">6.5<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">推算时间</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.5.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><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">24</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.5.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><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">24</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">6.6<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">日期与控件</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.6.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">使用数值调节钮输入日期</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.6.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">使用日期控件输入日期</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"></font></span></span> </p><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">第</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman">7</font></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">章</span><span lang="EN-US" style="COLOR: #993300;"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">文本处理技术</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></b></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">7.1<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">文本显示</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.1.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">单元格内文本行间距调整</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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">Word</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.1.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">改变字母大小写</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.1.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">公式显示为字符串</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">7.2<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">文本查找</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.2.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">精确查找字符位置</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.2.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">模糊查找字符位置</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">7.3<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">文本替换</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.3.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">指定字符替换</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.3.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">指定位置和数量替换</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">7.4<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">文本截取</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.4.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">从左边截取字符串</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.4.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">从右边截取字符串</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.4.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">提取字符串中两个字符之间的字符</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.4.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">截取中间部分字符</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.4.5<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">根据换行符截取</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd; mso-outline-level: 1;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.4.6<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">从字符串中截取数字</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">7.5<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">文本组合</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.5.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">多个单元格字符批量组合</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.5.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">日期与字符串组合</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">7.6<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">本章小结</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">第</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman">8</font></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">章</span><span lang="EN-US" style="COLOR: #993300;"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">表格打印技术</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></b></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">8.1<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">标题行（列）打印</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.1.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">顶端标题行</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.1.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">左端标题列</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.1.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">底端标题行</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.1.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">工资条打印</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">8.2<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">设置和调整打印区域</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.2.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">插入、删除和调整分页符</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">3.<span style="mso-tab-count: 1;"> </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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.2.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">限定打印页数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.2.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">分页小计</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">8.3<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">选择性打印</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.3.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">不打印图形</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.3.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">不打印指定单元格内容</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.3.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">不打印边线和指定文字（套打）</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.3.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">不打印填充颜色</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.3.5<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">不打印错误值</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">8.4<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">表格打印成卡片</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.4.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">使用控件和公式动态打印</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.4.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">使用邮件合并批量打印</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">8.5<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">本章小结</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">第</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman">9</font></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">章</span><span lang="EN-US" style="COLOR: #993300;"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">图表制作技术</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></b></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">9.1<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">制作图表</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd; mso-outline-level: 1;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">柱形图表制作</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">双坐标图表</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">工作进程图表（扇形图）</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">工作安排图表（甘特图）</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.5<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">多工作表合并图表</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.6<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">最近三天数据图表</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.7<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">随选取变换的动态图表</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">9.2<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">修饰图表</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.2.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">柱形图显示不同颜色</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.2.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">让平面的柱形图变得立体</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.2.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">图表区添加背景图片</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.2.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">数据点添加图片</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.2.5<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">柱形图根据条件显示不同颜色</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd; mso-outline-level: 1;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.2.6<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">制作半透明柱形图</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">9.3<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">调整图表结构</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">在图表上显示单元格文本。</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">自定义数字显示格式</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">柱形图内显示数字和标志</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">跳过空数据点的显示</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.5<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">添加平均线</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">9.4<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">本章小结</span><span lang="EN-US" style="COLOR: blue;"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p></font></span></span>
liuhuanfa
发表于 2007-5-25 09:21
<p>板凳也借用一下</p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">第</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman">5</font></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">章</span><span lang="EN-US" style="COLOR: #993300;"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">数据查找与多表核对技术</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></b></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.1<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">手工查找</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.1.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">使用通配符查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.1.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">精确查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.1.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">按颜色查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.2<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">按方向查找</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.2.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">单向查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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">VLOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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">HLOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">3.<span style="mso-tab-count: 1;"> </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">INDEX+MATCH</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.2.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">双向查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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">INDEXT+MATCH</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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">VLOOKUP+MATCH</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">3.<span style="mso-tab-count: 1;"> </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">OFFSET+MATCHE</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.2.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">双列查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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">VLOOKUP+</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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">INDEX+MATCH</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">3.<span style="mso-tab-count: 1;"> </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">LOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.3<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">特殊位置查找</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.3.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">查找最后一个非空单元格</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.3.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">查找最后一个相同值</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.3.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">查找并返回最大前三名的记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.3.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">查找并显示图片</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.4<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">模糊查找</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.4.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">字符模糊查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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">VLOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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">LOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.4.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">字母大小写匹配查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.4.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">最接近值的查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.4.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">数值区间查找</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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">VLOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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">LOOKUP</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.5<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">数据表的查询</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">提取整行不重复的记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">按某几列提取不重复的记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">筛选两表重复记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">筛选两表不重复记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.5<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">筛选包含某字符串的记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.6<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">筛选最大前五名记录</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.5.7<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">自动完成高级筛选</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.6<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">表与表之间的核对</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><font face="Times New Roman"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US">5.6.1<span style="mso-tab-count: 1;"> </span></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US">VLOOKUP</span></font><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">函数查询法</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.6.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">条件格式法</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">5.6.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">合并计算法</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">5.7<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">本章小结</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">第</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman">6</font></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">章</span><span lang="EN-US" style="COLOR: #993300;"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">日期与时间处理技术</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></b></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">6.1<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">日期间隔计算</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.1.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">计算两个日期相隔天数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.1.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">计算两个日期相隔月数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.1.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">计算两个日期相隔年数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">6.2<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">推算日期</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.2.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">返回若干天前（后）的日期</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.2.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">返回若干月前（后）的日期</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.2.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">返回若干年前（后）的日期</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">6.3<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">推算天数</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.3.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">计算指定月份天数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.3.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">计算期间内工作日天数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.3.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">计算期间内周日天数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">6.4<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">时间间隔计算</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.4.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><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">24</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.4.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><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">24</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.4.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><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">24</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">6.5<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">推算时间</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.5.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><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">24</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.5.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><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">24</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">6.6<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">日期与控件</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.6.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">使用数值调节钮输入日期</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">6.6.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">使用日期控件输入日期</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"></font></span></span> </p><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">第</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman">7</font></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">章</span><span lang="EN-US" style="COLOR: #993300;"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">文本处理技术</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></b></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">7.1<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">文本显示</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.1.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">单元格内文本行间距调整</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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">Word</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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.1.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">改变字母大小写</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.1.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">公式显示为字符串</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">7.2<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">文本查找</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.2.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">精确查找字符位置</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.2.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">模糊查找字符位置</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">7.3<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">文本替换</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.3.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">指定字符替换</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.3.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">指定位置和数量替换</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">7.4<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">文本截取</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.4.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">从左边截取字符串</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.4.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">从右边截取字符串</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.4.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">提取字符串中两个字符之间的字符</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.4.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">截取中间部分字符</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.4.5<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">根据换行符截取</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd; mso-outline-level: 1;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.4.6<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">从字符串中截取数字</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">7.5<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">文本组合</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.5.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">多个单元格字符批量组合</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">7.5.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">日期与字符串组合</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">7.6<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">本章小结</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">第</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman">8</font></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">章</span><span lang="EN-US" style="COLOR: #993300;"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">表格打印技术</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></b></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">8.1<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">标题行（列）打印</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.1.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">顶端标题行</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.1.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">左端标题列</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.1.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">底端标题行</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.1.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">工资条打印</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">8.2<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">设置和调整打印区域</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.2.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">插入、删除和调整分页符</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">1.<span style="mso-tab-count: 1;"> </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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">2.<span style="mso-tab-count: 1;"> </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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 63pt; mso-para-margin-left: 6.0gd;"><span lang="EN-US"><font face="Times New Roman">3.<span style="mso-tab-count: 1;"> </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"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.2.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">限定打印页数</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.2.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">分页小计</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">8.3<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">选择性打印</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.3.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">不打印图形</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.3.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">不打印指定单元格内容</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.3.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">不打印边线和指定文字（套打）</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.3.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">不打印填充颜色</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.3.5<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">不打印错误值</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">8.4<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">表格打印成卡片</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.4.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">使用控件和公式动态打印</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">8.4.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">使用邮件合并批量打印</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">8.5<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">本章小结</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">第</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman">9</font></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">章</span><span lang="EN-US" style="COLOR: #993300;"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></b><b style="mso-bidi-font-weight: normal;"><span style="COLOR: #993300; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">图表制作技术</span><span lang="EN-US" style="COLOR: #993300;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></b></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">9.1<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">制作图表</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd; mso-outline-level: 1;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">柱形图表制作</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">双坐标图表</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">工作进程图表（扇形图）</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">工作安排图表（甘特图）</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.5<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">多工作表合并图表</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.6<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">最近三天数据图表</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.1.7<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">随选取变换的动态图表</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">9.2<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">修饰图表</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.2.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">柱形图显示不同颜色</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.2.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">让平面的柱形图变得立体</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.2.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">图表区添加背景图片</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.2.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">数据点添加图片</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.2.5<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">柱形图根据条件显示不同颜色</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd; mso-outline-level: 1;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.2.6<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">制作半透明柱形图</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">9.3<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">调整图表结构</span><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman"><span style="mso-tab-count: 1;"> </span><p></p></font></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">在图表上显示单元格文本。</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">自定义数字显示格式</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">柱形图内显示数字和标志</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">跳过空数据点的显示</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.5<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">添加平均线</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">9.4<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">本章小结</span><span lang="EN-US" style="COLOR: blue;"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p></font></span></span>
liuhuanfa
发表于 2007-5-25 09:21
<span lang="EN-US"><font face="Times New Roman">9.3.1<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">在图表上显示单元格文本。</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.2<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">自定义数字显示格式</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.3<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">柱形图内显示数字和标志</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.4<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">跳过空数据点的显示</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 42pt; mso-para-margin-left: 4.0gd;"><chsdate wst="on" year="1899" day="30" islunardate="False" isrocdate="False"></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span lang="EN-US"><font face="Times New Roman">9.3.5<span style="mso-tab-count: 1;"> </span></font></span><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><chsdate></chsdate><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">添加平均线</span><span lang="EN-US"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 21pt; mso-para-margin-left: 2.0gd; mso-outline-level: 1;"><span lang="EN-US" style="COLOR: blue;"><font face="Times New Roman">9.4<span style="mso-tab-count: 1;"> </span></font></span><span style="COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">本章小结</span><span lang="EN-US" style="COLOR: blue;"><span style="mso-tab-count: 1;"><font face="Times New Roman"> </font></span></span></p>