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: BUSCARV, BUSCARH y SI

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: BUSCARV, BUSCARH y SI

Quiz

Played 0
Create copy

About this activity

Quiz sobre BUSCARV, BUSCARH y SI

Created by

Lisandro Travez
Lisandro Travez
Ecuador

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: BUSCARV, BUSCARH y SI
 

Excel: BUSCARV, BUSCARH y SIOnline version

Quiz sobre BUSCARV, BUSCARH y SI

by Lisandro Travez
1

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

2

¿Qué estructura tiene BUSCARV correctamente?

3

Qué parámetro de BUSCARV decide si la coincidencia es exacta o aproximada?

4

¿Qué hace BUSCARH?

5

¿Qué función corresponde a un condicional simple en Excel?

6

¿Qué devuelve BUSCARV si no encuentra coincidencia exacta y [orden] es 0?

7

Ejemplo de uso de SI para evaluar puntaje: =SI(puntaje>=60, 'Aprobado','Reprobado')

8

¿Qué busca BUSCARH en una hoja?

9

¿Cuál es un error común al usar BUSCARV?

10

Diferencia principal entre BUSCARV y BUSCARH

Explicación

BUSCARV busca verticalmente en la primera columna y devuelve el valor de la columna indicada.

La sintaxis correcta es valor_buscado, rango_tabla, indicador_columna, [orden].

Usas FALSO/0 para coincidencia exacta y VERDADERO/1 para aproximada.

BUSCARH funciona como BUSCARV pero horizontal: busca en la primera fila y devuelve desde una columna específica.

La función SI evalúa una prueba lógica y devuelve un valor si es verdadero y otro si es falso.

Con coincidencia exacta y no encontrada, retorna #N/A.

La fórmula devuelve Aprobado si la condición es verdadera; en un sistema real devolvería el texto, pero el concepto es la evaluación de la condición.

BUSCARH es la versión horizontal que opera sobre filas, no columnas.

BUSCARV sólo busca en la primera columna del rango indicado.

BUSCARV es vertical (columna), BUSCARH es horizontal (fila).

 
Are you sure you want to leave the page?

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