运用Excel电子表格进行货币时间价值的有关计算时,求普通年金现值用的函数是( )。
A: FV(Rate,Nper,Pmt,PV,Type)
B: PV(Rate, Nper, Pmt, FV, Type)
C: PMT (Rate,Nper,PV,FV,Type)
D: RATE(Nper, Pmt, PV, FV, Type)
A: FV(Rate,Nper,Pmt,PV,Type)
B: PV(Rate, Nper, Pmt, FV, Type)
C: PMT (Rate,Nper,PV,FV,Type)
D: RATE(Nper, Pmt, PV, FV, Type)
举一反三
- 年金函数PMT()语法形式如下。 A: PMT(rate,pv,nper,fv,type) B: PMT(rate,nper,fv,pv,type) C: PMT(pv,rate,nper,fv,type) D: PMT(rate,nper,pv,fv,type)
- 终值函数FV()语法形式如下。 A: FV(rate,nper,pmt,pv,type) B: FV(rate,nper,pv,pmt,type) C: FV(rate,pv,nper,pmt,type) D: FV(pv,rate,nper,pmt,type)
- PMT函数的语法为:() A: (rate,nper,pmt,pv,type) B: (rate,nper,pmt,fv,type) C: (rate,nper,pv,fv,type) D: (rate,nper,fv,pv,type)
- PMT函数的表达式是( )。 A: PMT(rate, nper, fv,pv, type) B: PMT(rate, per, fv,pv,type) C: PMT(rate, nper, pv,fv, type) D: PMT(rate, per,pv, fv, type)
- 年金终值函数是PV(rate,nper,pmt,fv,type)。( )(0.6)