EXCEL関数 基本的な関数

関連タイピング
-
人偏の漢字です 知らない漢字がたくさんあるかも...?
プレイ回数588短文かな30秒 -
プレイ回数316長文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)