IF & VLOOKUP Essentials

Froggy Jumps

Jugadas 8

Crear copia

Sobre esta actividad

Test your IF and VLOOKUP skills

Creada por

Parveen

Arabia Saudí

Descarga la versión para jugar en papel

Top 10 resultados

#	Jugador	Acierto	tiempo
1	Bunny 5 de Marzo de 2026	% 80	02:49

¿Quieres aparecer en el Top 10 de este juego? Inicia sesión para identificarte.

Crea tu propio juego gratis desde nuestro creador de juegos

Compite contra tus amigos para ver quien consigue la mejor puntuación en esta actividad

Crear reto

El valle de los lobos

Marcos Signes

España

(108)

20 preguntas de este maravilloso libro
Salva a la Ranita

Melanie Rodriguez

Estados Unidos

(338)

Contesta las siguientes multiplicaciones correctamente para salvar a la ranita y evitar que caiga al agua, mucha suerte!
Quiz de Culpa mía película

Yamila Chavez

Argentina

(171)

Demuestra cuánto sabes sobre la película Culpa mía con este divertido quiz.
Sabiduría animal

Educaplay Educational Resources

España

(15428)

Conviértete en un genio del Reino Animal
OPEN UP 6 UNIT 1 VOCABULARY

karen blixen

España

(100)

Repasamos el vocabulario de la unidad

		%
	Anónimo	%
		%
		%

Imprime tu juego

IF & VLOOKUP Essentials


Froggy Jumps IF & VLOOKUP EssentialsVersión en línea Test your IF and VLOOKUP skills por Parveen 1 What does the IF function do in Excel? a Calculates the sum of two numbers. b Finds the maximum value in a range. c Returns one value if a condition is true, otherwise another. 2 What is the syntax for the IF function in Excel? a IF(value, test, result) b IF(logical_test, value_if_true, value_if_false) c CHECK(logical, true, false) 3 What does VLOOKUP do? a Calculates vertical averages of a dataset. b Sorts data in ascending order only. c Looks up a value in the first column of a table and returns a value from a specified column. 4 In VLOOKUP, what does FALSE for range_lookup mean? a Exact match only b Approximate match only c No match allowed 5 For IF statement, if the logicaltest/condition is true,then which field will be executed. a Value_if_false b Value_if_true c None 6 In syntax for IF statement, which field should be filled with question or condition a Value_if_true b Value_if_false c Logical_test 7 In Vlookup function, in ___________ field we write the column number from the table from which it is needed to retrieve a value. a Col_index b Value c Table 8 =if(A6>700," Good Results","Bad Results") . in this statement what is the condition a A6>700 b Good Results c Bad Results 9 If function is just like a yes-no question a True b False c 10 Instead of using function wizard, we cannot directly write the IF function formula. a True b False c 11 In Vlookup function, the range_lookup field is optional a True b False c 12 Double quotes will not be added automatically after editing the cell in IF function argument dialog box. a True b False c 13 The syntax may vary for IF statement in other programming languages a True b False c 14 If statements are not used in all programming languages a True b False c 15 We can get the function argument dialog box from the FX button on the formula bar as well a True b False c 16 A ____________ is a present formula a Function b Definition c Formula 17 IF statement is also known as ________ formula a Logical b Illogical c Condition 18 ___________ feature used to copy the formula to cells a Autofill b Aerofill c Autofull 19 The ______________ function performs a vertical lookup a Vlookup b IF Function c 20 In range_lookup, for approximate match we write ____________ a True b False c None

Puedes integrar el juego en un LMS compatible con LTI 1.1 o LTI 1.3 como Canvas, Moodle, o Blackboard. De esta manera podrás guardar las puntuaciones automáticamente en el libro de calificaciones de esa plataforma.

IF & VLOOKUP Essentials

Froggy Jumps

Sobre esta actividad

Creada por

Descarga la versión para jugar en papel

Top juegos

Froggy Jumps

El valle de los lobos

Froggy Jumps

Salva a la Ranita

Froggy Jumps

Quiz de Culpa mía película

Froggy Jumps

Sabiduría animal

Froggy Jumps

OPEN UP 6 UNIT 1 VOCABULARY

Froggy Jumps

IF & VLOOKUP EssentialsVersión en línea

por Parveen

What does the IF function do in Excel?

What is the syntax for the IF function in Excel?

What does VLOOKUP do?

In VLOOKUP, what does FALSE for range_lookup mean?

For IF statement, if the logicaltest/condition is true,then which field will be executed.

In syntax for IF statement, which field should be filled with question or condition

In Vlookup function, in ___________ field we write the column number from the table from which it is needed to retrieve a value.

=if(A6>700," Good Results","Bad Results") . in this statement what is the condition

If function is just like a yes-no question

Instead of using function wizard, we cannot directly write the IF function formula.

In Vlookup function, the range_lookup field is optional

Double quotes will not be added automatically after editing the cell in IF function argument dialog box.

The syntax may vary for IF statement in other programming languages

If statements are not used in all programming languages

We can get the function argument dialog box from the FX button on the formula bar as well

A ____________ is a present formula

IF statement is also known as ________ formula

___________ feature used to copy the formula to cells

The ______________ function performs a vertical lookup

In range_lookup, for approximate match we write ____________