Quale formula viene utilizzata per sommare un intervallo di celle in Excel?

Domande su Excel

Quiz
•
Computers
•
2nd Grade
•
Medium
Roberto Gallardo
Used 2+ times
FREE Resource
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
=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)
Create a free account and access millions of resources
Similar Resources on Quizizz
20 questions
Verifica informatica tasti periferiche e compuetr

Quiz
•
2nd - 5th Grade
18 questions
query sql

Quiz
•
2nd Grade
15 questions
G2 - W17 - Pictogram

Quiz
•
2nd Grade
15 questions
kiểm tra lớp 5

Quiz
•
1st - 12th Grade
20 questions
BÀI TẬP TIN HỌC 7

Quiz
•
1st - 10th Grade
15 questions
Hardware 01

Quiz
•
2nd Grade
18 questions
Quiz 5B Networking

Quiz
•
2nd Grade
25 questions
Test d'ingresso IV

Quiz
•
2nd Grade
Popular Resources on Quizizz
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

Quiz
•
5th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade