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: Búsqueda, Tablas dinámicas y segmentación

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: Búsqueda, Tablas dinámicas y segmentación

Quiz

(1)
Played 2 %Accuracy 100 Average time 03:09
Create copy

About this activity

Cuestionario de Excel

Created by

Erik Estrada
Erik Estrada
Peru

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: Búsqueda, Tablas dinámicas y segmentación
 

Excel: Búsqueda, Tablas dinámicas y segmentaciónOnline version

Cuestionario de Excel

by Erik Estrada
1

¿Qué función busca un valor en la primera columna y devuelve un valor de la misma fila?

2

¿Cuál es la sintaxis básica de buscarX?

3

¿Qué función reemplaza a buscarV cuando hay varias columnas para devolver resultados?

4

¿Qué es una tabla dinámica?

5

¿Qué es la segmentación de datos en Excel?

6

¿Qué opción se usa para crear filtros por cliente, fecha, etc. en una tabla dinámica?

7

Ventaja principal de usar tablas dinámicas?

8

¿Qué ocurre si no se encuentra el valor buscado con buscarV?

Explicación

buscarV buscan valores en la primera columna y devuelven un dato de la misma fila.

buscarX tiene una sintaxis flexible que especifica valor, matrices de búsqueda y resultado.

buscarX permite búsquedas más flexibles que buscarV.

Las tablas dinámicas resumen y analizan grandes volúmenes de datos de forma interactiva.

La segmentación añade filtros visuales para categorías específicas.

La segmentación de datos agrega filtros interactivos a la tabla dinámica.

Permiten explorar datos de forma rápida y flexible.

Si no hay coincidencia exacta, aparece #N/A por defecto.

 
Are you sure you want to leave the page?

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