EXCEL函数基础练习

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

花名分数求平均值公式:AVERAGE(数据区域)渝若枫92.5渝妍晨78.5平均值:渝静槐87.5渝米琪100渝思云87.5渝渔朱86.5花名分数求分数总和公式SUM(数据区域)渝若枫92.5渝妍晨78.5总和:渝静槐87.5渝米琪100渝思云87.5渝渔朱86.5工单编号会员名处理人满意度所属班级所属班组2.002E+15会员1渝雅凡满意2.002E+15会员2渝职君满意2.002E+15会员3渝迎夏满意2.002E+15会员4渝梓婷满意2.002E+15会员5渝玄清满意2.002E+15会员6渝承基满意2.002E+15会员7渝靖荷满意2.002E+15会员1渝职君满意2.002E+15会员2渝惜灵满意2.002E+15会员3渝子琪满意2.002E+15会员4渝承基满意2.002E+15会员5渝密思满意2.002E+15会员6渝秋双满意2.002E+15会员7渝康平满意2.002E+15会员1渝子琪满意2.002E+15会员2渝诗蕾满意2.002E+15会员3渝凝丝满意2.002E+15会员4渝寄容满意2.002E+15会员5渝寄容满意2.002E+15会员6渝诗蕊满意2.002E+15会员7渝白薇满意2.002E+15会员1渝雁桃满意2.002E+15会员2渝丝祺满意2.002E+15会员3渝怜双满意2.002E+15会员4渝傲菡满意2.002E+15会员5渝耘豪满意2.002E+15会员6渝怜双满意2.002E+15会员7渝芳华满意2.002E+15会员1渝惜萍满意2.002E+15会员2渝怜烟满意2.002E+15会员3渝竹筱满意2.002E+15会员4渝芳华满意会员5渝和通满意2.002E+15会员6渝朗然满意2.002E+15会员7渝昭昭满意2.002E+15会员1渝凌春满意2.002E+15会员2渝舒怀满意2.002E+15会员3渝朋义满意2.002E+15会员4渝鸿禧满意2.002E+15会员5渝冰菱满意2.002E+15会员6渝成双满意2.002E+15会员7渝璞瑜满意2.002E+15会员1渝秋双满意2.002E+15会员2渝冰菱满意会员3渝雁芙满意2.002E+15会员4渝白薇满意2.002E+15会员5渝梓婷满意2.002E+15会员6渝成双满意2.002E+15会员7渝承基满意会员1渝白薇满意2.002E+15会员2渝凡白满意2.002E+15会员3渝凝丝满意2.002E+15会员4渝白薇满意2.002E+15会员5渝惜灵满意2.002E+15会员6渝平萱满意2.002E+15会员7渝惜萍满意2.002E+15会员1渝雨雪满意2.002E+15会员2渝琳晨满意2.002E+15会员3渝子美满意2.002E+15会员4渝密思满意2.002E+15会员5渝念露满意2.002E+15会员6渝巧凡满意2.002E+15会员7渝白薇满意2.002E+15会员1渝晗蕾满意2.002E+15会员2渝雁风满意2.002E+15会员3渝高达满意2.002E+15会员4渝惠然满意2.002E+15会员5渝职君满意2.002E+15会员6渝平萱满意2.002E+15会员7渝密思满意2.002E+15会员1渝沈思满意2.002E+15会员2渝菀柳满意2.002E+15会员3渝嘉年满意2.002E+15会员4渝碧莹满意2.002E+15会员5渝雁桃满意2.002E+15会员6渝平萱满意2.002E+15会员7渝晗蕾满意2.002E+15会员1渝代芙满意2.002E+15会员2渝沈思满意2.002E+15会员3渝竹雨满意2.002E+15会员4渝思莲满意2.002E+15会员5渝雪晴满意2.002E+15会员6渝思莲满意2.002E+15会员7渝白薇满意2.002E+15会员1渝沈思满意2.002E+15会员2渝乐欣满意2.002E+15会员3渝子美满意2.002E+15会员4渝沈思满意2.002E+15会员5渝辰良满意2.002E+15会员6渝凝丝满意2.002E+15会员7渝佳悦满意2.002E+15会员1渝子美满意2.002E+15会员2渝雅逸满意2.002E+15会员3渝涵桃满意2.002E+15会员4渝凝丝满意2.002E+15会员5渝雁菱满意2.002E+15会员6渝春兰满意2.002E+15会员7渝语雪满意2.002E+15会员1渝芳华满意2.002E+15会员2渝雁菱满意2.002E+15会员3渝萧曼满意2.002E+15会员4渝语雪满意2.002E+15会员5渝巧凡满意2.002E+15会员6渝寒云满意2.002E+15会员7渝雅逸满意2.002E+15会员1渝萧曼满意2.002E+15会员2渝鸿哲满意2.002E+15会员3渝雅逸满意2.002E+15会员4渝寒云满意2.002E+15会员5渝惠然满意2.002E+15会员6渝碧莹满意2.002E+15会员7渝佳悦满意2.002E+15会员1渝琳晨满意2.002E+15会员2渝新晴满意2.002E+15会员3渝鸿哲满意2.002E+15会员4渝寒云满意2.002E+15会员5渝涵桃满意2.002E+15会员6渝怜烟满意2.002E+15会员7渝雅逸满意2.002E+15会员1渝和静满意2.002E+15会员2渝辰良满意2.002E+15会员3渝玄清满意2.002E+15会员4渝璞瑜满意2.002E+15会员5渝白薇满意2.002E+15会员6渝凝丝满意2.002E+15会员7渝雨雪满意2.002E+15会员1渝光济满意2.002E+15会员2渝迎夏满意2.002E+15会员3渝子琪满意2.002E+15会员4渝迎夏满意2.002E+15会员5渝雨雪满意2.002E+15会员6渝安莲满意2.002E+15会员7渝秋双满意2.002E+15会员1渝秀妮满意2.002E+15会员2渝令梓满意2.002E+15会员3渝凡白满意2.002E+15会员4渝高达满意2.002E+15会员5渝玄清满意会员6渝思莲满意2.002E+15会员7渝承基满意2.002E+15会员1渝寻冬满意2.002E+15会员2渝寒云满意2.002E+15会员3渝梓婷满意2.002E+15会员4渝琳晨满意2.002E+15会员5渝恬然满意2.002E+15会员6渝令梓满意2.002E+15会员7渝歆然满意2.002E+15会员1渝嘉歆满意2.002E+15会员2渝广君满意2.002E+15会员3渝寒云满意2.002E+15会员4渝寻冬满意2.002E+15会员5渝新晴满意2.002E+15会员6渝涵桃满意2.002E+15会员7渝子安满意2.002E+15会员1渝诗蕾满意2.002E+15会员2渝辰良满意2.002E+15会员3渝恬然满意2.002E+15会员4渝琳晨满意2.002E+15会员5渝涵蕾满意2.002E+15会员6渝菀柳满意2.002E+15会员7渝湘云满意2.002E+15会员1渝沈思满意2.002E+15会员2渝丹彤满意2.002E+15会员3渝向晨满意2.002E+15会员4渝世敏满意2.002E+15会员5渝昭昭满意2.002E+15会员6渝婉淑满意2.002E+15会员7渝康平满意2.002E+15会员1渝高远满意2.002E+15会员2渝诗蕾满意2.002E+15会员3渝承基满意2.002E+15会员4渝高远满意2.002E+15会员5渝广君满意2.002E+15会员6渝子安满意2.002E+15会员7渝半梅满意2.002E+15会员1渝寻冬满意2.002E+15会员2渝密思满意2.002E+15会员3渝乐安满意2.002E+15会员4渝广君满意2.002E+15会员5渝靖荷满意2.002E+15会员6渝玄清满意2.002E+15会员7渝梓婷满意2.002E+15会员1渝光济满意2.002E+15会员2渝乐安满意2.002E+15会员3渝嘉宝满意2.002E+15会员4渝密思满意2.002E+15会员5渝靖荷满意2.002E+15会员6渝靖荷满意2.002E+15会员7渝巧凡满意2.002E+15会员1渝玄清满意会员2渝语雪满意2.002E+15会员3渝寒云满意2.002E+15会员4渝雁风满意2.002E+15会员5渝向晨满意2.002E+15会员6渝寒云满意2.002E+15会员7渝婉淑满意2.002E+15会员1渝晗蕾满意2.002E+15会员2渝雅逸满意2.002E+15会员3渝鸿哲满意2.002E+15会员4渝乐欣满意2.002E+15会员5渝语雪满意2.002E+15会员6渝新晴满意2.002E+15会员7渝晗蕾满意2.002E+15会员1渝新晴满意2.002E+15会员2渝寒云满意2.002E+15会员3渝密思满意2.002E+15会员4渝涵桃满意2.002E+15会员5渝春兰满意2.002E+15会员6渝合美满意2.002E+15会员7渝博艺满意2.002E+15会员1渝广君满意2.002E+15会员2渝朋义满意2.002E+15会员3渝半梅满意会员4渝曼岚满意2.002E+15会员5渝语雪满意2.002E+15会员6渝乐安满意2.002E+15会员7渝嘉宝满意2.002E+15会员1渝梦安满意2.002E+15会员2渝冰菱满意2.002E+15会员3渝思莲满意2.002E+15会员4渝怜烟满意2.002E+15会员5渝子安满意2.002E+15会员6渝密思满意2.002E+15会员7渝辰良满意2.002E+15会员1渝竹筱满意2.002E+15会员2渝念露满意2.002E+15会员3渝职君满意2.002E+15会员4渝雁菱满意2.002E+15会员5渝又菡满意2.002E+15会员6渝诗蕊满意2.002E+15会员7渝雁菱满意会员1渝向晨满意2.002E+15会员2渝辰良满意会员3渝竹筱满意2.002E+15会员4渝凝竹满意2.002E+15会员5渝职君满意2.002E+15会员6渝诗蕊满意2.002E+15会员7渝又菡满意2.002E+15会员1渝碧莹满意2.002E+15会员2渝思云满意2.002E+15会员3渝佳悦满意2.002E+15会员4渝雁风满意2.002E+15会员5渝向晨满意2.002E+15会员6渝雁菱满意2.002E+15会员7渝小凝满意2.002E+15会员1渝和静满意2.002E+15会员2渝竹筱满意2.002E+15会员3渝丝祺满意2.002E+15会员4渝涵蕾满意2.002E+15会员5渝向晨满意2.002E+15会员6渝语雪满意2.002E+15会员7渝凝竹满意2.002E+15会员1渝沈思满意2.002E+15会员2渝世敏满意2.002E+15会员3渝春兰满意2.002E+15会员4渝舒怀满意2.002E+15会员5渝涵桃满意2.002E+15会员6渝光济满意2.002E+15会员7渝凝丝满意2.002E+15会员1渝惜灵满意2.002E+15会员2渝涵桃满意2.002E+15会员3渝半梅满意2.002E+15会员4渝雁芙满意2.002E+15会员5渝寒云满意2.002E+15会员6渝恬然满意2.002E+15会员7渝承基满意2.002E+15会员1渝妙梦满意2.002E+15会员2渝思莲满意2.002E+15会员3渝萧曼满意2.002E+15会员4渝令梓满意2.002E+15会员5渝沛柔满意2.002E+15会员6渝怜双满意2.002E+15会员7渝俊爽满意2.002E+15会员1渝令梓满意2.002E+15会员2渝诗蕊满意2.002E+15会员3渝雨琴满意2.002E+15会员4渝高远满意2.002E+15会员5渝半梅满意2.002E+15会员6渝雪珊满意2.002E+15会员7渝高远满意2.00008E+12会员1渝光济满意2.002E+15会员2渝凡白满意2.002E+15会员3渝萧曼满意会员4渝职君满意2.002E+15会员5渝晗日满意2.002E+15会员6渝密思满意2.002E+15会员7渝恬然满意2.002E+15会员1渝琳晨满意2.002E+15会员2渝嘉年满意2.002E+15会员3

1 / 116
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功