《第十三课创建数据表1.ppt》由会员分享,可在线阅读,更多相关《第十三课创建数据表1.ppt(49页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、第十三课创建数据表200620072009 Excel 是微软办公套装软件的一个重要的组成部分,它可以进行各种数据的处理、统计分析和辅助决策操作,广泛地应用于管理、统计财经、金融等众多领域。Excel中大量的公式函数可以应用选择,使用Microsoft Excel可以执行计算,分析信息并管理电子表格或网页中的数据信息列表,可以实现许多方便的功能,带给使用者方便。OFFICE123Microsoft Office WordMicrosoft Office WordMicrosoft Office PowerPiontMicrosoft Office PowerPiontMicrosoft Off
2、ice ExcelMicrosoft Office Excel*.doc*.doc*.doc*.doc*.ppt*.ppt*.ppt*.ppt*.xls*.xls*.xls*.xls 你能通过搜索引擎查找Word、PowerPoint 、Excel 这三款办公软件的异同以及各自适合应用在哪些方面?同时你能否用自己的言语归纳总结它们各自的特点吗?同:都是Microsoft office办公软件,都能编辑文字和图片。异:Word软件用于创建和编辑信件、报告、网页或电子邮件中的文本和图形excel软件主要用于创建和编辑表格和运算.PowerPoint软件主要用于创建和编辑用于幻灯片播映、会议和网页的
3、演示文稿。ExcelExcelExcelExcel 你能实现在你能实现在(C5:D9C5:D9)单元格中绘画小脚丫吗?单元格中绘画小脚丫吗?并将文件保存为小脚丫并将文件保存为小脚丫.xls.xls记事本 任务二:参考营养早餐工作表中的早餐选项,调查4位同学的营养早餐就餐情况,填入营养早餐统计表中,并统计热量的总和。任务三:参考总热量的标准值400-600,将营养早餐统计表中不符合热量标准的营养餐进行适当修改,并将修改处以红色标注。观察:修改早餐时,总热量的数值会自动更改吗?思考原因?在营养早餐统计表中,在姓名列前增加一个“序号”列。要求:不直接输入全部数据知识链接:参考书本56页 思考:自动填
4、充的数据还可以是哪些呢?参考57页的日积月累1 1、饭菜打多了吃不掉、饭菜打多了吃不掉 3030票票 百分比为百分比为 31.25%31.25%2 2、饭菜不合胃口,难吃、饭菜不合胃口,难吃 3939票票 百分比为百分比为 40.62%40.62%3 3、别人浪费我也浪费、别人浪费我也浪费 2 2票票 百分比为百分比为 2.08%2.08%4 4、心情不好导致没胃口、心情不好导致没胃口 8 8票票 百分比为百分比为 8.33%8.33%5 5、没有原因,就喜欢浪费、没有原因,就喜欢浪费 2 2票票 百分比为百分比为 2.08%2.08%6 6、我从来都没有浪费、我从来都没有浪费 1515票票
5、百分比为百分比为 15.64%15.64%对96位同学就餐浪费情况调查统计:任务四:在Sheet3工作表中设计出一张漂亮简洁的统计表。工作表标签为:就餐浪费统计表(起始单元格为A1)一、为数据增加标题(标题为:就餐浪费统计表)任务步骤:1、在数据上方添加一行 2、输入标题知识链接:增加行列方法:选中相应行标与列标,右击鼠标就会找到答案了哦二、尝试你熟悉的工具进行美化(如字体、颜色)1、最常用的数据处理软件:_2、相关概念:_3、我掌握的技巧:_ 你能实现在你能实现在(C5:D9C5:D9)单元格中绘画小脚丫吗?单元格中绘画小脚丫吗?并将文件保存为并将文件保存为小脚丫小脚丫.xls.xls 一、
6、为数据增加标题(标题为:就餐浪费统计表)任务步骤:1、在数据上方添加一行 2、输入标题 参考p56二、尝试你熟悉的工具进行美化(如字体、颜色)参考总热量的标准值400-600,将营养早餐统计表中不符合热量标准的营养餐进行适当修改,并将修改处以红色标注。在Sheet3工作表中设 计出一张漂亮简洁的统计表。工作表标签为:就餐浪费统计表(起始单元格为A1)在营养早餐统计表 中,在姓名列前增加一个“序号”列。要求:不直接输入全部数据知识链接:参考书本56页Contents1.Click to add title in here 1.Click to add title in here 2.Click
7、to add title in here 2.Click to add title in here 3.Click to add title in here 3.Click to add title in here 4.Click to add title in here 4.Click to add title in here 5.Click to add title in here 5.Click to add title in here 6.Click to add title in here 6.Click to add title in here Click to edit titl
8、e styleDescribe a vision of company or strategic contents.Describe a vision of company or strategic contents.Describe a vision of company or strategic contents.Describe a vision of company or strategic contents.70%50%83%90%90%65%65%75%75%50%65%65%ThemeGallery is a Design Digital Content&Contents mal
9、l developed by Guild Design Inc.Click to add TextClick to add Text Click to add TextClick to add Text Click to add TextClick to add Text Click to add TextClick to add Text Click to add TextClick to add Text Click to add TextClick to add Text Click to add TextClick to add Text Click to add TextClick
10、to add Text Click to add TextClick to add Text Click to add TextClick to add Text Click to add TextClick to add Text Click to add TextClick to add Text Click to add TextClick to add TextDescription of the contentsDescription of the contentsDescription of the contents“ThemeGallery is a Design Digital
11、 Content&Contents mall developed by Guild Design Inc.”Click to edit title styleClick to edit title styleDescription of the companys sub contentsDescription of the companys sub contentsDescription of the companys sub contentsContentTitleContentTitlefeature 01feature 0255%16%45%41%16%50%A productB pro
12、ductC product ContentsThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.Click to edit title style1 14 41.Describe contents for a Step1 -Description of the sub contents -Description of the sub contents2.Describe contents for a Step1 -Description of the sub contents
13、-Description of the sub contents3.Describe contents for a Step1 -Description of the sub contents -Description of the sub contents2 23 34.Describe contents for a Step1 -Description of the sub contents -Description of the sub contentsClick to edit title styleThemeGallery is a Design Digital Content&Co
14、ntents mall developed by Guild Design Inc.Your text in here Your text in here Your text in here02.Text in here Your text in here Your text in here03.Text in here Your text in here Your text in here Your text in here01.Text in here10%60%30%Click to add TextClick to edit title styleClick to add TextCl
15、ick to add TextClick to add TextClick to add TextClick to add TextClick to add TextClick to add TextDescription of the contents“ThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.”Description of the contentsDescription of the contents“ThemeGallery is a Design Digita
16、l Content&Contents mall developed by Guild Design Inc.”Click to edit title styleLevel 1Level 2Level 3Level 4Level 5Description of the contentsDescription of the contentsDescription of the contentsDescription of the contentsDescription of the contentsClick to edit title styleTitle in hereTitle in her
17、eTitle in hereTitle in here$40$100$25$10$45$55ThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.Text in hereText in hereText in hereCoordinate Depth in 3-D Settings.Click to edit title styleClick to edit title style Content TitleContent Title Content TitleContent T
18、itleDescription of the companys sub contentsDescription of the companys sub contents Contents Contents ContentsThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.ThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.ThemeGallery is a D
19、esign Digital Content&Contents mall developed by Guild Design Inc.20.4%20.4%Description of the companys products20.4%20.4%Description of the companys products90%90%Description of the companys products38%38%Description of the companys productsClick to edit title styleYour TextYour TextYour TextYour T
20、extClick to edit title styleYour TextYour TextYour TextYour Text2005200620072008ThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.ThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.A title about contentDescribe a vision of company
21、or strategic contents.Click to edit title style Please write down of feature for the product.featurefeaturemeritmeritnecessitynecessityPlease write down of feature for the product.Please write down of feature for the product.ContentsThemeGallery is a Design Digital Content&Contents mall developed by
22、 Guild Design Inc.Click to edit title styleClick to edit title styleClick to Click to add Textadd TextClick to Click to add Textadd TextClick to Click to add Textadd TextClick to Click to add Textadd Text-ThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.-Descripti
23、on of the contents-Description of the contents“A title about content”A title about content”CompanyL/O/G/O-Description of the contentsClick to edit title styleTextAdd Your TextAdd Your TextAdd Your TextAdd Your TextAdd Your TextAdd Your TextThemeGallery is a Design Digital Content&Contents mall devel
24、oped by Guild Design Inc.Click to edit title styleTitle in hereDescription of the contentsTitle in hereText in hereText in hereText in hereText in hereText in hereText in hereDescription of the contentsThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.Click to edit
25、 title styleThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.ContentsContentsContentsContentsClick to edit title styleContent 03Content 02Content 01 Description of the contentsThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.Des
26、cription of the contents Description of the contents Description of the contents Description of the contentsThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.Title in hereTitle in hereThemeGallery is a Design Digital Content&Contents mall developed by Guild Design
27、Inc.Title in hereTitle in hereThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.Title in hereTitle in hereThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.Click to edit title styleTitle in Title in herehereContentsContentsContent
28、sContentsThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.-Click to add Text-Click to add Text-Click to add Text-Click to add TextThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.-Click to add Text-Click to add Text-Click to add
29、 TextThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.Click to add TextClick to edit title styleClick to edit title stylev ThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.A B C DA B C D80%90%30%55%A.Description of the contentsB
30、.Description of the contentsC.Description of the contentsD.Description of the contentsText in hereText in hereText in hereText in hereDescription of the contentsDescription of the contentsDescription of the contentsDescription of the contentsDescription ofthe contentsDescription ofthe contentsText i
31、n hereText in hereTitle in Title in herehereClick to edit title style200620072005 20042003 20022001 2000 Title in hereThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.Title in hereThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc
32、.Title in hereThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.Title in hereThemeGallery is a Design Digital Content&Contents mall developed by Guild Design Inc.Click to edit title styleClick to edit title styleCEOText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in hereText in Thank You!