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

Quiz de Fórmulas de Excel

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

Quiz de Fórmulas de Excel

Quiz

Played 0
Create copy

About this activity

Formulas y usos prácticos

Created by

Sara Ortiz
Sara Ortiz
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
Quiz de Fórmulas de Excel
 

Quiz de Fórmulas de ExcelOnline version

Formulas y usos prácticos

by Sara Ortiz
1

¿Qué hace la función SUMA en Excel?

2

¿Qué devuelve la función IF?

3

¿Para qué se usa VLOOKUP?

4

¿Qué hace la función AVERAGE?

5

¿Qué permite CONCATENAR o CONCAT?

6

¿Qué realiza INDEX/MATCH como alternativa a VLOOKUP?

7

¿Para qué sirve SUMIF?

8

¿Qué hace COUNTIF?

9

¿Qué función devuelve la fecha actual en Excel?

10

¿Qué hace la función DATEVALUE?

Explicación

SUMA suma números de un rango, por ejemplo =SUMA(A1:A10).

IF evalúa una condición y devuelve un resultado basado en VERDADERO o FALSO.

VLOOKUP busca en la primera columna y retorna desde otra columna de la misma fila.

AVERAGE suma y divide por la cantidad de celdas numéricas.

CONCATENAR o CONCAT une cadenas de texto en una celda.

INDEX/MATCH es una combinación para buscar datos en cualquier dirección, más flexible que VLOOKUP.

SUMIF suma celdas que cumplen el criterio especificado.

COUNTIF cuenta celdas que satisfacen un criterio.

HOY devuelve la fecha actual del sistema.

DATEVALUE convierte una cadena con fecha a un valor de fecha que Excel puede usar en cálculos.

 
Are you sure you want to leave the page?

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