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: Fórmulas en Acció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 Avanzado: Fórmulas en Acción

Quiz

Played 1 %Accuracy 85 Average time 03:17
Create copy

About this activity

Cuestionario sobre fórmulas clave de Excel

Created by

Jonathan Frank Ramirez
Jonathan Frank Ramirez
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 Avanzado: Fórmulas en Acción
 

Excel Avanzado: Fórmulas en AcciónOnline version

Cuestionario sobre fórmulas clave de Excel

by Jonathan Frank Ramirez
1

¿Qué devuelve la función MAX(C1:C15)?

2

¿Qué devuelve MIN(D1:D15)?

3

¿Qué hace CONTAR(E:E)?

4

¿Qué hace CONTAR.A(S:F)?

5

¿Qué evalúa SI(G2>100, 'Sí', 'No')?

6

¿Qué hace SUMAR.SI(A1:A10, '>50')?

7

¿Qué función realiza búsqueda vertical?

8

¿Qué devuelve INDICE(A1:C10, 2, 3)?

9

¿Qué devuelve COINCIDIR('Venta', C:C, 0)?

10

¿Qué hace CONCATENAR(I2, ' - ', J2)?

Explicación

MAX devuelve el valor más alto dentro del rango especificado.

MIN identifica el menor valor en el rango.

CONTAR solo cuenta celdas con números.

CONTARA cuenta celdas no vacías, independientemente del tipo de dato.

SI evalúa una condición y devuelve resultados según sea verdadera o falsa.

SUMAR.SI suma solo las celdas que cumplen el criterio.

BUSCARV busca un valor en la primera columna y devuelve de la columna especificada.

INDICE devuelve el valor situado en la intersección de fila y columna especificadas.

COINCIDIR devuelve la posición relativa del valor buscado.

CONCATENAR une textos de distintas celdas en una cadena.

 
Are you sure you want to leave the page?

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