目 錄
一、函數(shù)應(yīng)用基礎(chǔ)......................................................................................................................................... 10
（一）函數(shù)和公式......................................................................................................................................... 10
1.什么是函數(shù)................................................................................................................................................. 10
2.什么是公式................................................................................................................................................. 10
（二）函數(shù)的參數(shù)..........................................................................................................................................10
1.常量............................................................................................................................................................. 10
2.邏輯值......................................................................................................................................................... 10
3.數(shù)組............................................................................................................................................................. 10
4.錯(cuò)誤值......................................................................................................................................................... 10
5.單元格引用................................................................................................................................................. 10
6.嵌套函數(shù)..................................................................................................................................................... 10
7.名稱和標(biāo)志................................................................................................................................................. 10
（三）函數(shù)輸入方法..................................................................................................................................... 11
1.“插入函數(shù)”對(duì)話框................................................................................................................................. 11
2.編輯欄輸入................................................................................................................................................. 11
二、函數(shù)速查一覽..........................................................................................................................................11
(一)數(shù)據(jù)庫(kù)函數(shù).............................................................................................................................................. 12
(二)日期與時(shí)間函數(shù)...................................................................................................................................... 13
(三)外部函數(shù).................................................................................................................................................. 17
1.EUROCONVERT ............................................................................................................................................. 17
2.SQL.REQUEST ............................................................................................................................................. 17
(四)工程函數(shù).................................................................................................................................................. 18
(五)財(cái)務(wù)函數(shù)................................................................................................................................................ 22
(六)信息函數(shù)................................................................................................................................................ 29
(七)邏輯運(yùn)算符............................................................................................................................................ 31
(八)查找和引用函數(shù).................................................................................................................................... 32
(九)數(shù)學(xué)和三角函數(shù).................................................................................................................................... 36
(十)統(tǒng)計(jì)函數(shù)................................................................................................................................................ 45
(十一)文本和數(shù)據(jù)函數(shù)................................................................................................................................. 57
三、函數(shù)應(yīng)用案例──算賬理財(cái)....................................................................................................................... 62
1.零存整取儲(chǔ)蓄................................................................................................................................................... 62
2.還貸金額............................................................................................................................................................ 62
3.保險(xiǎn)收益............................................................................................................................................................ 63
4.個(gè)稅繳納金額.................................................................................................................................................... 63
四、函數(shù)應(yīng)用案例──信息統(tǒng)計(jì)....................................................................................................................... 64
1.性別輸入............................................................................................................................................................ 64
2.出生日期輸入.................................................................................................................................................... 64
3.職工信息查詢.................................................................................................................................................... 65
4.職工性別統(tǒng)計(jì).................................................................................................................................................... 66
5.年齡統(tǒng)計(jì)............................................................................................................................................................ 66
6.名次值統(tǒng)計(jì)........................................................................................................................................................ 66
7.位次閾值統(tǒng)計(jì).................................................................................................................................................... 67
五、函數(shù)應(yīng)用案例──管理計(jì)算....................................................................................................................... 67
1.授課日數(shù)............................................................................................................................................................ 67
2.折舊值計(jì)算........................................................................................................................................................ 67
3.客流均衡度計(jì)算................................................................................................................................................ 68
4.銷售額預(yù)測(cè)........................................................................................................................................................ 68
5.客流與營(yíng)業(yè)額的相關(guān)分析................................................................................................................................ 68