EXCEL
Authored by Gustavo Professor
Mathematics, Computers
7th Grade - University
Used 54+ 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
45 sec • 1 pt
QUAL É A FÓRMULA PARA CALCULAR A MÉDIA PARA A IMAGEM ABAIXO?
=MEDIA(D3:C3)
=MEDIA(B3:C3)
=MEDIA(A3:C3)
=MEDIA(A3:B3)
2.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
QUAL A FÓRMULA DE SOMA PARA A TABELA ABAIXO?
=SOMA(A2:D2)
=SOMA(B2;C2;D2;E2)
=SOMA(B2:E2)
=SOMA(B2:D2)
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
QUAL A FÓRMULA QUE PERMITE QUE EU CALCULE QUANTIDADE CONFORME A SOLICITAÇÃO ABAIXO?
=CONT.SE(C2:C11;">=500")
=CONT.SE(C2:C11;">=50000")
=CONT.SE(C2:C11;"=5000")
=CONT.SE(C2:C11;">=5000")
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
O SIMBOLO ">" INDICA:
MAIOR QUE
DIFERENTE DE
IGUAL A
MENOR QUE
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
O SIMBOLO "<" INDICA:
MAIOR QUE
DIFERENTE DE
IGUAL A
MENOR QUE
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
QUAL FÓRMULA UTILIZAMOS PARA PESQUISAR?
MEDIA
CONT.SE
SOMA
PROCV
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A FUNÇÃO "=PROCH" PROCURA A INFORMAÇÃO NO SENTIDO:
VERTICAL
HORIZONTE
VÉRTICE
HORIZONTAL
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?
