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
Froggy Jumps
Froggy Jumps

IF & VLOOKUP Essentials

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

IF & VLOOKUP Essentials

Froggy Jumps

Played 8
Create copy

About this activity

Test your IF and VLOOKUP skills

Created by

Parveen
Parveen
Saudi Arabia

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
IF & VLOOKUP Essentials
 

Froggy Jumps

IF & VLOOKUP EssentialsOnline version

Test your IF and VLOOKUP skills

by Parveen
1

What does the IF function do in Excel?

2

What is the syntax for the IF function in Excel?

3

What does VLOOKUP do?

4

In VLOOKUP, what does FALSE for range_lookup mean?

5

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

6

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

7

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

8

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

9

If function is just like a yes-no question

10

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

11

In Vlookup function, the range_lookup field is optional

12

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

13

The syntax may vary for IF statement in other programming languages

14

If statements are not used in all programming languages

15

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

16

A ____________ is a present formula

17

IF statement is also known as ________ formula

18

___________ feature used to copy the formula to cells

19

The ______________ function performs a vertical lookup

20

In range_lookup, for approximate match we write ____________

 
Are you sure you want to leave the page?

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