Page 184 - 压缩_Neat
P. 184
目录
任务一 工作表的基本格式设置 ····································································································134
任务二 使用样式美化工作表 ········································································································137
项目十六 数据的处理——公式与函数 ························································································141
任务一 利用公式计算总人数与占比 ····························································································141
任务二 常用函数（求和SUM、平均值AVERAGE函数）应用 ···················································144
任务三 常用函数（最大值MAX、最小值MIN）应用 ·································································145
任务四 常用函数应用 ····················································································································147
任务五 利用函数RANK对各队的总积分进行排名 ····································································149
任务六 利用函数IF对学生的身高进行备注 ················································································151
任务七 利用函数COUNTIF函数和SUMIF函数计算男生和女生人数，男生平均成绩和
女生平均成绩 ····················································································································153
项目十七 工作表中的数据库操作 ·································································································155
任务一 数据的排序和分类汇总 ····································································································155
任务二 数据筛选（自动筛选和高级筛选） ····················································································158
任务三 数据透视表 ························································································································161
项目十八 图表的创建与编辑 ··········································································································164
任务一 图表的创建 ························································································································164
任务二 添加图表标题、设置坐标轴格式 ····················································································168
项目十九 打印工作表和保护数据 ·································································································172
任务一 打印销售明细表 ················································································································172
任务二 保护库存及销售明细表数据 ····························································································175
第五章 PowerPoint 2010 ·······························································································178
项目二十 PowerPoint 2010基本操作 ························································································178
任务一 认识PowerPoint 2010 ········································································································178
任务二 制作目录页面 ····················································································································184
任务三 插入表格 ····························································································································193
任务四 插入艺术字 ························································································································198
项目二十一 幻灯片的平面设计 ······································································································201
任务一 幻灯片的背景设置。 ··········································································································201
任务二 幻灯片主题设置 ················································································································204
项目二十二 幻灯片的动态设计 ······································································································207
任务一 使用“波形”主题修饰全文，放映方式为“演讲者放映” ·············································207
任务二 幻灯片的动画设计 ············································································································211
003
