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
Yes or No
Yes or No

Excel: SI, Filtros y Pivot

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

Excel: SI, Filtros y Pivot

Yes or No

Played 8
Create copy

About this activity

Quiz rápido sobre Excel: SI, filtros y tablas dinámicas

Created by

Mairyn Santamaria Breton
Mairyn Santamaria Breton
Mexico

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
Excel: SI, Filtros y Pivot
 

Excel: SI, Filtros y PivotOnline version

Quiz rápido sobre Excel: SI, filtros y tablas dinámicas

by Mairyn Santamaria Breton
1

Un valor_si_falso en SI siempre debe ser un valor constante y nunca puede ser una fórmula.

2

En una tabla dinámica, se pueden usar campos de filtro para restringir los datos mostrados.

3

La función SI puede anidarse para realizar múltiples pruebas lógicas.

4

Las tablas dinámicas se actualizan automáticamente sin necesidad de actualizar el conjunto de datos.

5

Los filtros permiten mostrar solo filas que cumplen una condición en una tabla o rango.

6

Las tablas dinámicas requieren que los datos estén en un formato distinto al de una lista con encabezados únicos.

7

Los filtros en tablas dinámicas sólo permiten filtrar por campos numéricos, no por texto.

8

En Excel, SI no permite anidar funciones lógicas.

9

Las tablas dinámicas pueden resumir datos por sumas, promedios y recuentos.

10

La función SI en Excel tiene la sintaxis: SI(prueba, valor_si_verdadero, valor_si_falso).

 
Are you sure you want to leave the page?

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