现值51空间登录

"任务描述","操作题1:(100分)根据P28实训一资料,利用PV函数完成决策分析.
""本讲内容","项目三:复利现值计算实训项目:一次性收付款项及年金现值的计算""每题一句","参考文献""得分提醒","主要函数","PV函数.
""标题栏目","EXCEL在财务中的应用""操作题2","操作题2:(100分)根据P28实训二资料,利用PV函数完成决策分析.
""操作题3","操作题3:(100分)根据P30实训三资料,利用PV函数完成决策分析.
""操作题4","操作题4:(100分)根据P32实训四资料,利用PV函数完成决策分析.
""PV函数的应用",,,,"㈠直接输入参数","公式说明","""㈡使用引用方式输入参数""利率(Rate)","期数(Nper)","每期资金收付(Pmt)","期末终值(Fv)","每期资金收付时点(Type)","㈢计算结果","结果","公式说明""期初现值(Pv)",,"","一次收付款项""PV函数的应用""㈠直接输入参数","公式说明""68587.
1056241427","㈡使用引用方式输入参数""利率(Rate)","0.
0800000762939453""期数(Nper)","2""每期资金收付(Pmt)","期末终值(Fv)","-80000""每期资金收付时点(Type)","㈢计算结果","结果","公式说明""期初现值(Pv)","68587.
1056241427",,"一次收付款项""批阅区","扣分","25",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"PV函数的应用""㈠直接输入参数","公式说明","""㈡使用引用方式输入参数""利率(Rate)","期数(Nper)","每期资金收付(Pmt)","期末终值(Fv)","每期资金收付时点(Type)","㈢计算结果","结果","公式说明""期初现值(Pv)",,"",,"普通年金""PV函数的应用""㈠直接输入参数","公式说明""-248.
685199098422","㈡使用引用方式输入参数""利率(Rate)","0.
100000076293945""期数(Nper)","3""每期资金收付(Pmt)","100""期末终值(Fv)","每期资金收付时点(Type)","㈢计算结果","结果","公式说明""期初现值(Pv)","-248.
685199098422",,,"普通年金""批阅区","扣分","25",,,,,,,,,,,,,,,,,,,,,,,,,,,,,"PV函数的应用""㈠直接输入参数","公式说明","""㈡使用引用方式输入参数""利率(Rate)","期数(Nper)","每期资金收付(Pmt)","期末终值(Fv)","每期资金收付时点(Type)","㈢计算结果","结果","公式说明""期初现值(Pv)",,"",,"预付年金""PV函数的应用""㈠直接输入参数","公式说明""156033.
845489992","㈡使用引用方式输入参数""利率(Rate)","0.
0600000381469727""期数(Nper)","10""每期资金收付(Pmt)","-20000""期末终值(Fv)","每期资金收付时点(Type)","1""㈢计算结果","结果","公式说明""期初现值(Pv)","156033.
845489992",,,"预付年金""批阅区","扣分","30",,,,,,,,,,,,,,,,,,,,,,,,,,,,,"PV函数的应用""㈠直接输入参数","公式说明","",,"㈡使用引用方式输入参数""利率(Rate)","递延期(m)","年金期数(Nper)","总期数","每期资金收付(Pmt)","期末终值(Fv)","每期资金收付时点(Type)","㈢计算结果","结果","公式说明""期初现值(Pv)",,"",,"递延年金现值""PV函数的应用""㈠直接输入参数","公式说明""190764.
636844996",,,"㈡使用引用方式输入参数""利率(Rate)","0.
100000076293945""递延期(m)","5""年金期数(Nper)","10""总期数","15""每期资金收付(Pmt)","50000""期末终值(Fv)","每期资金收付时点(Type)","㈢计算结果","结果","公式说明""期初现值(Pv)","-190764.
636844996",,,"递延年金现值""批阅区","扣分","35",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"系统使用说明",,"一、系统用途:",,"本系统主要用于安徽商贸职业技术学院的《EXCEL在财务中的应用》课程的课堂知识点讲授及学生实训、自测、无纸化考试之用.
能实现系统自动评分.
学生一旦重新登陆,清除已有答案.
若以ADMIN身份查看,则不会不清除原有答案.
",,"二、系统运行:",,"本工具在Excel版本下正常运行,在使用本工具前,请确认您的Excel设置为允许宏运行,具体设置方法如下:","工具=>宏=>安全性=>低(允许宏运行),设置完后,请关闭Excel,然后再次打开本Excel文件.
",,,,,,,,,,,,,,,,,,"三、配套教材:","该系统推荐选用钭志斌、丁婷等编写的由高等教育出版社发行的《EXCEL在财务中的应用实训》.
",,"丁婷","2013.
1.
1",,,,"格言",,,"知识点""18","1","只因为在人群中多看了你一眼,再也没能忘掉你的容颜.
","11","1","在Excel中,复利现值的计算主要通过PV函数来完成.
","2","梦想着偶然能有一天再相见,从此我开始孤单地思念.
",,"2","复利现值是复利终值的对称概念,是指未来一定时间的特定资金按复利计算现在的价值.
","3","宁愿相信我们前世有约.
",,"3","我们可以利用PV函数快速地计算出其现值,进行财务决策.
","4","我一直在你身边,从未走远.
",,"4","PV函数为一系列未来付款的当前值的累积和.
其语法为:PV(rate,nper,pmt,fv,type).
","5","为了你,很多事我不一定会,但我在努力学.
",,"5","PV函数根据参数的不同设置,可以满足普通年金、预付年金、递延年金和一次性收付款项复利现值计算的需要.
","6","最感人的一句话:"你是我的百度.
"",,"6","普通年金现值,是指一定期间内每期期末等额的系列收付款项的现值之和.
","7","好好学习,天天向上.
",,"7","预付年金现值,是指一定时期内每期期初收付款项的复利现值之和.
","8","当我对你越来越礼貌时,我们或许就越来越陌生了.
",,"8","递延年金的现值与递延期数相关,递延的期数越长,其现值越低.
","9","当你在高处的时候,你的朋友知道你是谁;",,"9","PV函数可以用来计算一系列未来付款的当前值的累积和,即求现值.
","10","爱就是不问"值得不值得",只问"愿不愿意牺牲"",,"10","如果PV函数在公式编辑中,PV(rate,nper,pmt,fv,type),省略了pmt参数,则计算返回值为一次性收付款项的现值.
","11","爱是最珍贵的财富,这是用钱都买不到的.
",,"11","如果PV函数在公式编辑中,PV(rate,nper,pmt,fv,type),有pmt参数和fv参数,则计算返回值为pmt参数的年金现值与fv参数的现值之和.
","12","有计划,有目标的活着.
",,"12","PV函数根据参数的不同设置,可以满足普通年金、预付年金、递延年金和一次性收付款项复利现值计算的需要.
","13","很多时候,不是你喜欢就能拥有的.
",,"13","在PV函数中,如果有pmt参数,且Type为数字0,则其计算的结果为普通年金现值.
","14","趁年轻多拼搏些",,"14","在PV函数中,如果有pmt参数,且Type为数字1,则其计算的结果为预付年金现值.
","15","爱只需一点点……",,"15","在PV函数中,Type为数字0或1.
其中,0或省略代表着期末收付,为1则代表着期初收付.
","16","当你坠落的时候,你才知道你的朋友是谁.
",,"16","在PV函数中,如果省略pmt,则必须包括Fv参数.
","17","忙碌都只是借口……","18","健康、健康很重要!
","19","细心就会发现自己的粗心!
","20","幸福生活,从心开始!
","21","一个电话,一种温暖……","22","幸福的秘诀是得到自由,而自由的秘诀是勇气.
","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","如果你曾歌唱黎明,那么也请你拥抱黑夜.
""考生姓名","丁婷",,,"帮助:""考生学号","12345""班级","会计""操作题1得分合计","0",,"每错一处,扣5分.
""操作题2得分合计","0""操作题3得分合计","0""操作题4得分合计","0""设置考试时间长短:","10","分钟","教师设置""当前考试剩余时间","27","自动""剩余时间警告","3","分钟","教师设置"