Condicionales en Excel
10th Grade
•10 Qs
Similar activities
REVISÃO - 4º ANO - SEGURANÇA NA INTERNET 01
4th Grade - University
•15 Qs
SNT
1st - 10th Grade
•10 Qs
Educación Tecnológica
10th Grade
•13 Qs
Problemas de Mecanismos: palanca, rueda y sistemas transmisión
9th - 12th Grade
•10 Qs
Ley de Ohm
1st - 12th Grade
•10 Qs
Redes
10th Grade
•14 Qs
impianto idrico sanitario
8th - 10th Grade
•14 Qs
Etapa 3 IAR
10th Grade
•10 Qs
Condicionales en Excel
Quiz
•
Instructional Technology
•
10th Grade
•
Practice Problem
•
Hard
Silvia Villa
Used 24+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
En base a la tabla que se muestra en la imagen calcular:
¿Cuánto suma el Sueldo Básico de los contratados?
=SUMAR.SI(F5:F14;"contratado";G5:G14)
=SUMAR(F5:F14;"contratado")
=CONTAR.SI(F5:F14;"contratado";G5:G14)
=SUMAR.SI(F5:F14;"contratado")
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cuánto es el Promedio del SUELDO BÁSICO de los contratados?
=SUMAR.SI(F5:F14;"contratado";G5:G14)
=PROMEDIO.SI(F5:F14;"contratado";G5:G14)
=PROMEDIO.SI(F5:F14;"contratado")
=CONTAR.SI(F5:F14;"contratado";G5:G14)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cuántas personas tienen más de 19 años de servicio?
=CONTAR.SI(E5:E14;"<19")
=CONTAR.SI(E5:E14;" MÁS 19")
=CONTAR.SI(E5:E14;">19")
=CONTAR.SI(E5:E14;">19"; H5:H14)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cuántas películas tienen un costo de 1?
=SUMAR.SI(E3:E17; 1)
=CONTAR.SI(E3:E17; "1"; F3:F17)
=CONTAR(E3:E17; 1)
=CONTAR.SI(E3:E17; 1)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Calcular el PROMEDIO del alquiler de todas la películas con formato DVD"
=PROMEDIO.SI(D3:D17; "DVD"; E3:E17)
=CONTAR.SI(D3:D17; "DVD"; E3:E17)
=PROMEDIO(D3:D17; "DVD"; E3:E17)
=PROMEDIO.SI(D3:D17; "DVD")
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cuántos películas no están disponibles?
=CONTAR(F3:F17; "NO")
=CONTAR.SI(F3:F17; "NO"; D3:D17)
=CONTAR.SI(F3:F17)
=CONTAR.SI(F3:F17; "NO")
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Calcular el PROMEDIO del saldo de los clientes ?"
=PROMEDIO(H3:H18)
=PROMEDIO.SI(H3:H18; "SALDO")
=PROMEDIO.SI(H3:H18)
=SUMAR.SI(H3:H18)
Create a free account and access millions of resources
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
10 questions
SOFTWARE EDUCATIVO
Quiz
•
10th - 12th Grade
10 questions
Quizz para premiación UNITEC
Quiz
•
1st - 10th Grade
13 questions
CORRIENTE ELECTRICA
Quiz
•
1st - 10th Grade
7 questions
História em quadrinhos
Quiz
•
1st - 12th Grade
10 questions
Tecnología 3er Grado
Quiz
•
1st Grade - Professio...
14 questions
Logica
Quiz
•
3rd - 12th Grade
10 questions
MAQUINAS SIMPLES
Quiz
•
1st - 12th Grade
10 questions
Domande digitali
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade
Discover more resources for Instructional Technology
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
10 questions
Exploring the Origins of Veterans Day
Interactive video
•
6th - 10th Grade
28 questions
Ser vs estar
Quiz
•
9th - 12th Grade
10 questions
Understanding Protein Synthesis
Interactive video
•
7th - 10th Grade
10 questions
Exploring Newton's Laws of Motion
Interactive video
•
6th - 10th Grade
10 questions
Exploring the Origins of Veterans Day
Interactive video
•
6th - 10th Grade