文档文库
手机版
投诉建议
热门搜索： 心得体会 演讲稿 思想汇报
首页 > 《计算机应用基础》实训报告Excel

《计算机应用基础》实训报告Excel

发布时间：2022-12-17 12:39:06   来源：文档文库   
小 中 大
字号：
手机查看
《计算机应用基础》实训报告
目录
一.二.
A.
实训目的·············································································································2操作步骤·············································································································2
Excel工作薄操作：·········································································2
B.在工作表最左侧插入一列,输入如表格中的文字与数字,去掉sheet1中B3:E9的底纹.2C.D.
设置表头格式················································································2在D8单元格插入批注“最低”·························································3
E.将Sheet1工作表重命名为“消费水平调查”，并将此工作表复制到Sheet2工作表中3
F.将Sheet2标题和表头设置为打印标题····················································3G.利用“2006年部分城市消费水平调查”列的数据，在地区表中创建一个簇状柱形图3
三.
A.
Excel数据处理···································································································4
根据《试题汇编》4.2.2中的素材进行数据处理的操作。··························4
B.利用求和函数并使用Sheeft1工作表中的数据，计算三个月的“总计”，结果放在相应的单元格。······················································································4C.D.
统计函数COUNTA及COUNT的使用················································4利用Sheeft2工作表中的数据，以“一月”为主要关键字，升序排列。·······5
E.利用Sheeft2工作表中的数据，筛选出“二月”大于等于80000的记录。·······5F.利用Sheeft4工作表“上半年销售情况表（万元）”和“下半年销售情况表（万元）”中的数据，在“全年销售情况表（万元）”中进行“求和”合并计算。················5G.利用Sheeft5工作表中的数据，以“销售区间”为分类字段将各月销售额分别进行“求和”分类汇总。·············································································5
四.
A.
实训总结·············································································································6
实训中遇到的问题··········································································6
解决方法························································································································6
B.熟练掌握计算机操作方法，平时多看看书上的操作步骤,在闲时间多操作几遍,平时多加练习，多加思考，不懂时,问老师或同学,这样才能更加熟练快速的使用计算机。6
五.心得体会·············································································································6
1

《计算机应用基础》实训报告

一.实训目的
熟练掌握工作薄、工作表、单元格的操作以及公式的运用，图表的建立，并能对数据进行排序、筛选、合并计算、分类汇总。
二.操作步骤
A.Excel工作薄操作：
根据《试题汇编》4.1.2中的素材进行工作薄的操作。
B.在工作表最左侧插入一列,输入如表格中的文字与数字,去掉sheet1中B3:E9的底纹.
（1）打开素材4.1.2,在标题下插入一行单元格，行高为9；将表格中“合肥”一行移至“兰州”一行下方；删除“服装”右侧的空列。（2）在新的一列中输入相应的文字。
（3）选定B3:E9单元格，单击右键，再弹出的对话框中选择“设置单元格格式”，如图。打开“单元格格式”对话框，设置字体，图案，单击“确定”。
C.设置表头格式
将单元格B2:F2合并居中，字号14号，黑体,绿色；表头格式：楷体，浅黄色底纹，表中数据水平居中；表格外边框为样式中的第二列第五行,内部为样式中的第一列第三行。
2

本文来源：https://www.2haoxitong.net/k/doc/061a2e1c084c2e3f5727a5e9856a561252d32161.html

《《计算机应用基础》实训报告Excel.doc》
将本文的Word文档下载到电脑，方便收藏和打印
推荐度：
点击下载文档

文档为doc格式
相
关
案
例

相关推荐

推荐内容

大学学生宿舍管理规定 北京故宫游记作文800字 高考英语 易错词汇解析 no more than用法 三年级想象作文400字 假如变成动物,我想成为老虎 ABC英语社团简介 南阳市人民政府办公室关于印发南阳市人才公寓建设使用管理办法（试行）的通知 藏在心底的那一份感动_初中初三作文1300字 对于这次疫情保护环境优秀作文700字 光盘行动作文500字 青年志愿者协会纳新活动策划书
网站内容来自网络，如有侵权请联系我们，立即删除！ Copyright © 范文写作网京ICP备16605803号