IF & VLOOKUP Essentials

Froggy Jumps

Parties jouées 8

Créer une copie

À propos de cette activité

Test your IF and VLOOKUP skills

Créé par

Parveen

Saudi Arabia

Téléchargez la version pour jouer sur papier

Top 10 résultats

#	Jeux	Précision	temps
1	Bunny 6 Mars 2026	% 80	02:49

Voulez-vous apparaître dans le Top 10 de ce jeu? Connectez-vous pour vous identifier.

Créez votre propre jeu gratuite à partir de notre créateur de jeu

Affrontez vos amis pour voir qui obtient le meilleur score dans ce jeu

Créer un défi

pizza

Lorelay Tyana

Romania

(266)

joc despre pizza
The Integumentary System

Breanna Nesbitt

United States

(59)

Functions and Structures of the skin
Phlebotomy Order of Draw Quiz

Pamela Chapman

United States

(61)

Test your knowledge of the order of draw in Phlebotomy with these 10 questions!
Ethos, Pathos, and Logos Quiz

Kristine Vester

United States

(134)

Test your knowledge of ethos, pathos, and logos with these 10 questions on examples of persuasive techniques.
Bill of Rights Game - The Constitutionalist

Doni The Don

United States

(91)

Test your knowledge on the Bill of Rights. A fun way to test your knowledge and focus on where you need to improve.

		%
	Anonyme	%
		%
		%

Imprimez votre jeu

IF & VLOOKUP Essentials


Froggy Jumps IF & VLOOKUP EssentialsVersion en ligne Test your IF and VLOOKUP skills par 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

Vous pouvez intégrer le jeu dans un LMS compatible avec LTI 1.1 ou LTI 1.3 comme Canvas, Moodle ou Blackboard. Les scores seront ainsi automatiquement enregistrés dans le carnet de notes de la plateforme.

IF & VLOOKUP Essentials

Froggy Jumps

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Froggy Jumps

pizza

Froggy Jumps

The Integumentary System

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

IF & VLOOKUP EssentialsVersion en ligne

par 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 ____________