"考生姓名","2",,,"帮助:"

"考生学号","2""班级","2""操作题1得分合计","0",,"每错一处,扣5分.
""操作题2得分合计","0""操作题3得分合计","0""操作题4得分合计","0""设置考试时间长短:","30","分钟","教师设置""当前考试剩余时间","27","自动""剩余时间警告","3","分钟","教师设置",,"格言",,,"知识点""41","1","只因为在人群中多看了你一眼,再也没能忘掉你的容颜.
","19","1","年金是指等额、定期的系列收支.
","2","梦想着偶然能有一天再相见,从此我开始孤单地思念.
",,"2","在Excel中,可以利用PMT函数计算年金(含本金与利息).
","3","宁愿相信我们前世有约.
",,"3","可以利用IPMT和PPMT函数计算出每期支付金额中的利息与本金.
","4","我一直在你身边,从未走远.
",,"4","偿债基金是指为了在约定的未来一定时点清偿某笔债务或积聚一定数额的资金而必须分次等额存入的准备金.
","5","为了你,很多事我不一定会,但我在努力学.
",,"5","偿债基金的计算是根据年金的终值计算年金的,即已知终值求年金.
","6","最感人的一句话:"你是我的百度.
"",,"6","在Excel中,可以利用PMT函数计算偿债基金.
","7","好好学习,天天向上.
",,"7","PMT函数的语法格式为PMT(rate,nper,pv,fv,type).
","8","当我对你越来越礼貌时,我们或许就越来越陌生了.
",,"8","年资本回收额,是指在约定年限内等额收回初始投入资本或清偿所欠的债务.
","9","当你在高处的时候,你的朋友知道你是谁;",,"9","年资本回收额,即根据年金现值计算的年金,即已知现值求年金.
","10","爱就是不问"值得不值得",只问"愿不愿意牺牲"",,"10","PMT函数能计算等额偿还的本息;","11","爱是最珍贵的财富,这是用钱都买不到的.
",,"11","PPMT函数能计算各期支付的贷款本金;","12","有计划,有目标的活着.
",,"12","IPMT函数能计算各期支付的贷款利息.
","13","很多时候,不是你喜欢就能拥有的.
",,"13","在等额摊还的情况下,每期偿还款项中包含了利息和本金的部分,随着本金的不断偿还,各期支付的利息是不断减少的,而每期偿还的本金数额实际上是不断增加的.
","14","趁年轻多拼搏些",,"14","PPMT函数用于计算基于固定利率及等额分期付款方式,返回投资在某一给定期间内的本金偿还额.
其语法为:PPMT(rate,per,nper,pv,fv,type).
","15","爱只需一点点……",,"15","IPMT函数基于固定利率及等额分期付款方式,返回给定期数内对投资的利息偿还额.
其语法为:IPMT(rate,per,nper,pv,fv,type).
","16","当你坠落的时候,你才知道你的朋友是谁.
",,"16","PMT函数可以用于计算在固定利率及等额分期付款方式下,等额偿还的贷款本息.
","17","忙碌都只是借口……",,"17","PMT函数可以用来计算已知终值(fv)求年金或是已知现值(pv)求年金的计算.
","18","健康、健康很重要!
",,"18","PPMT函数用于计算基于固定利率及等额分期付款方式,返回投资在某一给定期间内的本金偿还额.
","19","细心就会发现自己的粗心!
",,"19","PPMT函数其语法为PPMT(rate,per,nper,pv,fv,type),其中Per参数用于计算其本金数额的期数,必须介于1到nper之间.
","20","幸福生活,从心开始!
",,"20","IPMT函数可以用于计算在固定利率及等额分期付款方式,返回给定期数内对投资的利息偿还额.
","21","一个电话,一种温暖……",,"21","在使用PMT等函数时,对于所有参数,支出的款项用负数表示,收入的款项用正数表示.
","22","幸福的秘诀是得到自由,而自由的秘诀是勇气.
",,"22",""=PPMT(10%,4,5,500,,)"公式中的表明年利率10%,贷款额为500的5年期贷款在等额还款情况下,第4年偿还的本金.
","23","一个人的激情与理想越多,越有可能幸福.
","24","一个人成为他自己了,那就是达到了幸福的顶点.
","25","幸福来源于我们自己.
","26","有质量的积累才是有意义的","27","轻重缓急,ABC分类,先做A再做B,再做C.
","28","简说:"我一直站在你的门口".
彼得说:"我不能让你冒险"","29","用心,一切皆精彩!
","30",""天道酬勤",也许你付出了不一定得到回报,但不付出一定得不到回报.
","31","落叶很在乎自己的舞姿;流星很注重那最后一刻的光芒;我们更应该珍惜我们人生的全过程.
","32","一种人,想求知而不在意他人是否认为自己有知识;一种人,不关心求知识却非常关心自己能否被他人视为有知识.
","33","对待生活中的每一天若都像生命中的最后一天去对待,人生定会更精彩.
","34","流星之所以美丽在于燃烧的过程,人生之所以美丽在于奋斗的过程.
","35","有劳不一定有获,不劳却一定不获.
","36","活在昨天的人失去过去,活在明天的人失去未来,活在今天的人拥有过去和未来.
","37","幸福没有明天,也没有昨天,它不怀念过去,也不向往未来,它只有现在.
","38","懂得如何安排昨天、今天、明天,你就懂得了把握人生.
","39","不要再对着昨天扼腕叹息,虽然它曾是前天的明天;不要再对着明天想入非非,因为它将是后天的昨天.
","40","人生共有三天:昨天、今天、明天.
昨天已经过去,明天还没到来,我们只有把握今天,珍惜今天,才能为人生增添光辉.
","41","昨天是作废的支票,明天是期货,只有今天是可使用的现金.
","42","思考是一件最辛苦的工作,这可能是为什么很少人愿意思考的原因.
","43","你若不想做,会找一个借口;你若想做,会找一个方法.
","44","希望是生命的阳光,行动是希望的翅膀.
","45","把语言刻进行动,才有机会拥抱成功.
","46","等待会使你失去今天,奋斗会使你得到明天.
暂时的失去与永恒的追求相撞击时,会闪现出人生最美丽的火花.
","47","语言是花朵,行动是果实.
","48","夕阳的无限好,在于用心灵去感受;青春的无限美,需要用行动去把握.
","49","在生活中,如果犹豫昨天,就会放弃今天,即使等待明天,后天也将一事无成.
","50","一室不扫,何以扫天下小事不为,何以成大业","51","零,只有和实数在一起才有意义;思想,只有和行动在一起才能发出光辉.
","52","并不是先有了勇气才敢于说话,而是在说话的同时培养了勇气.
","53","没有比人更高的山,没有比脚更长的路.
","54","天下事只有做不做,没有小不小.
","55","即使是不成熟的尝试,也胜于胎死腹中的策略.
","56","自古成功在尝试.
","57","人生最遗憾的不是你没有得到任何你想要的东西,而是你没有向上帝说出口.
","58","大部分人往往对已经失去的机遇捶胸顿足,却对眼前的机遇熟视无睹.
","59","拥有时不知珍惜,失去才觉珍贵.
让我们共同珍惜现在所拥有的一切.
","60","所谓没有时间,是因为没有很好地利用它.
","61","流星的美正因为短暂而永恒;落花的美正因为缥缈而美妙;骏马的美正因为潇洒而俊逸;人生的美正因为拥有而辉煌!
","62","一个懒惰的少年将来就是一褴褛的老人.
","63","安逸的暖流,能腐蚀意志的长堤;勤奋的飞瀑,能冲开智慧的闸门.
","64","使心田荒芜的是懒惰,使心田歉收的是自满,使心田毁灭的是虚伪,使心田常绿的是希望.
","65","早起的鸟儿有虫吃.
","66","做人不一定要顶天立地,但一定要堂堂正正;处世不一定要尽善尽美,但一定要问心无愧.
","67","人应如树:站着,是一道美丽的风景;倒了,是一个优质的栋梁.
","68","人,应像个"人",永远向上而又脚踏实地.
","69","在思想上大手大脚,在生活上适可而止.
","70","勿贪小便宜,以免上大当.
勿争小意气,以免失大局.
","71","一个最大的破产是绝望,最大的资产是希望.
","72","在困难面前没有退路,只有前进才有希望.
","73","没有人能令你失望,除了你自己.
","74","来不及化妆,但至少来得及微笑.
","75","懦夫把困难举在头顶,英雄把困难踩在脚下.
","76","强者征服今天,懦夫哀叹昨天,懒汉坐等明天.
","77","困难是一块顽石,对于弱者它是绊脚石,对于强者它是垫脚石.
","78","困难像弹簧,你强它就弱,你弱它就强.
","79","坚强是成功者的通行证,懦弱是失败者的墓志铭.
","80","有关国家书常读,无益身心事莫为.
","81","停止学习之日,即是开始衰老之时.
——培根","82","当你还不能对自己说今天学到了什么东西时,你就不要去睡觉.
","83",""复习"就是快速学习,在一天之内把本该一个学期学的东西学会.
","84","太阳每天从同一个地方升起,但人生不能总在同一个地方徘徊.
","85","灵魂在求知中净化,信念在事业中升腾.
","86","丰硕的知识来源于不辍地学习.
","87","每年只能收成一次,但天天都得下田.
","88","不带头脑阅读会使人变愚钝.
","89","一间没有书屋子,正如一个没有窗子的房间.
","90","花再美,也要绿叶的衬托;天再蓝,也要小鸟的修饰;海再阔,也要鱼儿的点缀;人再聪明,也要知识的充实.
","91","他人的成功可供参考但不能复制.
","92","生活对于智者永远是一首昂扬的歌,它的主旋律永远是奋斗.
","93","琴弦松驰,弹不出动听的乐曲;生活散漫,点不燃生命的火焰.
","94","只有孜孜不倦地求索,才有源源不断的收获.
","95","一幅斑斓的图画需要画家细心的点缀,一个美好的人生需要人们孜孜不倦地奋斗.
","96","青春是最优美的歌曲,只要你全身心地去吟唱.
","97","老要靠别人的鼓励才去奋斗的人不算强者;有别人的鼓励还不去奋斗的人简直就是懦夫.
","98","聪明的人用出色的拼搏妆点青春,愚蠢的人以疯狂的玩乐演绎生命.
","99","人的一生就像一篇文章,只有经过多次精心修改,才能不断完善.
","100","在圆周上,终点就是起点.
","101","人生成绩好像是清道夫,怎么做都看不出来,可是一不做就看出来.
","102","经营自己的长处等于存一笔利率最高的存款,它能使你的人生不断增值.
经营自己的短处等于贷了一笔利率最高的贷款,它会不断削弱你的人生.
","103","旅行的长度由钱包决定,旅行的宽度由目光决定,旅行的深度由心灵决定.
","104","有人帮你,是你的幸运;无人帮你,是公正的命运;没有人该为你做什么,因为生命是你自己的,你得为自己负责.
","105","可以敷衍他人,敷衍工作,敷衍一切,最终却发现:敷衍了自己.
","106","心里常存感激,不要以为一切都是理所应当的.
","107","智慧的河流,越深越无声.
","108","你要赶路,就不要带得太多;你要休息,就不要想的太多.
","109","人生,是建筑历史的一块砖瓦,是与风浪搏斗的一支浆,是耕耘大自然的一头牛,是帮助别人攀登的一道梯.
亲爱的朋友,你愿意你的人生是什么呢","110","命运是不可改变的,可以改变的只是我们对命运的态度.
","111","上帝给每个人都是24小时,给这24小时赋予价值的,是你自己.
","112","虽然我们无法改变人生,但可以改变人生观.
虽然我们无法改变环境,但我们可以改变心境.
","113","我们无法选择自己的脑袋,但可以选择自己喜欢的思想.
","114","人生重要的是选择.
","115","机遇总是钟情于准备好的人.
","116","命运就像自己的掌纹,虽然弯弯曲曲,却永远掌握在自己手中.
","117","有了机会不要放过,没有机会不要放松.
","118","诚实是一块板子,坦率是另一块板子.
这两块板子可以夹得你很直.
","119","母亲的眼睛,是我奋进的动力;母亲的皱纹,是我成长的阶梯.
","120","有四种事过去了便再不会回来:说出口的话,射出去的箭,过去了的时间,错失了的机会.
","121","我们已经征服了宇宙的外层空间,但却好像遗忘了我们自己的内心世界.
","122","报告大致分为两类:一类能赢得雷鸣般的掌声,一类能赢得雷鸣般的鼾声.
","123","像时尚一样,容易落后的是不是你的衣服,而是你的思想观念和能力.
","124","往公牛身上再使劲,也挤不出一滴奶来.
","125","令人不能自拔的除了牙齿还有爱情.
","126","发现常识的非常部分,是非常之人.
","127","既然很多人都同意生活是一本书,那么里面出现几个错别字就没有什么大惊小怪的.
","128","有时解释是不必要的,敌人不信你的解释,朋友无须你的解释.
","129","一本书不管从哪页看起,5分钟后还不能吸引你,请毫不犹豫地扔掉它.
","130","激情,这是鼓满船帆的风.
风有时会把船帆吹断;但没有风,帆船就不能航行.
","131","天空的蔚蓝是你对未来的追求,大海的茫茫是你对未来的向往;只要坚持不懈地奋斗,你终将创造美好的明天.
","132","不是山,却需要攀登的是人生;不是渊,却需要跨越的是自己.
","133","礁石因为信念坚定,所以能激起美丽的浪花;青春由于追求崇高,因此才格外绚丽多彩.
","134","人生是个圆,有的人走了一辈子也没有走出命运画出的圆圈,他就是不知道,圆上的每一个点都有一条腾飞的切线.
","135","不懈奋斗,生命才有辉煌;努力学习,思想才有灵光.
","136","在实现理想的路途中,必须排除一切干扰,特别是要看清那些美丽的诱惑.
","137","不要等每一盏灯都熄灭,才期盼光明;不要等折断了翅膀,才怀念广阔的蓝天.
","138","请注意宽容与忍让的区别,前者是平静的大海,后者是待喷的火山.
","139","世界上最大的容器叫胸怀.
","140","宽容是停泊爱心的港湾.
","141","学大海,纳百川,让自己容量无限.
","142","海的伟大是因为它能容纳千江万河;海的平凡是因为它来源于一点一滴.
","143","很多显得像朋友的人其实不是朋友,而很多是朋友的人倒不显得像朋友.
","144","像朽木最易燃烧,老马最为温驯,古书最富意趣,陈酒最为醇厚一样,老朋友是最可信赖的.
","145","友谊是我们哀伤时的缓和剂,激情的舒解剂,是我们压力的流泄口,我们灾难时的庇难所,是我们猜疑时的商议者,是我们脑子的清新剂,我们思想的散发口,也是我们沉思的锻炼和改进.
","146","有一扇窗,分开了你和我.
窗外是你,窗内是我.
在那阳光明媚的日子里,我推开窗,任凭风吹着我的头发.
这时,我看到了你那熟悉的身影.
忽然,你一转身,看到了窗内的我.
我们默默注视,不用言语也都知道,彼此在为对方送去衷诚的祝福……","147","愿每一缕春风都带去我对你的思念,每一滴夏雨都映出我的真诚,每一颗秋果都代表我与你的快乐,每一片冬雪都象征我对你的祝福.
","148","一片叶子跟毛毛虫交朋友,整棵树都要遭殃了.
","149","检验两只鸡的友谊,要等出现一条虫子的时候.
","150","真诚是交友的最高技艺,洞察力是交友的重要安全保障,宽容是培植友情的沃土.
","151","阳光能驱走严寒,友谊能化解忧愁.
","152","鲜花要用水浇灌,友谊要靠人珍惜.
","153","生命因短暂而宝贵,友谊因真诚而珍贵.
","154","花中牡丹最鲜艳,人间友情最可贵.
","155","有朋友同行是种安全,有朋友声援是种力量,有朋友忠告是种激励,有朋友惦念是种幸福.
","156","重逢的动力是真诚的离别.
","157","时间是冲淡离别的酒,却冲不淡友谊的情;距离是拉开友人的手,却拉不开关爱的心.
变了的是容颜,不变的是心境.
","158","信念值多少钱信念是不值钱的,它有时甚至只是一个善意的欺骗.
然而,你一旦坚持下去,它就会迅速升值.
","159","志当存高远,真诚写春秋.
","160","理想是一面旗帜,信念是一枚火炬.
","161","用理想作纸,用勤奋作笔,抒写壮丽的青春.
","162","有志之人立长志,无志之人长立志.
","163","坚定一个信念,成功就在眼前.
","164","野草遮不住太阳的光芒,困难挡不住勇敢者的脚步.
","165","没有礁石,就没有美丽的浪花;没有挫折,就没有壮丽的人生.
","166","平静的湖面,锻炼不出精悍的水手;安逸的生活打造不出时代的伟人.
","167","如果你曾歌唱黎明,那么也请你拥抱黑夜.
""任务描述","操作题1:(100分)根据P37实训一资料,利用PMT函数完成年偿债基金的计算.
""本讲内容","项目四:年金的计算实训项目:各期年金及各期本息的计算""每题一句","参考文献""得分提醒","主要函数","PMT,IPMT,PPMT函数.
""标题栏目","EXCEL在财务中的应用""操作题2","操作题2:(100分)根据P39实训二资料,利用PMT函数完成年资本回收额计算.
""操作题3","操作题3:(100分)根据P41同步训练4-3资料,利用PMT函数完成融资租赁租金的计算.
""操作题4","操作题4:(100分)根据P41实训三资料,利用PMT函数完成等额偿还贷款的本息计算.
""系统使用说明",,"一、系统用途:",,"本系统主要用于安徽商贸职业技术学院的《EXCEL在财务中的应用》课程的课堂知识点讲授及学生实训、自测、无纸化考试之用.
能实现系统自动评分.
学生一旦重新登陆,清除已有答案.
若以ADMIN身份查看,则不会不清除原有答案.
",,"二、系统运行:",,"本工具在Excel版本下正常运行,在使用本工具前,请确认您的Excel设置为允许宏运行,具体设置方法如下:","工具=>宏=>安全性=>低(允许宏运行),设置完后,请关闭Excel,然后再次打开本Excel文件.
",,,,,,,,,,,,,,,,,,"三、配套教材:",,"该系统推荐选用钭志斌、丁婷等编写的由高等教育出版社发行的《EXCEL在财务中的应用实训》.
",,"丁婷","2013.
1.
1",,"PMT函数的应用""㈠直接输入参数","公式说明","""㈡使用引用方式输入参数""利率(Rate)","期数(Nper)","期初现值(Pv)","期末终值(Fv)","每期资金收付时点(Type)","㈢计算结果","结果","公式说明""每期资金收付(Pmt)",,"","偿债基金的计算""PMT函数的应用""㈠直接输入参数","公式说明""30.
2114803625377","㈡使用引用方式输入参数""利率(Rate)","0.
100000076293945""期数(Nper)","3""期初现值(Pv)","期末终值(Fv)","-100""每期资金收付时点(Type)","0""㈢计算结果","结果","公式说明""每期资金收付(Pmt)","30.
2114803625377",,"偿债基金的计算""批阅区","扣分","25",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"PMT函数的应用""㈠直接输入参数","公式说明","""㈡使用引用方式输入参数""利率(Rate)","期数(Nper)","期初现值(Pv)","期末终值(Fv)","每期资金收付时点(Type)","㈢计算结果","结果","公式说明""每期资金收付(Pmt)",,"","年资本回收额""PMT函数的应用""㈠直接输入参数","公式说明""40.
2114803625377","㈡使用引用方式输入参数""利率(Rate)","0.
100000076293945""期数(Nper)","3""期初现值(Pv)","-100""期末终值(Fv)","0""每期资金收付时点(Type)","0""㈢计算结果","结果","公式说明""每期资金收付(Pmt)","40.
2114803625377",,"年资本回收额""批阅区","扣分","20""ERROR",,,,,,,,,,,,,,,,,,,,,,,,,,,,"PMT函数的应用""㈠直接输入参数","公式说明","""㈡使用引用方式输入参数""利率(Rate)","期数(Nper)","期初现值(Pv)","期末终值(Fv)","每期资金收付时点(Type)","㈢计算结果","结果","公式说明""每期资金收付(Pmt)",,"","融资租金""PMT函数的应用""㈠直接输入参数","公式说明""-23454.
8480167821","㈡使用引用方式输入参数""利率(Rate)","0.
200000152587891""期数(Nper)","8""期初现值(Pv)","90000""期末终值(Fv)","0""每期资金收付时点(Type)","1""㈢计算结果","结果","公式说明""每期资金收付(Pmt)","-19545.
7066806518",,"融资租金""批阅区","扣分","30",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"每期等额还款额中本金和利息的计算""贷款金额(元)","贷款利率(年)","期限(年)","还本付息计划表(元)""年","每年等额还款","各年偿还本金","各年支付利息""1",,,"2",,,"3",,,"4",,,"5",,,"合计",,,,,,,"累计本金和利息的计算",,,,,,,"每期等额还款额中本金和利息的计算""贷款金额(元)","500""贷款利率(年)","0.
100000076293945""期限(年)","5""还本付息计划表(元)""年","每年等额还款","各年偿还本金","各年支付利息""1","-131.
898740397373","-81.
8987403973726","-50""2","-131.
898740397373","-90.
0886144371099","-41.
8101259602627""3","-131.
898740397373","-99.
0974758808208","-32.
8012645165517""4","-131.
898740397373","-109.
007223468903","-22.
8915169284696""5","-131.
898740397373","-119.
907945815793","-11.
9907945815793""合计","-659.
493701986863","-499.
999999999999","-159.
493701986863",,,,"累计本金和利息的计算",,,,,,,"批阅区","扣分","105",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,