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 Funciones de Hoja de Cálculo

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 Funciones de Hoja de Cálculo

Quiz

Played 53 %Accuracy 0 Average time 00:42
Create copy

About this activity

Funciones básicas y de búsqueda

Created by

Elkin Adrian Cortes Leal
Elkin Adrian Cortes Leal
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 Funciones de Hoja de Cálculo
 

Quiz de Funciones de Hoja de CálculoOnline version

Funciones básicas y de búsqueda

by Elkin Adrian Cortes Leal
1

¿Qué devuelve la función SUMA en una columna de números?

2

¿Cómo se obtiene el promedio con la función PROMEDIO?

3

¿Qué devuelve MAX(A1:A10)?

4

¿Qué determina MIN(A1:A10)?

5

¿Para qué sirve CONTARA(A1:A10)?

6

¿Qué hace CONTAR(A1:A10)?

7

¿Qué función equivale a VLOOKUP en versiones modernas con orientación izquierda-derecha?

8

¿Qué ofrece BUSCARX en comparación con BUSCARV?

9

¿Qué devuelve BUSCARV si no encuentra coincidencia y se usa =BUSCARV(valor, rango, columna, FALSO)?

10

¿Qué ofrece BUSCARX en caso de coincidencia parcial o con coincidencias aproximadas?

Explicación

SUMA suma los números; no cuenta celdas ni calcula otros estadísticas.

PROMEDIO calcula la media aritmética, no la suma ni el máximo.

MAX encuentra el valor máximo, no la suma ni el mínimo.

MIN busca el mínimo; no cuenta ni promedia.

CONTARA cuenta celdas con datos; no distingue tipo.

CONTAR solo considera celdas con valores numéricos.

BUSCARV busca en la primera columna y devuelve de la derecha.

XLOOKUP/BUSCARX es más versátil que VLOOKUP.

Con coincidencia exacta y sin resultado se devuelve #N/A.

XLOOKUP permite coincidencias exactas o aproximadas y manejo de no encontrados.

 
Are you sure you want to leave the page?

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