计算机二级Excel函数
距离计算机二级考试还有13天,不知道大家是否已经准备好了呢?如果没有准备好,也不要着急,一点一点地复习,多熟悉一个知识点,就能多做对一道题,多得一分。上期给大家总结了WORD的考点,这期是Excel的函数总结。函数这部分不仅是考试必考的,在我们工作中也是常用的,所以学好函数是十分必要的。
1.基本函数:SUM求和函数、AVERAGE求平均函数、MAX求最大值函数、MIN求最小函数、COUNT求个数函数。
2.RANK排名函数
3.IF逻辑判断函数
4.条件求个数函数:COUNTIF单条件求个数函数、COUNTIFS多条件求个数函数
5.条件求和函数:SUMIF单条件求和函数、SUMIFS多条件求和函数、SUMPRODUCT乘积求和函数
6.查询函数:VLOOKUP查询函数、LOOKUP数组查询函数、INDEX函数、MATCH函数、INDEX和MATCH函数组成二维查询
7.文本函数:LEFT从左侧取文本函数、RIGHT从右侧取文本函数、MID从中间取文本函数、TEXT文本转化函数、FIND定位函数
8.日期函数:TODAY求当前日期函数、YEAR求年份函数、MONTH求月份函数、DAY求天数函数、DATE日期函数、DATEDIF求日期间隔函数、YEARFRAC求日期间隔函数、WEEKDAY求星期函数
9.数学函数:INT取整函数、MOD求余函数、ROUND四舍五入函数、ROUNDUP向上取值函数、ROUNDDOWN向下取整函数、SQRT开平方根函数、LARGE函数、ROW求行号函数、COLUMN求列号函数、INDIRECT函数
There are still 13 days before the computer second-level exam. I wonder if everyone is ready? If you are not ready, don’t worry, review little by little. If you are familiar with a knowledge point, you will be able to do one more right question and get one more point. Last issue I summarized the test points of WORD, and this issue is a summary of Excel functions. This part of function is not only required for exams, but also commonly used in our work, so it is very necessary to learn functions well.
Basic functions: SUM summation function, AVERAGE average function, MAX maximum function, MIN minimum function, COUNT count function. RANK ranking function IF logic judgment function Condition count function: COUNTIF single condition count function, COUNTIFS multiple condition count function Conditional summation function: SUMIF single conditional summation function, SUMIFS multi-conditional summation function, SUMPRODUCT product summation function Query function: VLOOKUP query function, LOOKUP array query function, INDEX function, MATCH function, INDEX and MATCH functions form a two-dimensional query Text function: LEFT takes the text function from the left, RIGHT takes the text function from the right, MID takes the text function from the middle, TEXT text conversion function, FIND positioning function Date functions: TODAY finds the current date function, YEAR finds the year function, MONTH finds the month function, DAY finds the number of days function, DATE date function, DATEDIF finds the date interval function, YEARFRAC finds the date interval function, WEEKDAY finds the week function Mathematical functions: INT rounding function, MOD remainder function, ROUND rounding function, ROUNDUP up value function, ROUNDDOWN rounding down function, SQRT square root function, LARGE function, ROW row number function, COLUMN column number Function, INDIRECT function volume_upcontent_copyshare
参考资料:百度百科
翻译:Google翻译
本文由LearningYard学苑原创,文中部分图片和文字均来源于网络,如有侵权请联系删除!