【正文】 Excel 2020 函數應用完全手冊 著 二〇〇 年二月二日 目 錄 一、函數應用基 礎 ........................................................................................ ................................................. 1 （一）函數和公式 ........................................................................................ ................................................. 1 數 ........................................................................................ ......................................................... 1 式 ........................................................................................ ......................................................... 1 （二）函數的參數 ........................................................................................ ................................................. 1 量 ........................................................................................ ..................................................................... 1 值 ........................................................................................ ................................................................. 1 組 ........................................................................................ 1 ..................................................................... 1 值 ........................................................................................ ................................................................. 1 用 ........................................................................................ ......................................................... 1 數 ........................................................................................ ............................................................. 2 志 ........................................................................................ ......................................................... 2 （三）函數輸入方 法 ........................................................................................ .............................................. 2 1.“插入函數 ”對話 框 ........................................................................................ ......................................... 2 入 ........................................................................................ ......................................................... 3 二、函數速查一 覽 ........................................................................................ ................................................. 3 (一 )數據庫函 數 ........................................................................................ ....................................................... 3 ................................................................................ ..................................................................... 3 .................................................................................. ....................................................................... 3 ................................................................................. ...................................................................... 3 .................................................................................... ......................................................................... 3 .................................................................................... ......................................................................... 3 .................................................................................... ......................................................................... 3 ................................................................................ .............................................