【正文】 Excel 2003 函數(shù)應(yīng)用完全手冊 二〇〇四年二月二日目 錄 一、函數(shù)應(yīng)用基礎(chǔ)......................................................................................................................................... 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 ................................................................................................................