|
回复:(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';">. </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 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';"> 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';">&</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';"><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> |
|