資源描述：
《excel中常用函數應用舉例》由會員上傳分享，免費在線閱讀，更多相關內容在工程資料-天天文庫。
1、Excel中常用函數應用舉例1.求和函數SUM?求和SUM（number1，number2，...）。?使用求和函數SUM，操作步驟如下：?（1）打開“員工業(yè)績表”工作簿，選擇D10單元格，如圖所示。?（2）單擊“插入函數”按鈕，在彈出的“插入函數”對話框中選擇SUM函數，單擊“確定”按鈕，如圖所示。beconsistentwithinthesamedisk.Alternateunifiedcorerequirementsplacedontheterminalstripterminals,onlinei
2、dentityandensurethecoppercoreisnotexposed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacingisgenerally100mm;branchofficesshallbebindingonbothends,eachcore?（3）在打開的“函數參數”對話框中，“Number1”文本框中默認引用D3:D9單元格區(qū)域，單擊“確定”按鈕，如圖所示。?（4）求
3、出的和值即可顯示在D10單元格中，如圖所示。beconsistentwithinthesamedisk.Alternateunifiedcorerequirementsplacedontheterminalstripterminals,onlineidentityandensurethecoppercoreisnotexposed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacingisge
4、nerally100mm;branchofficesshallbebindingonbothends,eachcore2.平均值函數AVERAGE?平均值函數的原理是將所選單元格區(qū)域中的數據相加，然后除以單元格個數，返回作為結果的算術平均值，其語法結構為：AVERAGE（number1，number2，...）。?使用平均值函數AVERAGE，操作步驟如下：?（1）打開“員工業(yè)績表”工作簿，選擇D11單元格，如圖所示。beconsistentwithinthesamedisk.Alternateunifie
5、dcorerequirementsplacedontheterminalstripterminals,onlineidentityandensurethecoppercoreisnotexposed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacingisgenerally100mm;branchofficesshallbebindingonbothends,eachcore（2）單擊“插入
6、函數”按鈕，在彈出的“插入函數”對話框中選擇AVERAGE函數，單擊“確定”按鈕，如圖所示。（3）在打開的“函數參數”對話框中，在“Number1”文本框中輸入D3:D9，設定計算平均值的單元格區(qū)域，單擊“確定”按鈕，如圖所示。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
