目 錄
一、函數(shù)應用基礎......................................................................................................................................................... 1
（一）函數(shù)和公式................................................................................................................................................. 1
1.什么是函數(shù)................................................................................................................................................. 1
2.什么是公式................................................................................................................................................. 1
（二）函數(shù)的參數(shù)................................................................................................................................................. 1
1.常量............................................................................................................................................................. 1
2.邏輯值......................................................................................................................................................... 1
3.數(shù)組............................................................................................................................................................. 1
4.錯誤值......................................................................................................................................................... 1
5.單元格引用................................................................................................................................................. 1
6.嵌套函數(shù)..................................................................................................................................................... 2
7.名稱和標志................................................................................................................................................. 2
（三）函數(shù)輸入方法............................................................................................................................................. 2
1.“插入函數(shù)”對話框................................................................................................................................. 2
2.編輯欄輸入................................................................................................................................................. 3
二、函數(shù)速查一覽......................................................................................................................................................... 3
(一)數(shù)據(jù)庫函數(shù)...................................................................................................................................................... 3

(二)日期與時間函數(shù).............................................................................................................................................. 4
7
(三)外部函數(shù).......................................................................................................................................................... 7
(四)工程函數(shù).......................................................................................................................................................... 7

4.IS 類函數(shù).................................................................................................................................................. 17

(七)邏輯運算符.................................................................................................................................................... 18

(八)查找和引用函數(shù)............................................................................................................................................ 19

(九)數(shù)學和三角函數(shù)............................................................................................................................................ 21
(十)統(tǒng)計函數(shù)........................................................................................................................................................ 28
(十一)文本和數(shù)據(jù)函數(shù)........................................................................................................................................ 38
三、函數(shù)應用案例──算賬理財............................................................................................................................... 42
1.零存整取儲蓄................................................................................................................................................... 42
2.還貸金額............................................................................................................................................................ 42
3.保險收益............................................................................................................................................................ 42
4.個稅繳納金額.................................................................................................................................................... 43
四、函數(shù)應用案例──信息統(tǒng)計............................................................................................................................... 43
1.性別輸入............................................................................................................................................................ 43
2.出生日期輸入.................................................................................................................................................... 44
3.職工信息查詢.................................................................................................................................................... 44
4.職工性別統(tǒng)計.................................................................................................................................................... 45
5.年齡統(tǒng)計............................................................................................................................................................ 45
10
6.名次值統(tǒng)計........................................................................................................................................................ 45
7.位次閾值統(tǒng)計.................................................................................................................................................... 46
五、函數(shù)應用案例──管理計算............................................................................................................................... 46
1.授課日數(shù)............................................................................................................................................................ 46
2.折舊值計算........................................................................................................................................................ 46
3.客流均衡度計算................................................................................................................................................ 47
4.銷售額預測........................................................................................................................................................ 47
5.客流與營業(yè)額的相關(guān)分析................................................................................................................................ 47