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 Avanzado Profesional

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 Avanzado Profesional

Quiz

Played 0
Create copy

About this activity

Quiz para dominar técnicas y prácticas avanzadas de Excel.

Created by

LUIS FERNANDO ESPINOSA VELASQUEZ
LUIS FERNANDO ESPINOSA VELASQUEZ
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 Avanzado Profesional
 

Excel Avanzado ProfesionalOnline version

Quiz para dominar técnicas y prácticas avanzadas de Excel.

by LUIS FERNANDO ESPINOSA VELASQUEZ
1

1. ¿Qué función usarías para devolver el valor de la columna B cuando coincida el SKU en la columna A, si hay varias coincidencias?

2

2. En una tabla dinámica, ¿qué opción permite resumir por sumas condicionadas al rango de fechas?

3

3. ¿Cuál es la forma correcta de usar INDEX-MATCH para buscar un valor en una columna y devolver de otra?

4

4. Al validar datos, ¿qué opción garantiza que solo se admitan valores de una lista dinámica en Power Query?

5

5. ¿Qué función devuelve la intersección de filas y columnas en una matriz y funciona bien con tablas dinámicas?

6

6. ¿Cuál es la manera correcta de actualizar una consulta de Power Query para combinar una columna clave con otra tabla?

7

7. En una fórmula SUMIFS, ¿qué pasa si se omite el criterio de suma y se deja en blanco?

8

8. ¿Qué opción permite optimizar rendimiento al trabajar con grandes volúmenes de datos en Excel?

9

9. ¿Qué significa activar 'Modelo de datos' al crear una PivotTable en Excel?

10

10. ¿Cuál es la forma correcta de manejar errores con XLOOKUP para devolver un valor alternativo si no hay coincidencia?

 
Are you sure you want to leave the page?

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