Domande su Excel
Authored by Roberto Gallardo
Computers
2nd Grade
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Quale formula viene utilizzata per sommare un intervallo di celle in Excel?
=MEDIA(A1:A10)
=SOMMA(A1:A10)
=CONTA.SE(A1:A10,">10")
=SE(A1>10, "Alto", "Basso")
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Quale funzione restituisce il valore massimo in un intervallo di celle?
=MAX(A1:A10)
=MIN(A1:A10)
=CONTA(A1:A10)
=SOMMA(A1:A10)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Quale formula permette di contare quante celle contengono valori superiori a 50?
=CONTA.SE(A1:A10,">50")
=SOMMA.SE(A1:A10,">50")
=SE(A1:A10>50,1,0)
=CONTA.VALORI(A1:A10)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Quale funzione calcola la media aritmetica di un intervallo di numeri?
=SOMMA(A1:A10)
=MEDIA(A1:A10)
=CONTA.SE(A1:A10,">0")
=SE(A1:A10>50,1,0)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Quale formula utilizzeresti per verificare se un valore in A1 è maggiore di 100 e restituire "Alto" o "Basso"?
=SE(A1>100, "Alto", "Basso")
=SE(A1100, "Alto", "Basso")
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Quale funzione restituisce il numero più piccolo in un intervallo di celle?
=SOMMA(A1:A10)
=MEDIA(A1:A10)
=MIN(A1:A10)
=MAX(A1:A10)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Quale formula permette di contare quante celle contengono numeri in un intervallo?
=CONTA.VALORI(A1:A10)
=CONTA.NUMERI(A1:A10)
=CONTA.SE(A1:A10,">0")
=MEDIA(A1:A10)
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 Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
20 questions
Thế giới bảng tính
Quiz
•
2nd Grade
21 questions
Fake News
Quiz
•
2nd Grade
16 questions
ĐỀ CƯƠNG ÔN TẬP TIN 7 GIỮA HK II
Quiz
•
2nd Grade
15 questions
Cyberbullismo
Quiz
•
1st - 12th Grade
15 questions
مراجعة ثاني متوسط الفصل الدراسي الثالث
Quiz
•
KG - 8th Grade
19 questions
COMANDOS DE WORD
Quiz
•
2nd Grade
18 questions
Arkusz kalkulacyjny
Quiz
•
1st - 8th Grade
15 questions
Spreadsheets
Quiz
•
1st - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
Discover more resources for Computers
22 questions
Equal Groups and Arrays
Quiz
•
2nd Grade
10 questions
Life Cycle of a Frog
Quiz
•
1st - 2nd Grade
10 questions
Exploring Rosa Parks and Black History Month
Interactive video
•
1st - 5th Grade
20 questions
Counting Coins
Quiz
•
2nd Grade
20 questions
Place Value
Quiz
•
KG - 3rd Grade
30 questions
DA Math Mania Bowl - Primary
Quiz
•
2nd Grade
19 questions
Subject-Verb Agreement
Quiz
•
2nd - 5th Grade
10 questions
Harriet Tubman
Quiz
•
2nd - 3rd Grade