第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.............................................