Excel精英培训网

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

[资料] [练习题]【综合1系(2期)1班】第四讲作业上交贴(10组)

[复制链接]
发表于 2008-8-6 13:29 | 显示全部楼层

<p>作业在哪下载啊?</p>
回复

使用道具 举报

发表于 2008-8-6 20:50 | 显示全部楼层
回复

使用道具 举报

发表于 2008-8-6 21:51 | 显示全部楼层

游客,如果您要查看本帖隐藏内容请回复
回复

使用道具 举报

发表于 2008-8-7 10:16 | 显示全部楼层

【综合1系(2期)1班】第四讲作业上交(10组)

游客,如果您要查看本帖隐藏内容请回复
回复

使用道具 举报

发表于 2008-8-7 11:58 | 显示全部楼层

xz
回复

使用道具 举报

发表于 2008-8-7 12:16 | 显示全部楼层

游客,如果您要查看本帖隐藏内容请回复
回复

使用道具 举报

发表于 2008-8-8 12:28 | 显示全部楼层

游客,如果您要查看本帖隐藏内容请回复
回复

使用道具 举报

发表于 2008-8-8 15:37 | 显示全部楼层

游客,如果您要查看本帖隐藏内容请回复
回复

使用道具 举报

发表于 2008-8-8 19:09 | 显示全部楼层

回复:(hzhxw5570)[练习题]【综合1系(2期)1班】第四...

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><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" style="FONT-SIZE: 12pt;"><font face="Times New Roman">excel</font></span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">处理数据的最佳格式是输入公式。</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US"><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 style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">字段相当于一个表的表头,是数据库的基本要素</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">,</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">你可以想像下成绩表</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">,</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">肯定要有姓名</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">,</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">语文</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">,</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">数学</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">,</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">总分</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">.&nbsp;&nbsp;</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">等等</span><span lang="EN-US" style="FONT-SIZE: 11pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">3</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">、</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">true=1&nbsp;&nbsp;&nbsp;fals=0<p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">4</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">、不是一回事。</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">True</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">是正确。</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">&nbsp;&nbsp;&nbsp;Fals</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">是错误。</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">5</span><span lang="EN-US"><font face="Times New Roman"> </font></span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">、运算的顺序为:</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';"> <span lang="EN-US">%</span></span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">、</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';"> <span lang="EN-US">/</span></span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">、</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">+</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">、</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">&amp;</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">、</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">&gt;</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">。</span><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 'MS Sans Serif';">6</span><span style="FONT-SIZE: 11pt; COLOR: #090000; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">、先复制</span><span lang="EN-US" style="FONT-SIZE: 12pt;"><font face="Times New Roman">exceljy</font></span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">,然后把它粘贴在最上面的空格里。把鼠标放在</span><span style="FONT-SIZE: 11pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'MS Sans Serif'; mso-hansi-font-family: 'MS Sans Serif';">单元格的右下角,当变成十字时,按住左键向下拖动,下面的单元格里就都有了</span><span lang="EN-US" style="FONT-SIZE: 12pt;"><font face="Times New Roman">exceljy</font></span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">。</span><span lang="EN-US" style="FONT-SIZE: 11pt; FONT-FAMILY: 'MS Sans Serif';"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">7</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">、</span><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">#DIV/0</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">是公式试图使用零作为除数。<span lang="EN-US"><p></p></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">#NAME?</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">公式使用了一个错误的名称。<span lang="EN-US"><p></p></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">#N/A</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">公式中引用的单元格中使用<span lang="EN-US">NA</span>函数所标识的不能使用的数据。查找函数找不到匹配数据时。<span lang="EN-US"><p></p></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">#NUM!</span><span style="FONT-SIZE: 12pt; FONT-FAMILY: 宋体; mso-font-kerning: 0pt; mso-bidi-font-family: 宋体;">与值有关的错误。<span lang="EN-US"><p></p></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">8</span><span style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体;">、<span lang="EN-US">F4</span>表示<span lang="EN-US"><p></p></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt;"><span lang="EN-US" style="FONT-SIZE: 11pt;"><font face="Times New Roman">F9</font></span><span style="FONT-SIZE: 11pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">表示强制进行计算结果检查</span><span lang="EN-US" style="FONT-SIZE: 11pt;"><p></p></span></p>
回复

使用道具 举报

发表于 2008-8-9 10:54 | 显示全部楼层

zuoye?
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-8-15 10:03 , Processed in 0.386511 second(s), 7 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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