
Exercício Folha de Cálculo Google
Authored by Rui Queirós
Computers
9th Grade
Used 4+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Qual a formula correta a colocar na célula G8, para calcular o resultado final?
=E8xF8
=E8*E4+F8xF4
=soma(E8:F8)
=E8*E4+F8*F4
2.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Qual a formula correta a colocar na célula B15, para calcular o resultado pretendido?
=CONTAR(B5:B13)
=CONTAR(A5:A13)
=CONTAR(C5:C13)
=CONTAR(D5:D13)
3.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Qual a formula correta a colocar na célula B16, para calcular o resultado pretendido?
=CONTAR.SE(B5:B13;"F")
=CONTAR.SE(B5:B13;F)
=CONTARSE(B5:B13;"F")
=CONTARSE(B5:B13;F)
4.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Qual a formula correta a colocar na célula B17, para calcular o resultado pretendido?
=CONTAR.SE(B5:B13;"M")
=CONTAR.SE(B5:B13;M)
=CONTARSE(B5:B13;"M")
=CONTARSE(B5:B13;M)
5.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Qual a formula correta a colocar na célula B19, para calcular o resultado pretendido?
=Media(A5:A13)
=Media(F5:F13)
=Media(G5:G13)
=Media(E5:E13)
7.
FILL IN THE BLANK QUESTION
3 mins • 1 pt
Indica qual o valor devolvido pela fórmula
=Contar(D5:D13)
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
15 questions
Informatica-tec 603
Quiz
•
1st - 10th Grade
13 questions
Robótica EV3 Lego
Quiz
•
7th - 9th Grade
12 questions
Excel Basics
Quiz
•
5th - 10th Grade
10 questions
Excel
Quiz
•
7th - 11th Grade
15 questions
Blogs
Quiz
•
7th - 9th Grade
15 questions
Y9 Spreadsheets
Quiz
•
8th - 9th Grade
10 questions
Quiz Materi Excel
Quiz
•
9th - 12th Grade
10 questions
EXCEL BÁSICO
Quiz
•
9th 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
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade