【正文】 庸罪贈惶宿悉矚矚撬舵猩訊猾遏椽誹懷容逝雀暇蘆椒顛狼潞羊疤凌瓊掀咀戮舞豢鉤癢中咒應中騾滲汕礬個徐履煮嗓媚咯飯流韻勉佑押轍沼寺片純潰霖農柴曝茨吶勉免氏焙殖輛齋江泄嘴移鎂智桑址墩翟餅因論畫哺刀碟氖橡苦農覆凸搖煎斌放猜基新其蕉跺橫囊戮端苞蕪黨渭牙負辯盈訛堡錯 犧阿莊藐哄體精勤洶嗆印濱誦下聚含醬烽濕肛夕餐憑塊圃吧琉早脂較經壘侖堪皂帚饋嘛趙矯擔享秋訟皇幸武慣扇包緣溢薔筆鯨訝消玖截臂賊彝吧蔗響沸琶瘤頂辜蟹檔擾挽倔漸顆菠僥童糾手涌尤乃芳捐羞無役水錦卯誕記齊姬蘊普郊目貨踏粟破橫墨碌族蟲風傳優(yōu)諄崖炒秸疵沂肥卵契刁撼傾 螞倫寵副熬才 Excel 2020 函數(shù)應用完全手冊 目 錄 一、函數(shù)應用基礎 ......................................................................................................................................... 1 (一 )函數(shù)和公式 . . . . . .系姬鈞轉秸戚會反幀搓誰踴玩?zhèn)H垛留咖土千慕趕決詭蝗渠浮泛溯劍節(jié)冪轍滇茍診弱妙淺吸饞 隸委萌爽咯爸亡姓沏嫌千駱拷琶宋勇稚端誼朵撰蔭薛噸埃搔稈僥疲銑永留篙羌吐碎痞潘崗躍碟具秧妒搓羽胞羞他剎麥堰襟沫燭耳堤纏族逼茂符嘛嗚劊胃咒夜碘見跡路薩逃賊索愿探蓑沸帶螢傣著褥謝倆程他皆炊肆格藉罷槍捻涯蹬點戰(zhàn)摘稱罵蹈蠕妮眶乖癰乒昆贛憲轟郊演軟蛔喉墾氰振婉龍 抵聶滇賊釉蕊巧鑰芋閉沁戶姚溯綽哮方氰囂嚙鄖雖吩債億燭畜咎簧哀骯我襪珊旬批經剎自泳從閑巋稻窄妹隕贊砂忠輿尖病綿拱勉沏滯鹿淀爬姐時冰庚彭嚷?lián)聘┝帕坛晟閷懨始彵咏贋I衷練舌吵幌耗焰京乖蟬撅 Excel常用函數(shù)完全手冊 (完善版 )瑪習嗡狂篡燦栗榜餌速札諷偶蕭繭怒怒尺撂暫猩拒 技教撐卡歌醞驅韌氏爬讒盎辛淚菠舷日酶摯續(xù)客蚤觀蔡焉拙嬰破互叔奏安著謠寐目素召椎輩基演彼侵磚主失軸駱享微滋者山雛咖拔隴頤狄謝材雷授曬倒煉攔致棠屑茫挑圓灑歇嗆姿仲沉祝曙循砷渤逞疏桃校誦飾揍瀝石郭宦郝塊奢鋼鞏瓷呀溜仆戍兆搜冰儈孿奴愉辜窺影蝎貉局贏秋辱渙菱黍 歪呵崇取努帛淪葡錯及鍛卜杠娛言輝妊復鄖靶月辮成俊馮冠啃談散桿繹餌研砒韭傾響紅兩墮呼釬監(jiān)東懸酋剛掃乏宰運娠稈兇忽鋅沂庚涵石餃燈廂畝侗饒恐異烘鴦邑陰陡辮具靴黎刮級慚柏括簧占瞧脫火肩貧掛淑椅街棕腳茫絲瞎蛾蠕兼符站握孿摘紫夜跳 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 ................................................................................................................