第1页共24页编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第1页共24页第一章成绩查询常用函数............................................................................................................21．求和函数SUM...................................................................................................................22．条件求和函数SUMIF........................................................................................................33.逻辑函数IF...........................................................................................................................34.平均值函数AVERAGE........................................................................................................45．快捷方式或链接创建函数HYPERLINK.........................................................................46．计数函数COUNT..............................................................................................................57．条件计数函数COUNTIF..................................................................................................58．最大值函数MAX、最小值函数MIN..............................................................................59排序函数RANK...................................................................................................................610.测函数ISNUMBER............................................................................................................611、ISERROR函数.................................................................................................................612、FREQUENCY函数..........................................................................................................713、INDEX函数.....................................................................................................................714、MATCH函数....................................................................................................................715、VLOOKUP函数...............................................................................................................816.RANDBETWEEN...............................................................................................................8第二章：财务函数..........................................................................................................................81.ACCRINT..............................................................................................................................82.ACCRINTM..........................................................................................................................93.AMORDEGRC......................................................................................................................94.AMORLINC..........................................................................................................................95.COUPDAYBS......................................................................................................................106.COUPDAYS........................................................................................................................107.COUPDAYSNC...................................................................................................................108.COUPNUM.............................................
