Формулы в Excel
Computers
9th - 10th Grade
Used 32+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
А1=2; А2=3; В1=10; В2=5
B3=СУММ(A1:B2)
7
0,4
30
20
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
А1=2; А2=3; В1=10; В2=5
B3=МАКС(A1:B2)
20
7
10
2
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
А1=2; А2=3; В1=10; В2=5
B3=СРЗНАЧ(A1:B2)
5
20
7
10
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
А1=2; А2=3; В1=10; В2=5
B3=МИН(A1;B2)?
2
3
10
5
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
А1=2; А2=3; В1=10; В2=5
B3=СЧЕТЕСЛИ (A1:B2; "10")?
1
2
3
ложь
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
А1=2; А2=3; В1=10; В2=5
B3=СЧЕТ(A1:B2)
1
2
3
4
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
А1=2; А2=3; В1=10; В2=5
B3=ЕСЛИ(A1=B2; А2; В1)
2
3
10
5
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?
