在Excel中,执行分类汇总之前必须先对汇总数据表进行()
A.筛选
B.排序
C.公式计算
D.汇总
A.=PMT(6.5%/12,8,10000)
B.=PMT(6.5%,8*12,10000)
C.=PMT(6.5%/12,8*12,10000)
D.=PMT(6.5%,8,10000)
A.=DATADIF(A1,TODAY(),"y")
B.=DATADIF(A1,TODAY(),"y")"周岁"
C.=DATADIF(A1,NOW(),"y")
D.=YEAR(TODAY())-YEAR(A1)