ビジネス情報１級Excel関数
Authored by T Shibasaki
Computers
10th Grade
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 2 pts
基準値の倍数に最も近い値に切り上げるための関数。
FLOOR
ROUND
CEILING
INT
2.
MULTIPLE CHOICE QUESTION
20 sec • 2 pts
指定された数値の絶対値（０からの距離）を求める関数。
ABS
RANDBETWEEN
OFFSET
IFERROR
3.
MULTIPLE CHOICE QUESTION
20 sec • 2 pts
データベース関数で最大値を求めるもの。
DSUM
DMAX
DAVERAGE
DMIN
4.
MULTIPLE CHOICE QUESTION
20 sec • 2 pts
文字を置き換えるときに使用する関数。
ROW
MODE
OFFSET
SUBSTITUTE
5.
MULTIPLE CHOICE QUESTION
20 sec • 2 pts
データベース関数で数値データのみカウントする際に使用するもの。
DAVERAGE
DCOUNT
DCOUNTA
DSUM
6.
MULTIPLE CHOICE QUESTION
20 sec • 2 pts
回帰直線上の値を求めるための関数。
FORECAST
MODE
CEILING
COLUMN
7.
MULTIPLE CHOICE QUESTION
20 sec • 2 pts
基準値の倍数に最も近い値に切り捨てる関数。
FLOOR
CEILING
ROUNDUP
ABS
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
