Excel操作练习实验报告

Excel操作练习实验 报告 软件系统测试报告下载sgs报告如何下载关于路面塌陷情况报告535n,sgs报告怎么下载竣工报告下载 学 生 实 验 报 告 课程名称 办公软件应用 实验成绩 实验项目名称 Excel操作练习 批阅教师 实验者 学号 专业班级 实验日期 一、实验预习报告,实验目的、内容～主要设备、仪器～基本原理、实验步骤等,,可加页, 实验目的: 通过练习～熟练excel的基本操作。 实验内容: 1、熟悉excel的常用工具, 2、 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 格制作, 3、表格格式设置, 4、函数的使用, 5、图表的使用。 6、所有的操作在excel工作表中进行～将实验过程在实验报告中的实验过程记录中记录 ,记录完成 方法 快递客服问题件处理详细方法山木方法pdf计算方法pdf华与华方法下载八字理论方法下载 和步骤,～并在实验过程记录中显示实验结果。 主要设备: 计算机 office2003 基本原理: Office2003中excel的基本操作 实验步骤: 1、启动Windows。 2、启动Excel:打开“开始”，指向“程序”，选择“Microsoft Excel”，单击它来启动Excel。 3、新建一个工作表，输入以下内容，并插入“编号”、“班级”两列，然后给表格加上标题、边框、表格线等，完成后在工作簿中给工作表取名为“成绩统计表”。 A B C D E F G H I 1 学生成绩统计表 2 编号 姓 名 班 级 语文 八上语文短文两篇二年级语文一匹出色的马课件部编版八上语文文学常识部编八上语文文学常识二年级语文一匹出色的马课件 数学 英语 计算机 总分 平均分 3 王国民 07数控专业 4 001 82.5 78.0 85.5 55.0 梅 丽 07数控专业 5 002 65.5 74.0 87.0 89.5 刘洋行 07数控专业 6 010 78.5 83.5 61.0 76.0 赵 凸 07数控专业 7 015 71.5 98.5 63.5 95.0 平均分 8 最高分 9 最低分 10 ? 将每行每列均设为最合适的行高列宽; ?在第5行与第6行之间插入一行，在“姓名”栏填上“郭海杰”，编号“004”，班级为07数控专业，四period of anti-Japanese war, Communist Party members such as Wang Huapeng, Chen Youqun operating from Zhejiang province came to the Tomb, widely publicized in the youth-Japanese thought. Shen Decai son Shen Bo (also known as Qing, Wei Qing), when only 13 years old, take part in activities at the outset, set up "Youth Club" book reading progress, once carried out revolutionary activities. Shen Decai does not drag, fully support the son, secretly help protect. Son watching progress not completed after the book, Shen Decai always putting books into hard wood mountain for safekeeping. In May 1941, the white terror is 科成绩分别为67，86，79，95; ?在第F列与第G列之间插入一列，依次填上“体育”，76，98，58，79，98; ?在第7行与第8行之间插入如下数据作: 021 王 英 07数控专业 67 78 89 91 77 022 刘利平 07数控专业 77 86 99 68 78 ?把工作表中的两科成绩的数据格式如下修改:语文成绩保留小数点后2位，英语成绩取消小数位; ?让成绩表中各科成绩不小于90分的成绩单元格填充色为浅蓝色，不及格的成绩单元格填充色为红色; 4、数据操作: 1.运用函数计算每位学生的总分和平均分; 2.调用函数计算每门课成绩的最高分和最低分 3.计算语文、数学、英语、计算机、体育各科成绩的全班平均分; 4.以总分为序，从高到低排序 5.将成绩统计表每位学生的各科成绩和平均分建立一张统计图表。 观察并记录每一步的操作结果。 period of anti-Japanese war, Communist Party members such as Wang Huapeng, Chen Youqun operating from Zhejiang province came to the Tomb, widely publicized in the youth-Japanese thought. Shen Decai son Shen Bo (also known as Qing, Wei Qing), when only 13 years old, take part in activities at the outset, set up "Youth Club" book reading progress, once carried out revolutionary activities. Shen Decai does not drag, fully support the son, secretly help protect. Son watching progress not completed after the book, Shen Decai always putting books into hard wood mountain for safekeeping. In May 1941, the white terror is 二、实验过程记录,包括实验过程、数据记录、实验现象等,,可加页, period of anti-Japanese war, Communist Party members such as Wang Huapeng, Chen Youqun operating from Zhejiang province came to the Tomb, widely publicized in the youth-Japanese thought. Shen Decai son Shen Bo (also known as Qing, Wei Qing), when only 13 years old, take part in activities at the outset, set up "Youth Club" book reading progress, once carried out revolutionary activities. Shen Decai does not drag, fully support the son, secretly help protect. Son watching progress not completed after the book, Shen Decai always putting books into hard wood mountain for safekeeping. In May 1941, the white terror is period of anti-Japanese war, Communist Party members such as Wang Huapeng, Chen Youqun operating from Zhejiang province came to the Tomb, widely publicized in the youth-Japanese thought. Shen Decai son Shen Bo (also known as Qing, Wei Qing), when only 13 years old, take part in activities at the outset, set up "Youth Club" book reading progress, once carried out revolutionary activities. Shen Decai does not drag, fully support the son, secretly help protect. Son watching progress not completed after the book, Shen Decai always putting books into hard wood mountain for safekeeping. In May 1941, the white terror is period of anti-Japanese war, Communist Party members such as Wang Huapeng, Chen Youqun operating from Zhejiang province came to the Tomb, widely publicized in the youth-Japanese thought. Shen Decai son Shen Bo (also known as Qing, Wei Qing), when only 13 years old, take part in activities at the outset, set up "Youth Club" book reading progress, once carried out revolutionary activities. Shen Decai does not drag, fully support the son, secretly help protect. Son watching progress not completed after the book, Shen Decai always putting books into hard wood mountain for safekeeping. In May 1941, the white terror is 三、实验结果分析,可加页, 通过这次对excel电子表格软件的学习和报告的完成～是我重新了解了这个软件的应用。虽然中学的时候接触过excel～但是现在发现还有很多自己没有学到的。这次的报告是集表格、图表和数据库三大基本结构功能于一身。我构建了直观方便的表格～输入各种所需数据～简单明朗～所有数据的输入、处理、存储、图形分析都是围着所建表格进行。 Excel中的函数运用～我觉得是最吸引人的。运用函数计算每位学生的总分和平均分～计算每门课成绩的最高分和最低分～计算语文、数学、英语、计算机、体育各科成绩的全班平均分～还可以各科成绩和平均分建立一张统计图表。这样使所有我们需要的数据一目了然。尤其是对于表格的美化～我觉得我们可以在制作表格中享受美化的过程～制作出属于我们的漂亮又简洁明了的表格。 Excel表格的功能还很广泛～不仅仅是这次报告中对学生成绩分析一种。对于我们经济管理专业的学生来说～我们需要学到的和掌握的还有很多。例如仓库库存表、股票交易表、贸易交易表等等～航班时刻表也是有必要的。在这次实验中～我感受到了办公室软件的魅力～学好办公软件对我们以后的职业生涯有很大的帮助。 period of anti-Japanese war, Communist Party members such as Wang Huapeng, Chen Youqun operating from Zhejiang province came to the Tomb, widely publicized in the youth-Japanese thought. Shen Decai son Shen Bo (also known as Qing, Wei Qing), when only 13 years old, take part in activities at the outset, set up "Youth Club" book reading progress, once carried out revolutionary activities. Shen Decai does not drag, fully support the son, secretly help protect. Son watching progress not completed after the book, Shen Decai always putting books into hard wood mountain for safekeeping. In May 1941, the white terror is period of anti-Japanese war, Communist Party members such as Wang Huapeng, Chen Youqun operating from Zhejiang province came to the Tomb, widely publicized in the youth-Japanese thought. Shen Decai son Shen Bo (also known as Qing, Wei Qing), when only 13 years old, take part in activities at the outset, set up "Youth Club" book reading progress, once carried out revolutionary activities. Shen Decai does not drag, fully support the son, secretly help protect. Son watching progress not completed after the book, Shen Decai always putting books into hard wood mountain for safekeeping. In May 1941, the white terror is