excel中常用函数应用举例

《excel中常用函数应用举例》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、Excel中常用函数应用举例1.求和函数SUM 求和SUM（number1，number2，...）。 使用求和函数SUM，操作步骤如下： （1）打开“员工业绩表”工作簿，选择D10单元格，如图所示。 （2）单击“插入函数”按钮，在弹出的“插入函数”对话框中选择SUM函数，单击“确定”按钮，如图所示。beconsistentwithinthesamedisk.Alternateunifiedcorerequirementsplacedontheterminalstripterminals,onlinei

2、dentityandensurethecoppercoreisnotexposed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacingisgenerally100mm;branchofficesshallbebindingonbothends,eachcore （3）在打开的“函数参数”对话框中，“Number1”文本框中默认引用D3:D9单元格区域，单击“确定”按钮，如图所示。 （4）求

3、出的和值即可显示在D10单元格中，如图所示。beconsistentwithinthesamedisk.Alternateunifiedcorerequirementsplacedontheterminalstripterminals,onlineidentityandensurethecoppercoreisnotexposed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacingisge

4、nerally100mm;branchofficesshallbebindingonbothends,eachcore2.平均值函数AVERAGE 平均值函数的原理是将所选单元格区域中的数据相加，然后除以单元格个数，返回作为结果的算术平均值，其语法结构为：AVERAGE（number1，number2，...）。 使用平均值函数AVERAGE，操作步骤如下： （1）打开“员工业绩表”工作簿，选择D11单元格，如图所示。beconsistentwithinthesamedisk.Alternateunifie

5、dcorerequirementsplacedontheterminalstripterminals,onlineidentityandensurethecoppercoreisnotexposed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacingisgenerally100mm;branchofficesshallbebindingonbothends,eachcore（2）单击“插入

6、函数”按钮，在弹出的“插入函数”对话框中选择AVERAGE函数，单击“确定”按钮，如图所示。（3）在打开的“函数参数”对话框中，在“Number1”文本框中输入D3:D9，设定计算平均值的单元格区域，单击“确定”按钮，如图所示。beconsistentwithinthesamedisk.Alternateunifiedcorerequirementsplacedontheterminalstripterminals,onlineidentityandensurethecoppercoreisnotexpos

7、ed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacingisgenerally100mm;branchofficesshallbebindingonbothends,eachcore（4）求出的平均值即显示在D11单元格中，如图所示。3.条件函数IF beconsistentwithinthesamedisk.Alternateunifiedcorerequirementsplacedon

8、theterminalstripterminals,onlineidentityandensurethecoppercoreisnotexposed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacingisgenerally100mm;branchofficesshallbebindingonbo