EXCEL

Quiz
•
Mathematics, Computers
•
7th Grade - University
•
Hard
Gustavo Professor
Used 54+ times
FREE Resource
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
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
REVISÃO AVS - 1º ANO ETM

Quiz
•
10th Grade
10 questions
Quiz: Excel - funções SOMASE e SOMASES

Quiz
•
10th Grade
10 questions
Teorema de Pitágoras

Quiz
•
8th Grade
9 questions
Estudando sobre Relações métricas no Triângulo Retângulo

Quiz
•
12th Grade
15 questions
Quiz sobre Python

Quiz
•
8th Grade
13 questions
Expressões Algébricas | 7°Ano|2022

Quiz
•
7th Grade
15 questions
EXCEL 2016

Quiz
•
1st Grade - Professio...
16 questions
Excel - Nível Moderado - Lista diversa

Quiz
•
University
Popular Resources on Wayground
50 questions
Trivia 7/25

Quiz
•
12th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
11 questions
Negative Exponents

Quiz
•
7th - 8th Grade
12 questions
Exponent Expressions

Quiz
•
6th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
20 questions
One Step Equations All Operations

Quiz
•
6th - 7th Grade
18 questions
"A Quilt of a Country"

Quiz
•
9th Grade