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