Excel-资料汇总_Excel2003函数应用完全手册内容摘要:
函数应用完全手册 To follow the path: look to the master, follow the master, walk with the master, see through the master, become the master. qrn@Dept.Math,HIT(WH) Excel 2003 张迎新 著 二〇〇四年二月二日 1 目 录 To follow the path: look to the master, follow the master, walk with the master, see through the master, become the master. qrn@Dept.Math,HIT(WH) 一、函数应用基础.......................................................................................................................................................... 1 (一)函数和公式.................................................................................................................................................. 1 1.什么是函数.................................................................................................................................................. 1 2.什么是公式.................................................................................................................................................. 1 (二)函数的参数.................................................................................................................................................. 1 1.常量.............................................................................................................................................................. 1 2.逻辑值.......................................................................................................................................................... 1 3.数组.............................................................................................................................................................. 1 4.错误值.......................................................................................................................................................... 1 5.单元格引用.................................................................................................................................................. 1 6.嵌套函数...................................................................................................................................................... 2 7.名称和标志.................................................................................................................................................. 2 (三)函数输入方法.............................................................................................................................................. 2 1.“插入函数”对话框 .................................................................................................................................. 2 2.编辑栏输入.................................................................................................................................................. 3 二、函数速查一览.......................................................................................................................................................... 3 (一)数据库函数 ....................................................................................................................................................... 3 1.DAVERAGE...................................................................................................................................................... 3 2.DCOUNT.......................................................................................................................................................... 3 3.DCOUNTA........................................................................................................................................................ 3 4.DGET.............................................................................................................................................................. 3 5.DMAX.............................................................................................................................................................. 3 6.DMIN.............................................................................................................................................................. 3 7.DPRODUCT...................................................................................................................................................... 3 8.DSTDEV.......................................................................................................................................................... 3 9.DSTDEVP................................................................................................................................