
Quiz sobre Funções de Soma e Multiplicação
Financial Education
12th Grade
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Qual é a sintaxe correta da função SOMA.SE no Google Planilhas?
=SOMA.SE(intervalo; critério; intervalo_soma)
=SOMA.SE(critério; intervalo; intervalo_soma)
=SOMA.SE(intervalo_soma; intervalo; critério)
=SOMA.SE(intervalo; intervalo_soma; critério)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Se você deseja somar todos os valores na coluna B onde a coluna A é igual a "Sim", qual fórmula você deve usar?
=SOMA.SE(B:B; "Sim"; A:A)
=SOMA.SE(A:A; "Sim"; B:B)
=SOMA.SE("Sim"; A:A; B:B)
=SOMA.SE(B:B; A:A; "Sim")
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Qual função você deve usar para calcular a média dos valores de uma lista no Google Planilhas?
=SOMA()
=MÉDIA()
=MÉDIA.SE()
=MÉDIASES()
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Qual fórmula retorna a soma dos valores em C1:C10 apenas se os valores em B1:B10 forem maiores que 100?
=SOMA.SE(B1:B10; ">100"; C1:C10)
=SOMA.SE(C1:C10; ">100"; B1:B10)
=SOMA.SE(B1:B10; C1:C10; ">100")
=SOMA.SE(">100"; B1:B10; C1:C10)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Se você deseja calcular a média dos valores em D1:D5, qual fórmula deve ser usada?
=SOMA(D1:D5)
=MÉDIA(D1:D5)
=SOMA.SE(D1:D5)
=MÉDIA.SE(D1:D5)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Qual fórmula multiplica o valor da célula A1 pelo valor da célula B1 no Google Planilhas?
=A1+B1
=A1*B1
=MULT(A1;B1)
=A1/B1
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Qual função pode ser usada para somar apenas os valores positivos em uma coluna A1:A10?
=SOMA.SE(A1:A10; ">0")
=SOMA(A1:A10)
=MÉDIA.SE(A1:A10; ">0")
=SOMA.SE(A1:A10; "<0")
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
16 questions
Atividade semana 01/04/24 - EF_LMS
Quiz
•
9th - 12th Grade
16 questions
Desenvolvendo habilidades para superar o desemprego
Quiz
•
12th Grade
15 questions
Método 50-30-20_EF _LMS
Quiz
•
9th - 12th Grade
13 questions
Imposto de Renda
Quiz
•
10th Grade - University
15 questions
Nivelamento: INSS (2° trimestre)
Quiz
•
9th Grade - University
10 questions
Matemática e Consumo
Quiz
•
1st Grade - University
12 questions
Marco Conceptual
Quiz
•
12th Grade
10 questions
Porcentagem: Descontos e Acréscimos
Quiz
•
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 Financial Education
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
15 questions
Making Inferences
Quiz
•
7th - 12th Grade
12 questions
Add and Subtract Polynomials
Quiz
•
9th - 12th Grade
7 questions
How James Brown Invented Funk
Interactive video
•
10th Grade - University
15 questions
Atomic Habits: Career Habits
Lesson
•
9th - 12th Grade
20 questions
Banking
Quiz
•
9th - 12th Grade
15 questions
Exponential Growth and Decay Word Problems Practice
Quiz
•
9th - 12th Grade
18 questions
AP Bio Insta-Review Topic 6.1*: DNA & RNA Structure
Quiz
•
9th - 12th Grade