【正文】 Excel 2020函數(shù)應用完全手冊 目 錄 一、函數(shù)應用基礎 ......................................................................................................................................... 1 （一）函數(shù)和公式 ......................................................................................................................................... 1 ................................................................................................................................................. 1 ................................................................................................................................................. 1 （二）函數(shù)的參數(shù) ..........................................................................................................................................1 ............................................................................................................................................................. 1 ......................................................................................................................................................... 1 ............................................................................................................................................................. 1 ......................................................................................................................................................... 1 ................................................................................................................................................. 1 ..................................................................................................................................................... 2 ................................................................................................................................................. 2 （三）函數(shù)輸入方法 ..................................................................................................................................... 2 1.“插入函數(shù)” 對話框 ................................................................................................................................. 2 ................................................................................................................................................. 3 二、函數(shù)速查一覽 ..........................................................................................................................................3 (一 )數(shù)據(jù)庫函數(shù) .............................................................................................................................................. 3 ..................................................................................................................................................... 3 ......................................................................................................................................................... 3 ....................................................................................................................................................... 3 ............................................................................................................................................................. 3 ............................................................................................................................................................. 3 ............................................................................................................................................................. 3 ..................................................................................................................................................... 3 ......................................................................................................................................................... 3 ....................................................................................................................................................... 4 ........................................................................................................................................................... 4 ........................................................................................................................................................... 4 ......................................................................................................................................................... 4 ......................................................................................................................................... 4 (二 )日期與時間函數(shù) ...................................................................................................................................... 4 ............................................................................................................................................................. 4 ................................................................................................................................................. 4 ............................................................................................................................................................... 4 ....................................................................................................................................................... 5 ........................................................................................................................................................... 5 ....................................................................................................................................................... 5 ............................................................................................................................................................. 5 .......................................................