Condicionales en Excel
Authored by Silvia Villa
Instructional Technology
10th Grade
Used 24+ 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
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)
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
11 questions
Bulos y fake news
Quiz
•
9th - 12th Grade
14 questions
Quiz de refuerzo, tecnología Segundo Trimestre
Quiz
•
1st - 12th Grade
11 questions
QUIZIZZ sobre QUIZIZZ
Quiz
•
10th - 12th Grade
10 questions
Conocimientos Básicos de la Plataforma Institucional
Quiz
•
6th - 11th Grade
10 questions
EXAMEN FINAL DE PERIODO
Quiz
•
10th Grade
10 questions
Test lacătușerie generală
Quiz
•
1st - 10th Grade
14 questions
nos ponemos a prueba
Quiz
•
1st - 12th Grade
10 questions
Sensores y actuadores
Quiz
•
1st - 10th Grade
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
Discover more resources for Instructional Technology
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
10 questions
Cell Organelles and Their Functions
Interactive video
•
6th - 10th Grade
20 questions
Figurative Language Review
Quiz
•
10th Grade
22 questions
El Imperfecto
Quiz
•
9th - 12th Grade
20 questions
Grammar
Quiz
•
9th - 12th Grade
12 questions
Equation of a Circle
Lesson
•
10th Grade
18 questions
Mendelian Genetics
Quiz
•
10th - 12th Grade
20 questions
verbos reflexivos en español
Quiz
•
9th - 12th Grade