Y7

4l: Use the functions COUNTIF and IF in a spreadsheet

Keywords:

Spreadsheets

Test your self on these keywords and definitions using the games below or Play random game

Keyword	Definition
boolean expression	a question based on the value of a cell which can only be answered by either True or False
COUNTIF	spreadsheet function which counts how many values in a range match a certain criteria
criteria	a condition that data has to match in order to be counted or included
IF	spreadsheet function which displays one of two values depending on the value of a cell
range	more than one cell in a spreadsheet

All learning objectives

Keyword games:

BugZap

Connect the wires to complete the circuit and zap the bug. The faster you choose the right keyword, the more points you get for zapping the bug!

Crossword

Use the clues to guess the keywords and fill in the blank spaces on the crossword

Eliminate

Click on the keywords that do not match the definition

Flappy Word

Click to jump. Collect a letter each time you pass a pipe

Hangman Definitions

Guess the letters of the definition

Hangman Keywords

Guess the letters of the keyword

Jumble Keyword

Rearrange the letters of the keyword into the right order

Random

Choose a game at random

Snake

Control the snake to eat each letter of the keyword in order

TypeRace

Type out the definitions as fast as you can

Wordsearch

Find the words that match each definition

Play Random Game

Resources: