Excel Conditionals Mastery

Froggy Jumps

(8)

Parties jouées 74

Créer une copie

À propos de cette activité

Master IF, AND, OR in Excel

Créé par

Mauricio López Núñez

Colombia

Téléchargez la version pour jouer sur papier

Top 10 résultats

#	Jeux	Précision	temps
1	Tomas G 28 Août 2025	% 100	01:02
2	Gabriela Castellanos 28 Août 2025	% 100	01:32
3	Cami L 28 Août 2025	% 100	01:39
4	Nicolas W 28 Août 2025	% 100	01:46
5	Juan Diego Sánchez 28 Août 2025	% 100	01:51
6	David P 28 Août 2025	% 100	01:54
7	Samuel A. 28 Août 2025	% 90	01:09
8	Samuel Jair 28 Août 2025	% 90	01:14
9	Juan Espejo 28 Août 2025	% 90	01:29
10	Sarah M 28 Août 2025	% 90	01:36

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

The Integumentary System

Breanna Nesbitt

United States

(58)

Functions and Structures of the skin
pizza

Lorelay Tyana

Romania

(261)

joc despre pizza
Ethos, Pathos, and Logos Quiz

Kristine Vester

United States

(131)

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

(90)

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

Pamela Chapman

United States

(59)

Test your knowledge of the order of draw in Phlebotomy with these 10 questions!


Froggy Jumps Excel Conditionals MasteryVersion en ligne Master IF, AND, OR in Excel par Mauricio López Núñez 1 Which Excel function tests a condition and returns a value if TRUE and another if FALSE? a IF b SUM c VLOOKUP 2 Which operator returns TRUE only when both conditions are TRUE? a OR b AND c NOT 3 How do you handle more than two conditions in Excel using IF? a IFERROR b VLOOKUP c Nested IF 4 Which function checks if at least one condition is TRUE? a IF b AND c OR 5 Which formula assigns 'High' if A1>10, 'Medium' if A1>5, else 'Low'? a IF(A1>10,'High',IF(A1>5,'Medium','Low')) b IF(A1>5,'Medium','Low') c IF(A1>10,'Low',IF(A1>5,'Medium','High')) 6 Which operator would you use to require both conditions true in Excel? a NOT b AND c OR 7 Which formula checks both conditions are true: IF(AND(cond1,cond2), true, false)? a VLOOKUP b IF with AND c IF with OR 8 Which scenario commonly uses nested IFs to assign grades by numeric ranges? a Grading by numeric ranges b LOOKUP c Simple arithmetic 9 What does a simple IF like IF(A1>0, 'Positive', 'Non-positive') illustrate? a A VLOOKUP example b A simple IF statement c A SUM function 10 What is the result of =IF(OR(A1>10,A1<0), 'OK','NOK') when A1=12? a NOK b OK c Error

Froggy Jumps

Excel Conditionals MasteryVersion en ligne

Master IF, AND, OR in Excel

par Mauricio López Núñez

Which Excel function tests a condition and returns a value if TRUE and another if FALSE?

SUM

VLOOKUP

Which operator returns TRUE only when both conditions are TRUE?

AND

NOT

How do you handle more than two conditions in Excel using IF?

IFERROR

VLOOKUP

Nested IF

Which function checks if at least one condition is TRUE?

AND

Which formula assigns 'High' if A1>10, 'Medium' if A1>5, else 'Low'?

IF(A1>10,'High',IF(A1>5,'Medium','Low'))

IF(A1>5,'Medium','Low')

IF(A1>10,'Low',IF(A1>5,'Medium','High'))

Which operator would you use to require both conditions true in Excel?

NOT

AND

Which formula checks both conditions are true: IF(AND(cond1,cond2), true, false)?

VLOOKUP

IF with AND

IF with OR

Which scenario commonly uses nested IFs to assign grades by numeric ranges?

Grading by numeric ranges

LOOKUP

Simple arithmetic

What does a simple IF like IF(A1>0, 'Positive', 'Non-positive') illustrate?

A VLOOKUP example

A simple IF statement

A SUM function

What is the result of =IF(OR(A1>10,A1<0), 'OK','NOK') when A1=12?

NOK

Error

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.

Excel Conditionals Mastery

Froggy Jumps

À propos de cette activité

Créé par

Téléchargez la version pour jouer sur papier

Top Jeux

Froggy Jumps

The Integumentary System

Froggy Jumps

pizza

Froggy Jumps

Ethos, Pathos, and Logos Quiz

Froggy Jumps

Bill of Rights Game - The Constitutionalist

Froggy Jumps

Phlebotomy Order of Draw Quiz

Froggy Jumps

Excel Conditionals MasteryVersion en ligne

par Mauricio López Núñez

Which Excel function tests a condition and returns a value if TRUE and another if FALSE?

Which operator returns TRUE only when both conditions are TRUE?

How do you handle more than two conditions in Excel using IF?

Which function checks if at least one condition is TRUE?

Which formula assigns 'High' if A1>10, 'Medium' if A1>5, else 'Low'?

Which operator would you use to require both conditions true in Excel?

Which formula checks both conditions are true: IF(AND(cond1,cond2), true, false)?

Which scenario commonly uses nested IFs to assign grades by numeric ranges?

What does a simple IF like IF(A1>0, 'Positive', 'Non-positive') illustrate?

What is the result of =IF(OR(A1>10,A1<0), 'OK','NOK') when A1=12?

		%
	Anonyme	%
		%
		%