
Aula TICS III - Excel Fórmulas Básicas
Quiz
•
Information Technology (IT)
•
9th - 12th Grade
•
Practice Problem
•
Easy
Mac Digital
Used 1+ times
FREE Resource
Enhance your content in a minute
18 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Qual fórmula é usada para somar os valores de A1 até A10?
=MEDIA(A1:A10)
=SOMA(A1:A10)
=SE(A1:A10)
=VALOR(A1:A10)
2.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
A função =MÉDIA(B2:B6) retorna:
A soma de B2 até B6
A média aritmética dos valores de B2 até B6
O maior valor da faixa
O menor valor da faixa
3.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
O que faz a fórmula =MÍNIMO(A1:A5)?
Retorna o maior número
Soma os valores
Retorna o menor número
Conta células vazias
4.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
=MÁXIMO(D1:D4) serve para:
Mostrar o valor mínimo
Somar os valores
Mostrar o valor máximo
Contar as células preenchidas
5.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
A fórmula =SE(B2>100; "Alto"; "Baixo") mostra “Alto” se:
B2 for menor que 100
B2 for igual a 100
B2 for maior que 100
Sempre
6.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
A função =CONT.SE(A1:A10;"Sim") faz o quê?
Soma os valores
Conta quantos “Sim” existem
Retorna o maior valor
Soma apenas os “Sim”
7.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Para contar células não vazias em A1 até A10, usamos:
=SOMA(A1:A10)
=MÉDIA(A1:A10)
=CONT.VALORES(A1:A10)
=CONCATENAR(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
14 questions
tin_9_kntt_bai_12a_su_dung_ham_if
Quiz
•
9th Grade
14 questions
Microsoft Excel Quiz
Quiz
•
12th Grade
15 questions
Latihan Excel
Quiz
•
10th Grade
20 questions
ATS INFORMATIKA GENAP 2025
Quiz
•
12th Grade
20 questions
FASE E. TIK. Aplikasi Pengolah Angka
Quiz
•
10th Grade
15 questions
Conceptos Básicos de Programación
Quiz
•
12th Grade
13 questions
tin_9_kntt_bai_11a_su_dung_ham_sumif
Quiz
•
9th Grade
16 questions
2.3 Programming Data Review
Quiz
•
9th - 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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Information Technology (IT)
20 questions
El Verbo IR Practice
Quiz
•
9th Grade
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
15 questions
Main Idea and Supporting Details.
Quiz
•
4th - 11th Grade
10 questions
Theme
Quiz
•
9th Grade
20 questions
Cell Organelles
Quiz
•
10th Grade
12 questions
Exponential Growth and Decay
Quiz
•
9th Grade
