EXCEL関数 基本的な関数

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