Condicionales en Excel
10th Grade
•10 Qs
Similar activities
examen final tecnologia Novenos
9th - 12th Grade
•15 Qs
Sensores y actuadores
1st - 10th Grade
•10 Qs
Bulos y fake news
9th - 12th Grade
•11 Qs
Quiz de refuerzo, tecnología Segundo Trimestre
1st - 12th Grade
•14 Qs
Excel
10th - 12th Grade
•10 Qs
Conocimientos Básicos de la Plataforma Institucional
6th - 11th Grade
•10 Qs
EXAMEN FINAL DE PERIODO
10th Grade
•10 Qs
Test lacătușerie generală
1st - 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
Excel
Quiz
•
10th - 12th Grade
11 questions
INTELIGENCIA ARTIFICIAL
Quiz
•
8th - 12th Grade
10 questions
Electricidad 2º ESO
Quiz
•
1st - 10th Grade
10 questions
TIC Primaria 2021 - P. Muoio
Quiz
•
10th Grade - Professi...
10 questions
10 Claves para navegar seguro en internet
Quiz
•
6th - 11th Grade
10 questions
Robotica Educativa
Quiz
•
7th - 12th Grade
10 questions
Inteligencia Artificial
Quiz
•
10th Grade
10 questions
Sistemas de Información
Quiz
•
10th 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