Fórmulas condicionales de Excel
Authored by Jafet Ruiz
Computers
10th Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
9 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
Tienes en la columna A distintas categorías (p. ej., “Alimentos”, “Ropa”, “Electrónica”) y en la columna B las ventas de cada fila. ¿Cómo usarías SUMAR.SI para sumar solamente las ventas de categoría “Alimentos”?
=SUMAR.SI(B2:B10;"Alimentos";A2:A10)
=SUMA.SI(A2:A10;"Alimentos";B2:B10)
=SUMAR.SI(A2:A10;"Alimentos")
=SUMAR.SI(A2:A10;"Alimentos";B2:B10)
2.
MULTIPLE SELECT QUESTION
3 mins • 1 pt
En una hoja, la columna C registra el importe de facturas. ¿Cómo escribirías la fórmula para sumar únicamente las facturas que tengan un valor mayor o igual a 500?
=SUMAR.SI(C2:C10;">=500")
=SUMAR.SI(C2:C10;C2>=500;C2:C10)
=SUMAR.SI(C2:C10;">=500";C2:C10)
=SUMAR.SI(C2:C10;">=500";C2)
3.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
La columna D indica Asistencia con “S” o “N” y la columna E muestra puntos. ¿Cómo sumarías solo los puntos de quienes tienen “S” en la columna D?
=SUMAR.SI(D2:D10;"S")
=SUMAR.SI(D2:D10;"S";E2:E10)
=SUMAR.SI(E2:E10;"S";D2:D10)
=SUMAR.SI(D2:D10;S;E2:E10)
4.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
En la columna F tienes notas de examen (6, 7, 8, 9, 10). ¿Cómo contarías cuántas veces aparece la nota 10?
=CONTAR.SI(F2:F10;10)
=CONTAR.SI(F2:F10;">10")
=SUMAR.SI(F2:F10;10;F2:F10)
=CONTAR.SI(F2:F10;"=>10")
5.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
La columna B contiene las palabras “Aprobado” o “Reprobado”. ¿Cómo contarías la cantidad de celdas con “Aprobado”?
=CONTAR.SI(B2:B10;"Reprobado")
=SUMAR.SI(B2:B10;"Aprobado")
=CONTAR.SI(B2:B10;"Aprobado")
=CONTAR.SI(B2:B10;"Abrobado")
6.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
La columna C registra tiempos (en minutos) de un grupo de corredores. ¿Cómo contar cuántos tienen tiempo menor o igual a 30?
=CONTAR.SI(C2:C10;"=25")
=PROMEDIO(E2:E10;25)
=PROMEDIO.SI(E2:E10;E2:E10>=25)
=PROMEDIO.SI(E2:E10;"<=25";E2:E10)
7.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
La columna A contiene la Categoría (“Examen”, “Proyecto”, “Tarea”…). La columna B tiene calificaciones (0 a 10). ¿Cómo usar Promedio.Si para el promedio solo de "Examen"?
=PROMEDIO.SI(B2:B10;"Examen")
=SUMAR.SI(A2:A10;"Examen";B2:B10)
=PROMEDIO.SI(A2:A10;"Examen";B2:B10)
=PROMEDIO.SI(A2:A10;"Examen")
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
10 questions
Formato de Excel
Quiz
•
1st - 10th Grade
10 questions
Sistemas Operativos
Quiz
•
1st - 12th Grade
14 questions
Evaluación Final de Sesión - robótica
Quiz
•
1st - 12th Grade
10 questions
CONTEST 9 POWERPOINT 2019
Quiz
•
7th - 12th Grade
10 questions
Evaluacion de programación mBlock
Quiz
•
10th Grade
11 questions
Informática
Quiz
•
1st - 12th Grade
10 questions
Pensamiento Computacional
Quiz
•
8th - 11th Grade
14 questions
Formularios de Google
Quiz
•
1st Grade - University
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
10 questions
Exploring Valentine's Day with Charlie Brown
Interactive video
•
6th - 10th Grade
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
10 questions
Valentine's Day History and Traditions
Interactive video
•
6th - 10th Grade
21 questions
Presidents Day Trivia
Quiz
•
6th - 12th Grade
10 questions
Valentine's Day: History and Modern Celebration
Interactive video
•
9th - 12th Grade
11 questions
Valentine's Day Trivia
Quiz
•
8th - 12th Grade
10 questions
Factor Quadratic Expressions with Various Coefficients
Quiz
•
9th - 12th Grade