CAJ | 학술논문

Excel函数库中各类函数众多,而实际办公自动化应用中,所使用到的这些函数的情况相对较少.适当使用这些函数可以比较显著的提高工作效率,同时有效降低由于人工等因素而出现的误差.本文根据学分制教务管理工作中的实际问题,以完成学生毕业成绩汇总及学分绩点统计为例,介绍了如何使用Excel的IF函数、INDIRECT函数、MATCH等函数和单元格的引用来解决问题,提高工作效率.除此之外,本文为《大学计算机基础》教学提供了一个较实用的案例.
Excel함수고중각류함수음다,이실제판공자동화응용중,소사용도적저사함수적정황상대교소.괄당사용저사함수가이비교현저적제고공작효솔,동시유효강저유우인공등인소이출현적오차.본문근거학분제교무관리공작중적실제문제,이완성학생필업성적회총급학분적점통계위례,개소료여하사용Excel적IF함수、INDIRECT함수、MATCH등함수화단원격적인용래해결문제,제고공작효솔.제차지외,본문위《대학계산궤기출》교학제공료일개교실용적안례.
Among the various Excel Functions,only a small part of which has been applied to practical office automation,i, e. OA. Appropriate use of Excel Functions will remarkably improve work efficiency and reduce manual errors. This thesis, based on the educational administration under academic credit system, takes graduation score and grade point summary practice as example. The thesis mainly introduces how to solve issues and improve work efficiency by using Excel Functions such as IF, INDIRECT, MATCH and the cell reference,etc. Meanwhile,it will be the author's great honor if it can serve as reference for academ- ic Fundamentals of Computer education.