Recap Functions

Recap Functions

Match

Match the description to the Functions

• Adds the numbers in a range

• Counts the numbers in a range

• Counts the numbers in a range depending on the criteria

• Converts the text to lower case

• Converts the text to upper case

SUM

COUNT

COUNTIF

LOWER

UPPER

• SUM

• COUNT

• COUNTIF

• LOWER

• UPPER

Labelling

This is an example of an IF function

=IF(A1>=B1, "Buy", "Sell")

Drag labels to their correct position on the image

Wheel

Glass

Door

Light