《excel在会计日常工作中的应用》中的几处错误(改正一下）

cjwxxw

<span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';"><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">我买了蓝色幻想老师的《</span><span lang="EN-US"><font face="Times New Roman">excel</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">在会计日常工作中的应用》，是</span><span lang="EN-US"><font face="Times New Roman">2006</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">3</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">月第一版第一次印刷的的版本，觉得受益匪浅，特别是在函数的应用技巧方面。但在学习过程中也发现了几处错误，我想应该是校对或印刷方面的原因吧</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 10.5pt; mso-char-indent-count: 1.0;"><span lang="EN-US"><font face="Times New Roman">1</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">、</span><span lang="EN-US"><font face="Times New Roman">135</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">页图</span><span lang="EN-US"><font face="Times New Roman">5-32</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"><span style="mso-spacerun: yes;">&nbsp; </span>D12=INDIRECT(DAY(C2)-1&amp;”</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">D<chmetcnv wst="on" tcsc="0" numbertype="1" negative="False" hasspace="False" sourcevalue="13" unitname="”">13”</chmetcnv>)+D12</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">E12=INDIRECT(DAY(C2)-1&amp;”</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">D<chmetcnv wst="on" tcsc="0" numbertype="1" negative="False" hasspace="False" sourcevalue="13" unitname="”">13”</chmetcnv>)+E12</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">D13= INDIRECT(DAY(C2)-1&amp;”</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">D<chmetcnv wst="on" tcsc="0" numbertype="1" negative="False" hasspace="False" sourcevalue="13" unitname="”">13”</chmetcnv>)+D12H</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">E13=INDIRECT(DAY(C2)-1&amp;”</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">D<chmetcnv wst="on" tcsc="0" numbertype="1" negative="False" hasspace="False" sourcevalue="13" unitname="”">13”</chmetcnv>)+E12</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 10.5pt; mso-char-indent-count: 1.0;"><span lang="EN-US"><font face="Times New Roman">2</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">、在</span><span lang="EN-US"><font face="Times New Roman">145</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</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">的应用例</span><span lang="EN-US"><font face="Times New Roman">5-34</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">中，</span><font face="Times New Roman"> </font><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">（</span><font face="Times New Roman"> <span lang="EN-US">1</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"><font face="Times New Roman">OFFSET(A1,1,2)</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">应等于“</span><chmetcnv wst="on" tcsc="0" numbertype="1" negative="False" hasspace="False" sourcevalue="200" unitname="”"><span lang="EN-US"><font face="Times New Roman" style="BACKGROUND-COLOR: #ff0000;">200</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">”</span></chmetcnv><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">而不是“</span><chmetcnv wst="on" tcsc="0" numbertype="1" negative="False" hasspace="False" sourcevalue="300" unitname="”"><span lang="EN-US"><font face="Times New Roman">300</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">”</span></chmetcnv><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">C3</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">的值</span><chmetcnv wst="on" tcsc="0" numbertype="1" negative="False" hasspace="False" sourcevalue="300" unitname="”"><span lang="EN-US"><font face="Times New Roman">300</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">”</span></chmetcnv><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">C2</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">的值</span><chmetcnv wst="on" tcsc="0" numbertype="1" negative="False" hasspace="False" sourcevalue="200" unitname="”"><span lang="EN-US"><font face="Times New Roman">200</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">”</span></chmetcnv><font face="Times New Roman"> </font><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">（</span><font face="Times New Roman"> <span lang="EN-US">2</span></font><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">）</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">“</span><span lang="EN-US"><font face="Times New Roman">SUM</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(B2,,,2,2)</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">）是返回</span><span lang="EN-US"><font face="Times New Roman">SUM(B2:C2)</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">SUM</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(B2,,,2,2)</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">是返回</span><span lang="EN-US"><font face="Times New Roman">SUM(B2:C3)</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"><span style="mso-spacerun: yes;">&nbsp; </span>(3) </font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">“</span><span lang="EN-US"><font face="Times New Roman">SUM</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(B2</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">C3,1,1)</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">）等于“</span><span lang="EN-US"><font face="Times New Roman">1606</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">1006</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"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><font style="BACKGROUND-COLOR: #f70909;"></font></p></span>

hhzjxss

<p>这本书我没有，因为我不是学财务的，大概看了也没有用吧！</p>