Condicionales en Excel
10th Grade
•10 Qs
Similar activities
REPASO CICLOS Y CONDICIONANTES EN PSEINT
10th Grade
•10 Qs
APRESTAMIENTO LABORAL
1st - 10th Grade
•10 Qs
POWER POINT
1st - 12th Grade
•12 Qs
Tecnología Educativa
1st - 12th Grade
•15 Qs
Estructuras Selectivas C++
7th Grade - Professional Development
•10 Qs
Ciclo de vida de Desarrollo de Sistemas
10th Grade - University
•10 Qs
¿Te conectas y navegas de manera segura? ¡Compruébalo ahora!
1st - 10th Grade
•10 Qs
6to. Medio Año
6th Grade - University
•10 Qs
Condicionales en Excel
Quiz
•
Instructional Technology
•
10th Grade
•
Hard
Silvia Villa
Used 24+ times
FREE Resource
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
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...
10 questions
MAQUINAS SIMPLES
Quiz
•
1st - 12th Grade
14 questions
Logica
Quiz
•
3rd - 12th Grade
10 questions
Domande digitali
Quiz
•
9th - 12th Grade
10 questions
SOFTWARE EDUCATIVO
Quiz
•
10th - 12th Grade
10 questions
Quizz para premiación UNITEC
Quiz
•
1st - 10th Grade
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
11 questions
NEASC Extended Advisory
Lesson
•
9th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
20 questions
Multiplying and Dividing Integers
Quiz
•
7th Grade
Discover more resources for Instructional Technology
11 questions
NEASC Extended Advisory
Lesson
•
9th - 12th Grade
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
17 questions
Afro Latinos: Una Historia Breve Examen
Quiz
•
9th - 12th Grade
17 questions
Hispanic Heritage Month Trivia
Quiz
•
9th - 12th Grade
28 questions
Ser vs estar
Quiz
•
9th - 12th Grade
15 questions
PRESENTE CONTINUO
Quiz
•
9th - 12th Grade