New game
Download
SCORM download
To be used in an LMS (Moodle, Blackboard...)
Regular download
To be published on a website or blog.
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.
Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.
Get Academic Plan
If you wish, you can download a demo game here and test its integration:
Share game
Quiz
Quiz

Funciones lógicas en Excel

Integrate it into your platform
G. Classroom M. Teams
You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.
Download
You have exceeded the maximum number of games you can integrate into Google Classroom with your current Plan.

To integrate as many games as you want in Google Classroom, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
You have exceeded the maximum number of games you can integrate into Microsoft Teams with your current Plan.

To integrate as many games as you want in Microsoft Teams, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.

Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.

If you wish, you can download a demo game here and test its integration:

Get Academic Plan

Funciones lógicas en Excel

Quiz

Played 73 %Accuracy 14 Average time 01:13
Create copy

About this activity

Quiz sobre SI, Y y O

Created by

María del Carmen Sánchez Ruiz
María del Carmen Sánchez Ruiz
Spain

Download the paper version to play

Make your own free game from our game creator
Compete against your friends to see who gets the best score in this game
Make challenge

Top Games

 %
Anonymous
Anonymous
 %
%
%
You have exceeded the maximum number of games you can print with your current Plan.

To print as many games as you want, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Print your game
Funciones lógicas en Excel
 

Funciones lógicas en ExcelOnline version

Quiz sobre SI, Y y O

by María del Carmen Sánchez Ruiz
1

1. ¿Qué hace la función SI en Excel?

2

2. ¿Cuál es la sintaxis correcta de la función SI?

3

3. ¿Qué devuelve la fórmula =SI(5>3;"Sí";"No")?

4

4. ¿Qué operador lógico se usa para comprobar si todas las condiciones se cumplen?

5

5. ¿Qué hace la función Y?

6

6. ¿Qué devuelve =Y(5>3; 2<4)?

7

7. ¿Qué devuelve =Y(5>10; 2<4)?

8

8. ¿Qué función se utiliza para comprobar si al menos una condición es verdadera?

9

9. ¿Qué devuelve =O(5>10; 2<4)?

10

10. ¿Qué devuelve =O(5>10; 2>4)?

11

11. ¿Cuál de estas fórmulas es correcta para comprobar si una nota es aprobada (≥5)?

12

12. ¿Para qué sirve combinar SI con Y?

13

13. ¿Qué hace esta fórmula? =SI(Y(A1>=5; A1<=10);"Aprobado";"No aprobado")

14

14. ¿Qué función usarías para comprobar si una persona es menor de 18 o mayor de 65?

15

15. ¿Qué devuelve la fórmula =SI(O(edad<18; edad>65);"No laboral";"Laboral") si edad = 20?

16

16. ¿Cuál de las siguientes fórmulas está mal escrita?

17

17. ¿Qué devuelve =SI(Y(VERDADERO;FALSO);"Sí";"No")?

18

18. ¿Qué devuelve =SI(O(FALSO;VERDADERO);"Correcto";"Incorrecto")?

19

19. ¿Qué tipo de valor devuelven las funciones Y y O?

20

20. ¿Cuál es el objetivo principal de usar funciones lógicas en Excel?

 
Are you sure you want to leave the page?

If you leave the page, you will lose your game progress.