EXCEL

EXCEL

7th Grade - University

12 Qs

quiz-placeholder

Similar activities

Teorema de Pitágoras

Teorema de Pitágoras

8th Grade

10 Qs

LibreOffice Calc 2

LibreOffice Calc 2

10th Grade

15 Qs

Excel - Nível Moderado - Lista diversa

Excel - Nível Moderado - Lista diversa

University

16 Qs

Conhecimentos de Excel - Julia

Conhecimentos de Excel - Julia

University

10 Qs

Html e css

Html e css

12th Grade

16 Qs

Diagnostico Excel

Diagnostico Excel

7th Grade

17 Qs

Teste sobre Excel

Teste sobre Excel

8th Grade

16 Qs

Excel - Nível Moderado - PC

Excel - Nível Moderado - PC

University

15 Qs

EXCEL

EXCEL

Assessment

Quiz

Mathematics, Computers

7th Grade - University

Hard

Created by

Gustavo Professor

Used 54+ times

FREE Resource

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Media Image

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

Media Image

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

Media Image

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

Media Image

O SIMBOLO ">" INDICA:

MAIOR QUE

DIFERENTE DE

IGUAL A

MENOR QUE

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Media Image

O SIMBOLO "<" INDICA:

MAIOR QUE

DIFERENTE DE

IGUAL A

MENOR QUE

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

QUAL FÓRMULA UTILIZAMOS PARA PESQUISAR?

MEDIA

CONT.SE

SOMA

PROCV

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

A FUNÇÃO "=PROCH" PROCURA A INFORMAÇÃO NO SENTIDO:

VERTICAL

HORIZONTE

VÉRTICE

HORIZONTAL

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?