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

Excel: Filtros y Datos

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: Filtros y Datos

Quiz

Played 5 %Accuracy 100 Average time 01:44
Create copy

About this activity

Filtrado y organización de datos en Excel

Created by

Andres Palacio
Andres Palacio
Colombia

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: Filtros y Datos
 

Excel: Filtros y DatosOnline version

Filtrado y organización de datos en Excel

by Andres Palacio
1

¿Qué opción de Excel convierte un rango en una tabla con filtros automáticos?

2

¿Qué función usa para ordenar datos de A a Z en una columna?

3

¿Qué herramienta agrupa y resume datos por categorías?

4

¿Qué característica permite segmentar datos por criterios en informes?

5

¿Qué opción crea filtros con iconos en cabeceras de columna?

6

¿Qué herramienta se usa para aplicar criterios complejos en un rango?

7

¿Qué función convierte un rango en una tabla estructurada con nombres de columnas?

8

¿Qué opción añade subtotales por cada grupo en un listado?

9

¿Qué característica permite filtrar datos sin alterar el rango original?

10

¿Qué método organiza los datos y facilita cálculos agrupados?

Explicación

Crear una tabla facilita filtros y formato estructurado.

Ordenar de A a Z reorganiza el rango por la primera columna.

Subtotales muestran totales por grupo.

La segmentación facilita filtros interactivos.

El filtro en cabeceras permite seleccionar criterios.

Filtro avanzado usa criterios en rangos separados.

Convertir a tabla facilita manejo y filtros.

Subtotales por cada grupo proporcionan totales parciales.

El filtro oculta filas sin borrar datos.

Ordenar+subtotales facilita análisis por grupos.

 
Are you sure you want to leave the page?

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