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