EXCEL関数 基本的な関数

関連タイピング
-
人偏の漢字です 知らない漢字がたくさんあるかも...?
プレイ回数612短文かな30秒 -
プレイ回数326長文830打
問題文
ふりがな非表示
ふりがな表示
IF(if)
SUM(sum)
PRODUCT(product)
AVERAGE(average)
COUNT(count)
COUNTA(counta)
MAX(max)
MIN(min)
SUBTOTAL(subtotal)
INT(int)
MOD(mod)
ROUND(round)
ROUNDUP(roundup)
ROUNDDOWN(rounddown)
CEILING(ceiling)
ABS(abs)
VALUE(value)
FIXED(fixed)
RIGHT(right)
LEFT(left)
など
MID(mid)
MEDIAN(median)
MODE(mode)
RANDBETWEEN(randbetween)
INDIRECT(indirect)
SUMIFS(sumifs)
AVERAGEIFS(averageifs)
COUNTIFS(countifs)
DSUM(dsum)
DAVERAGE(daverage)
DPRODUCT(dproduct)
DCOUNT(dcount)
DCOUNTA(dcounta)
DMAX(dmax)
DMIN(dmin)
SUBSTITUTE(substitute)
FORECAST(forecast)
FIND(find)
SEARCH(search)
LEN(len)
ROW(row)
COLUMN(column)
VLOOKUP(vlookup)
HLOOKUP(hlookup)
INDEX(index)
MATCH(match)
IFERROR(iferror)
TODAY(today)
NOW(now)
YEAR(year)
MONTH(month)
DAY(day)
HOUR(hour)
MINUTE(minute)
SECOND(second)
WEEKDAY(weekday)
DATE(date)
TIME(time)
WORKDAY(workday)