
FUNCIONES Y SITUACIONES
Authored by Magdalena Martinez
Instructional Technology
University
Used 17+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Contexto: Necesitas calcular el total de ventas de enero, las cuales se encuentran en las celdas B2 hasta B15.
=PROMEDIO(B2:B15)
SUMA(B2:B15)
CONTAR(B2:B15)
MAX(B2:B15)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Contexto: Quieres saber cuántos productos en tu inventario tienen una cantidad mayor a 50 unidades, y las cantidades están en la columna C (desde C2 hasta C20).
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Contexto: Quieres determinar si un estudiante ha aprobado o no. Su calificación está en la celda J7. Si la calificación es mayor o igual a 70, debe mostrar "Aprobado", de lo contrario, "Reprobado".
SI(J7>=70,"Aprobado")
=SI(J7>=70,"Aprobado","Reprobado")
=SI(J7<=70,"Reprobado","Aprobado")
=SI(J7,"Aprobado","Reprobado")
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Contexto: Estás calculando la diferencia entre los ingresos (celda M10) y los costos (celda N10).
=M10+N10
=N10-M10
=M10-N10
=M10/N10
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Contexto: Quieres saber si el saldo de una cuenta (en la celda S6) es positivo en ese caso debe mostrar "Positivo", de lo contrario, "Negativo".
=SI(S6>1,"Positivo")
=SI(S6>0,"Positivo","Negativo")
=SI(S6>1,"Negativo","Positivo")
=SI(S6<0,"Negativo","Positivo")
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Contexto: Quieres encontrar la cantidad mínima de stock en un rango de celdas U2:U16.
=MAX(U2:U16)
=MIN(U2:U16)
=CONTAR(U2:U16)
=SUMA(U2:U16)
7.
FILL IN THE BLANK QUESTION
1 min • 1 pt
Para sumar un rango de celdas desde A1 hasta A10, la fórmula es:
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
15 questions
GLOBALIZACION VENTAJAS Y DESVENTAJAS
Quiz
•
University
10 questions
Estructuras Selectivas C++
Quiz
•
7th Grade - Professio...
16 questions
Quiz de Conocimiento
Quiz
•
University
15 questions
PON APRUEBA TUS CONOCIMIENTOS ESFM 2023
Quiz
•
University
10 questions
Ciclo de vida de Desarrollo de Sistemas
Quiz
•
10th Grade - University
20 questions
BIMESTRAL SEPTIMO
Quiz
•
7th Grade - University
12 questions
STIN (EM23) - Sistemas Transaccionales (T3)
Quiz
•
University - Professi...
18 questions
VIU - Diseño y gestión de EVA
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
10 questions
Probability Practice
Quiz
•
4th Grade
15 questions
Probability on Number LIne
Quiz
•
4th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
6 questions
Appropriate Chromebook Usage
Lesson
•
7th Grade
10 questions
Greek Bases tele and phon
Quiz
•
6th - 8th Grade
Discover more resources for Instructional Technology
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
20 questions
Endocrine System
Quiz
•
University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
30 questions
W25: PSYCH 250 - Exam 2 Practice
Quiz
•
University
5 questions
Inherited and Acquired Traits of Animals
Interactive video
•
4th Grade - University
20 questions
Implicit vs. Explicit
Quiz
•
6th Grade - University
7 questions
Comparing Fractions
Interactive video
•
1st Grade - University
38 questions
Unit 8 Review - Absolutism & Revolution
Quiz
•
10th Grade - University