컴활1급 실기 출제 함수 요약 설명 (영문)
컴활1급 실기 출제 함수 요약 설명 (영문)
< 날짜 / 시간 함수 >
YEAR
The year as an integer given a date serial number.
MONTH
The month as in integer given a date serial number.
TODAY
The serial number representing today's date.
WORKDAY
The serial number before or after a given number of days from a given date.
------------------------------------------
< 논리 함수 >
IF
The value based on a condition you specify.
AND
The logical AND for any number of arguments.
OR
The logical OR for any number of arguments.
------------------------------------------
< 데이터베이스 함수 >
DCOUNT
The total number of values in a column satisfying a condition.
DAVERAGE
The average of values in a column satisfying a condition.
DGET
The single value from a column satisfying a condition.
DSUM
The sum of values in a column satisfying a condition.
------------------------------------------
< 수학 / 삼각 함수 >
SUM
The total value of the numbers in a list or cell range.
ROUND
The number rounded to a specified number of digits.
SUMPRODUCT
The sum of the product of one or more arrays of values.
ROUNDUP
The number rounded up to the nearest integer.
PRODUCT
The product of all the numbers in a list or cell range.
SUMIF
The total value of the numbers that satisfies a condition.
INT
The number rounded down to the nearest integer.
------------------------------------------
< 재무 함수 >
FV
The future value of an investment over a period of time.
------------------------------------------
< 정보 함수 >
ISBLANK
The boolean value depending if the value is blank.
ISERROR
The boolean value depending if the value is an error.
------------------------------------------
< 찾기 / 참조 함수 >
VLOOKUP
The value in a column that matches a value in the first column of a table.
INDEX
The value from a table, based on an index number.
MATCH
The position of a value in an array or list.
HLOOKUP
The value in a row that matches a value in the top row of a table.
LOOKUP
The value in a row (or column) that matches a value in a column (or row).
CHOOSE
The value from a list of values, based on an index number.
------------------------------------------
< 텍스트 함수 >
LEFT
The first or left most character (or characters) in a text string.
RIGHT
The last or right most character (or characters) in a text string.
MID
The text string which is a substring of a given string.
LEN
The number of characters in a text string.
UPPER
The text string with all the characters converted to upper case.
TEXT
The text string of a number in a particular format.
VALUE
The number that a text string represents.
------------------------------------------
< 통계 함수 >
AVERAGE
The arithmetic mean of a list or array of numbers.
MAX
The largest value in a list or array of numbers.
MIN
The smallest value in a list or array of numbers.
LARGE
The Kth largest value in an array of numbers.
COUNT
The number of numeric values in a list or array of numbers.
COUNTIF
The number of non blank cells that satisfies a condition.
FREQUENCY
The number of times a value occurs in a given array or cell range.
SMALL
The Kth smallest value in an array of numbers.
MEDIAN
The median of the numbers in a list or cell range.
------------------------------------------
내 서재의 책들 자유로우니깐♡ 한사람의 꿈 첫눈 오는날 만나요 예솔맘 눈을 들어 하늘을 보라 놀이공원 쇼우 김치전쟁 소금처럼 하얗게
