Excel中数据筛选与排序.ppt

Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 复习 Sum (求和) Average (求平均值) 自动填充 （填充柄） 设置计算区域 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 筛选 数据 筛选 自动筛选 选择设置筛选条件 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 筛选条件 鼠标左键单击下拉箭头可选择筛选条件，从而设置筛选范围 添加筛选条件 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 退出筛选 1、“数据” → “筛选”→去掉“自动筛选”前的 √ 2、“数据” → “筛选”→ “全部显示” Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 排序 数据 排序 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 排序条件 当主关键字一致时，按次要关键字排序 当主要和次要关键字都一致时，按第三关键字排序 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 降序排序 升序排序 工具栏快速排序 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 巩固练习 打开学生成绩表.xls，用SUM函数计算出总成绩，用AVERAGE计算出平均成绩。 将总成绩进行降序排序。 筛选出平均成绩90分以上的学生。 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 总结 筛选： 数据 筛选 自动筛选 排序 数据 排序 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.