计概复习材料for24医工.zip

Chensy395计概复习材料for24医工.zip 234.71KB

资源文件列表:

计概复习材料for24医工.zip 大约有6个文件

理论基础+excel部分题目/模拟练习题1-含答案.doc 188.72KB
理论基础+excel部分题目/模拟练习题2-含答案.doc 239.39KB
理论基础+excel部分题目/理论考试试卷-含答案.doc 136.24KB
计算机概论复习.pptx 198.17KB
计算机概论课后习题参考答案.docx 14.16KB
理论基础+excel部分题目/

资源介绍:

计概复习材料for24医工.zip

<link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/base.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/90150543/2/raw.css" rel="stylesheet"/><div id="sidebar" style="display: none"><div id="outline"></div></div><div class="pf w0 h0" data-page-no="1" id="pf1"><div class="pc pc1 w0 h0"><img alt="" class="bi x0 y0 w1 h1" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/90150543/bg1.jpg"/><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">模拟练习题<span class="ff2">2<span class="fs1"> </span></span></div><div class="t m0 x2 h3 y2 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y3 ff3 fs1 fc0 sc1 ls0 ws0">一、<span class="ff4"> </span>单选题<span class="ff4"> </span>（<span class="_ _0"></span>共<span class="ff4">75</span>题，<span class="ff4">97</span>分）<span class="ff4"> </span></div><div class="t m0 x2 h4 y4 ff5 fs2 fc0 sc1 ls0 ws0">1<span class="ff3">、在</span>Exce<span class="_ _0"></span>l<span class="ff3">中，进行分类<span class="_ _0"></span>汇总之前，必须<span class="_ _0"></span>对数据清单进行（<span class="_ _0"></span></span>C<span class="ff3">）（</span>1.2<span class="ff3">）<span class="_ _0"></span></span> </div><div class="t m0 x2 h3 y5 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">筛选</span> </div><div class="t m0 x2 h3 y6 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">建立数据库</span> </div><div class="t m0 x2 h3 y7 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">排序</span> </div><div class="t m0 x2 h3 y8 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">有效计算</span> </div><div class="t m0 x2 h3 y9 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h4 ya ff5 fs2 fc0 sc1 ls0 ws0">2<span class="ff3">、</span>Excel<span class="_ _0"></span><span class="ff3">分类汇总结果（<span class="_ _0"></span></span>C<span class="ff3">）（</span>1.2<span class="ff3">）<span class="_ _0"></span></span> </div><div class="t m0 x2 h3 yb ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">只能显示在数据的下方</span> </div><div class="t m0 x2 h3 yc ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">只能显示在数据的上方</span> </div><div class="t m0 x2 h3 yd ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">既可以显示在上方也可以显示在下方</span> </div><div class="t m0 x2 h3 ye ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">只能显示在所有数据的最后</span> </div><div class="t m0 x2 h3 yf ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h4 y10 ff5 fs2 fc0 sc1 ls0 ws0">3<span class="ff3">、在数据透视<span class="_ _0"></span>表中，需要对某<span class="_ _0"></span>一字段进行对比分<span class="_ _0"></span>析时，应将该字<span class="_ _0"></span>段放在哪类标签<span class="_ _0"></span>中（</span>B<span class="ff3">）</span></div><div class="t m0 x2 h4 y11 ff3 fs2 fc0 sc1 ls0 ws0">（<span class="ff5">1.2</span>）<span class="ff5"> B</span></div><div class="t m0 x2 h3 y12 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">报表筛选</span> </div><div class="t m0 x2 h3 y13 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">列标签</span> </div><div class="t m0 x2 h3 y14 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">行标签</span> </div><div class="t m0 x2 h3 y15 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">以上都不对</span> </div><div class="t m0 x2 h3 y16 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h4 y17 ff5 fs2 fc0 sc1 ls0 ws0">4<span class="ff3">、在</span>Exce<span class="_ _0"></span>l<span class="ff3">数据透视表的<span class="_ _0"></span>数据区域默认的<span class="_ _0"></span>字段汇总方式是（<span class="_ _0"></span></span>C<span class="ff3">）（</span>1.2<span class="ff3">）<span class="_ _0"></span></span> </div><div class="t m0 x2 h3 y18 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">平均值</span> </div><div class="t m0 x2 h3 y19 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">乘积</span> </div><div class="t m0 x2 h3 y1a ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">求和</span> </div><div class="t m0 x2 h3 y1b ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">最大值</span> </div><div class="t m0 x2 h3 y1c ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h4 y1d ff5 fs2 fc0 sc1 ls0 ws0">5<span class="ff3">、在</span>Exce<span class="_ _0"></span>l<span class="ff3">中可以创建嵌<span class="_ _0"></span>入式图表，创建<span class="_ _0"></span>的嵌入式图表和创<span class="_ _0"></span>建图表的数据源<span class="_ _0"></span>放置在（</span>C<span class="ff3">）工<span class="_ _0"></span>作</span></div><div class="t m0 x2 h4 y1e ff3 fs2 fc0 sc1 ls0 ws0">表中（<span class="ff5">1.2</span>）<span class="_ _0"></span><span class="ff5"> </span></div><div class="t m0 x2 h3 y1f ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">不同的</span> </div><div class="t m0 x2 h3 y20 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">相邻的</span> </div><div class="t m0 x2 h3 y21 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">同一个</span> </div><div class="t m0 x2 h3 y22 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">另一工作簿的</span> </div><div class="t m0 x2 h3 y23 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h4 y24 ff5 fs2 fc0 sc1 ls0 ws0">6<span class="ff3">、在</span>Exce<span class="_ _0"></span>l<span class="ff3">中，创建图表<span class="_ _0"></span>的数据源发生变<span class="_ _0"></span>化时，相应的图表<span class="_ _0"></span>（</span>B<span class="ff3">）（</span>1.2<span class="_ _0"></span><span class="ff3">）</span> </div><div class="t m0 x2 h3 y25 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">手动跟随变化</span> </div><div class="t m0 x2 h3 y26 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">自动跟随变化</span> </div><div class="t m0 x2 h3 y27 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">不跟随变化</span> </div><div class="t m0 x2 h3 y28 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">不受任何影响</span> </div><div class="t m0 x2 h3 y29 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h5 y2a ff5 fs2 fc0 sc1 ls0 ws0">7<span class="ff3">、在</span> <span class="ff6 fs3 fc1 sc0">Excel<span class="ff7">的图表中，能反映出同一属性数据变化趋势的图表类型是（</span>A<span class="ff7">）</span></span><span class="ff3">（</span>1.<span class="_ _0"></span>2<span class="ff3">）</span> </div><div class="t m0 x2 h3 y2b ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">折线图</span> </div><div class="t m0 x2 h3 y2c ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">柱形图</span> </div><div class="t m0 x2 h3 y2d ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">饼图</span> </div></div><div class="pi" data-data='{"ctm":[1.611830,0.000000,0.000000,1.611830,0.000000,0.000000]}'></div></div><div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/90150543/bg2.jpg"><div class="t m0 x2 h3 y2e ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">气泡图</span> </div><div class="t m0 x2 h3 y2f ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h5 y30 ff5 fs2 fc0 sc1 ls0 ws0">8<span class="ff3">、在</span> <span class="ff6 fs3 fc1 sc0">Excel<span class="ff7">的图表中，通常使用水平</span>X<span class="ff7">轴作为（</span>C<span class="ff7">）轴</span></span><span class="ff3">（</span>1.<span class="_ _0"></span>2<span class="ff3">）</span> </div><div class="t m0 x2 h3 y31 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">排序轴</span> </div><div class="t m0 x2 h3 y32 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">数值轴</span> </div><div class="t m0 x2 h3 y33 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">分类轴</span> </div><div class="t m0 x2 h3 y34 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">时间轴</span> </div><div class="t m0 x2 h3 y35 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h5 y36 ff5 fs2 fc0 sc1 ls0 ws0">9<span class="ff3">、在</span> <span class="ff6 fs3 fc1 sc0">Excel<span class="ff7">中，能够很好地通过矩形块反映每个对象中不同属性值大小的图表类型是</span></span></div><div class="t m0 x2 h5 y37 ff7 fs3 fc1 sc0 ls0 ws0">（<span class="ff6">C</span>）<span class="ff3 fs2 fc0 sc1">（<span class="ff5">1.2</span>）<span class="ff5"> </span></span></div><div class="t m0 x2 h3 y38 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">饼图</span></div><div class="t m0 x2 h3 y39 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">折线图</span> </div><div class="t m0 x2 h3 y3a ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">柱形图</span> </div><div class="t m0 x2 h3 y3b ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">散点图（</span>XY<span class="ff1">）</span> </div><div class="t m0 x2 h3 y3c ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h4 y3d ff5 fs2 fc0 sc1 ls0 ws0">10<span class="ff3">、</span>Exce<span class="_ _0"></span>l<span class="ff3">中分类汇总的<span class="_ _0"></span>默认汇总方式是<span class="_ _0"></span>（</span>A<span class="ff3">）（</span>1.2<span class="_ _0"></span><span class="ff3">）</span> </div><div class="t m0 x2 h3 y3e ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">求和</span> </div><div class="t m0 x2 h3 y3f ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">求平均值</span> </div><div class="t m0 x2 h3 y40 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">求最大值</span> </div><div class="t m0 x2 h3 y41 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">求最小值</span> </div><div class="t m0 x2 h3 y42 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h4 y43 ff5 fs2 fc0 sc1 ls0 ws0">11<span class="ff3">、显示一个<span class="_ _0"></span>整体内各部分所<span class="_ _0"></span>占的比例，往往选<span class="_ _0"></span>择（</span>D<span class="ff3">）图表<span class="_ _0"></span>（</span>1.2<span class="ff3">）</span> </div><div class="t m0 x2 h3 y44 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">折线图</span> </div><div class="t m0 x2 h3 y45 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">柱形图</span> </div><div class="t m0 x2 h3 y46 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">条形图</span> </div><div class="t m0 x2 h3 y47 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">饼图</span> </div><div class="t m0 x2 h3 y48 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h4 y49 ff5 fs2 fc0 sc1 ls0 ws0">12<span class="ff3">、在</span>Exc<span class="_ _0"></span>el<span class="ff3">中创建图表<span class="_ _0"></span>后，可以编辑的<span class="_ _0"></span>元素是（</span>D<span class="ff3">）（<span class="_ _0"></span></span>1.2<span class="ff3">）</span> </div><div class="t m0 x2 h3 y4a ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">图表标题</span> </div><div class="t m0 x2 h3 y4b ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">图例</span> </div><div class="t m0 x2 h3 y4c ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">坐标轴</span> </div><div class="t m0 x2 h3 y4d ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">以上都可以</span> </div><div class="t m0 x2 h3 y4e ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h4 y4f ff5 fs2 fc0 sc1 ls0 ws0">13<span class="ff3">、</span>Exce<span class="_ _0"></span>l<span class="ff3">默认的图表类<span class="_ _0"></span>型是（</span>A<span class="ff3">）（</span>1<span class="_ _0"></span>.2<span class="ff3">）</span> </div><div class="t m0 x2 h3 y50 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">柱形图</span> </div><div class="t m0 x2 h3 y51 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">饼图</span> </div><div class="t m0 x2 h3 y52 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">条形图</span> </div><div class="t m0 x2 h3 y53 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">折线图</span> </div><div class="t m0 x2 h3 y54 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h4 y55 ff5 fs2 fc0 sc1 ls0 ws0">14<span class="ff3">、</span>Exce<span class="_ _0"></span>l<span class="ff3">提供的图表有<span class="_ _0"></span>迷你图、嵌入式<span class="_ _0"></span>图表和（</span>A<span class="ff3">）（<span class="_ _0"></span></span>1.2<span class="ff3">）</span> </div><div class="t m0 x2 h3 y56 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">图表工作表</span> </div><div class="t m0 x2 h3 y57 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">柱形图图表</span> </div><div class="t m0 x2 h3 y58 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">条形图图表</span> </div><div class="t m0 x2 h3 y59 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">折线图图表</span> </div><div class="t m0 x2 h3 y5a ff2 fs1 fc0 sc0 ls0 ws0"> </div></div><div class="pi" data-data='{"ctm":[1.611830,0.000000,0.000000,1.611830,0.000000,0.000000]}'></div></div><div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/90150543/bg3.jpg"><div class="t m0 x2 h4 y5b ff5 fs2 fc0 sc1 ls0 ws0">15<span class="ff3">、以下关于<span class="_ _0"></span>图例的叙述中，<span class="_ _0"></span>正确的是（</span>C<span class="ff3">）<span class="_ _0"></span>（</span>1.2<span class="ff3">）</span> </div><div class="t m0 x2 h3 y5c ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">可以改变大小但是不可以改变位置</span> </div><div class="t m0 x2 h3 y2 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">可以改变位置但是不可以改变大小</span> </div><div class="t m0 x2 h3 y3 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">既可以改变位置也可以改变大小</span> </div><div class="t m0 x2 h3 y5d ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">不可以改变位置也不可以改变大小</span> </div><div class="t m0 x2 h3 y5e ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y5f ff5 fs1 fc0 sc1 ls0 ws0">16<span class="ff3">、以下属<span class="_ _0"></span>于</span>EXCEL<span class="_ _0"></span><span class="ff3">数据可视化插<span class="_ _0"></span>件的是（</span>D<span class="ff3">）</span></div><div class="t m0 x2 h3 y60 ff3 fs1 fc0 sc1 ls0 ws0">（<span class="ff5">1.2</span>）<span class="ff5"> </span></div><div class="t m0 x2 h3 y61 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> Visio Data Visualizer </div><div class="t m0 x2 h3 y62 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">三维地图</span> </div><div class="t m0 x2 h3 y63 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> People Graph </div><div class="t m0 x2 h3 y64 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">以上都是</span> </div><div class="t m0 x2 h3 y65 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y66 ff5 fs1 fc0 sc1 ls0 ws0">17<span class="ff3">、以下哪<span class="_ _0"></span>个不属于数据<span class="_ _0"></span>处理软件</span>D</div><div class="t m0 x2 h3 y67 ff3 fs1 fc0 sc1 ls0 ws0">（<span class="ff5">1.2</span>）<span class="ff5"> </span></div><div class="t m0 x2 h3 y68 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> EXCEL </div><div class="t m0 x2 h3 y69 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> SPSS </div><div class="t m0 x2 h3 y6a ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> Python</div><div class="t m0 x2 h3 y6b ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> WORD</div><div class="t m0 x2 h3 y6c ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y6d ff5 fs1 fc0 sc1 ls0 ws0">18<span class="ff3">、（</span> B<span class="_ _0"></span> <span class="ff3">）提出的<span class="_ _0"></span></span>“<span class="ff3">存储程序</span>”<span class="_ _0"></span><span class="ff3">设计思想，确<span class="_ _0"></span>立现代计算机<span class="_ _0"></span>的体系结构和<span class="_ _0"></span>工</span></div><div class="t m0 x2 h3 y6e ff3 fs1 fc0 sc1 ls0 ws0">作原理。</div><div class="t m0 x2 h3 y6f ff3 fs1 fc0 sc1 ls0 ws0">（<span class="ff5">1.2</span>）<span class="ff5"> </span></div><div class="t m0 x2 h3 y70 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">图灵</span> </div><div class="t m0 x2 h3 y71 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">冯</span>·<span class="ff1">诺依曼</span> </div><div class="t m0 x2 h3 y72 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">比尔</span>·<span class="ff1">盖茨</span> </div><div class="t m0 x2 h3 y73 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">西蒙</span>·<span class="ff1">克雷</span> </div><div class="t m0 x2 h3 y74 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y75 ff5 fs1 fc0 sc1 ls0 ws0">19<span class="ff3">、计算机<span class="_ _0"></span>系统包括（</span> <span class="_ _0"></span>D <span class="ff3">）</span></div><div class="t m0 x2 h3 y76 ff3 fs1 fc0 sc1 ls0 ws0">（<span class="ff5">1.2</span>）<span class="ff5"> </span></div><div class="t m0 x2 h3 y77 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">程序系统</span> </div><div class="t m0 x2 h3 y78 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">操作系统</span> </div><div class="t m0 x2 h3 y79 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">主机和外围设备</span> </div><div class="t m0 x2 h3 y7a ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">硬件系统和软件系统</span> </div><div class="t m0 x2 h3 y7b ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y7c ff5 fs1 fc0 sc1 ls0 ws0">20<span class="ff3">、通常所<span class="_ _0"></span>指的计算机的<span class="_ _0"></span></span>CPU<span class="ff3">芯片是<span class="_ _0"></span>指（</span> A <span class="ff3">）<span class="_ _0"></span>。</span></div><div class="t m0 x2 h3 y7d ff3 fs1 fc0 sc1 ls0 ws0">（<span class="ff5">1.2</span>）<span class="ff5"> </span></div><div class="t m0 x2 h3 y7e ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">控制器和运算器</span> </div><div class="t m0 x2 h3 y7f ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">内存储器和运算器</span> </div><div class="t m0 x2 h3 y80 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">控制器、运算器和存储器</span> </div><div class="t m0 x2 h3 y81 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">内存储器和控制器</span> </div><div class="t m0 x2 h3 y82 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y83 ff5 fs1 fc0 sc1 ls0 ws0">21<span class="ff3">、</span>EXC<span class="_ _0"></span>EL<span class="ff3">中，公式<span class="_ _0"></span>的定义必须以<span class="_ _0"></span>（</span> C <span class="ff3">）符<span class="_ _0"></span>号开头。</span></div><div class="t m0 x2 h3 y84 ff3 fs1 fc0 sc1 ls0 ws0">（<span class="ff5">1.2</span>）<span class="ff5"> </span></div><div class="t m0 x2 h3 y85 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">：</span> </div></div><div class="pi" data-data='{"ctm":[1.611830,0.000000,0.000000,1.611830,0.000000,0.000000]}'></div></div><div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/90150543/bg4.jpg"><div class="t m0 x2 h3 y2e ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">；</span></div><div class="t m0 x2 h3 y2f ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> = </div><div class="t m0 x2 h3 y86 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> *</div><div class="t m0 x2 h3 y87 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y88 ff5 fs1 fc0 sc1 ls0 ws0">22<span class="ff3">、在</span>EX<span class="_ _0"></span>CEL<span class="ff3">中，在<span class="_ _0"></span></span>A1<span class="ff3">单元格中<span class="_ _0"></span>输入公式</span>=m<span class="_ _0"></span>ax(15,<span class="_ _0"></span>“20”,1<span class="_ _0"></span>)<span class="ff3">确认后，</span>A<span class="_ _0"></span>1<span class="ff3">单元格</span></div><div class="t m0 x2 h3 y89 ff3 fs1 fc0 sc1 ls0 ws0">中的结果为（<span class="_ _0"></span><span class="ff5"> B </span>）。</div><div class="t m0 x2 h3 y8a ff3 fs1 fc0 sc1 ls0 ws0">（<span class="ff5">1.2</span>）<span class="ff5"> </span></div><div class="t m0 x2 h3 y8b ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> 15</div><div class="t m0 x2 h3 y8c ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> 20 </div><div class="t m0 x2 h3 y8d ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> 1 </div><div class="t m0 x2 h3 y8e ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> 0 </div><div class="t m0 x2 h3 y8f ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y90 ff5 fs1 fc0 sc1 ls0 ws0">23<span class="ff3">、在</span>EX<span class="_ _0"></span>CEL<span class="ff3">中，要<span class="_ _0"></span>将表格中符合<span class="_ _0"></span>某个条件的单<span class="_ _0"></span>元格的值突出<span class="_ _0"></span>显示（如用红<span class="_ _0"></span>色</span></div><div class="t m0 x2 h3 y91 ff3 fs1 fc0 sc1 ls0 ws0">显示），采用<span class="_ _0"></span>（<span class="ff5"> D </span>）命<span class="_ _0"></span>令。</div><div class="t m0 x2 h3 y92 ff3 fs1 fc0 sc1 ls0 ws0">（<span class="ff5">1.2</span>）<span class="ff5"> </span></div><div class="t m0 x2 h3 y93 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">排序</span></div><div class="t m0 x2 h3 y94 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">筛选</span> </div><div class="t m0 x2 h3 y95 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">有效性</span> </div><div class="t m0 x2 h3 y96 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">条件格式</span> </div><div class="t m0 x2 h3 y97 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y98 ff5 fs1 fc0 sc1 ls0 ws0">24<span class="ff3">、在</span>Ex<span class="_ _0"></span>cel <span class="ff3">中</span>,<span class="_ _0"></span><span class="ff3">如果在单元格<span class="_ _0"></span>输入</span>2/3<span class="ff3">，<span class="_ _0"></span>其显示的结果<span class="_ _0"></span>是（</span>A <span class="ff3">）<span class="_ _0"></span>。</span></div><div class="t m0 x2 h3 y99 ff3 fs1 fc0 sc1 ls0 ws0">（<span class="ff5">1.2</span>）<span class="ff5"> </span></div><div class="t m0 x2 h3 y9a ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff5 sc1">2<span class="ff3">月</span>3<span class="ff3">日</span></span> </div><div class="t m0 x2 h3 y9b ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> 3<span class="ff1">月</span>2<span class="ff1">日</span> </div><div class="t m0 x2 h3 y9c ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff5 sc1"> 2/3</span> </div><div class="t m0 x2 h3 y9d ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff5 sc1">3/2 </span> </div><div class="t m0 x2 h3 y9e ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y9f ff5 fs1 fc0 sc1 ls0 ws0">25<span class="ff3">、电子表<span class="_ _0"></span>格软件</span>Exc<span class="_ _0"></span>el<span class="ff3">属于计算<span class="_ _0"></span>机系统中（</span> <span class="_ _0"></span>B <span class="ff3">）。</span></div><div class="t m0 x2 h3 ya0 ff3 fs1 fc0 sc1 ls0 ws0">（<span class="ff5">1.2</span>）<span class="ff5"> </span></div><div class="t m0 x2 h3 ya1 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff1">操作系统</span></div><div class="t m0 x2 h3 ya2 ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff1">应用软件</span> </div><div class="t m0 x2 h3 ya3 ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff1">硬件系统</span> </div><div class="t m0 x2 h3 ya4 ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff1">数据库系统</span> </div><div class="t m0 x2 h3 ya5 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 ya6 ff5 fs1 fc0 sc1 ls0 ws0">26<span class="ff3">、在</span>EX<span class="_ _0"></span>CEL<span class="ff3">中，如<span class="_ _0"></span>果要直观表示<span class="_ _0"></span>三种产品的销<span class="_ _0"></span>售额占总销售<span class="_ _0"></span>额的比例情况<span class="_ _0"></span>，</span></div><div class="t m0 x2 h3 ya7 ff3 fs1 fc0 sc1 ls0 ws0">（<span class="ff5"> D </span>）图<span class="_ _0"></span>表最合适。</div><div class="t m0 x2 h3 ya8 ff3 fs1 fc0 sc1 ls0 ws0">（<span class="ff5">1.2</span>）<span class="ff5"> </span></div><div class="t m0 x2 h3 ya9 ff2 fs1 fc0 sc0 ls0 ws0">A<span class="ff1">、</span> <span class="ff5 sc1"> <span class="ff3">条形图</span></span></div><div class="t m0 x2 h3 yaa ff2 fs1 fc0 sc0 ls0 ws0">B<span class="ff1">、</span> <span class="ff5 sc1"> <span class="ff3">折线图</span> </span> </div><div class="t m0 x2 h3 yab ff2 fs1 fc0 sc0 ls0 ws0">C<span class="ff1">、</span> <span class="ff3 sc1">雷达图<span class="ff5"> </span></span> </div><div class="t m0 x2 h3 yac ff2 fs1 fc0 sc0 ls0 ws0">D<span class="ff1">、</span> <span class="ff3 sc1">饼图</span></div><div class="t m0 x2 h3 yad ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 yae ff5 fs1 fc0 sc1 ls0 ws0">27<span class="ff3">、在</span>EX<span class="_ _0"></span>CEL<span class="ff3">中，要<span class="_ _0"></span>将单元格中的<span class="_ _0"></span></span>“<span class="ff3">格式</span>”<span class="ff3">复制<span class="_ _0"></span>到其他单元格<span class="_ _0"></span>，应使用（</span> <span class="_ _0"></span>C <span class="ff3">）</span></div><div class="t m0 x2 h3 yaf ff3 fs1 fc0 sc1 ls0 ws0">操作。</div></div><div class="pi" data-data='{"ctm":[1.611830,0.000000,0.000000,1.611830,0.000000,0.000000]}'></div></div>

100+评论昵称:

captcha

四个按键控制8LED4状态.zip
四个按键控制8LED4状态.zip
行业研究
四个按键控制8LED4状态.zip 228.51KB
6 月前