Basic Functions - Word Drop

A ______ is a ready-made formula such as MAX or AVERAGE, used instead of a very long formula. Every function uses an ______ sign, its name and a pair of ______ around the cells it works on. A ______ such as J4:J34 uses a colon between the first and last cell. Where a function uses a list of cells, those cells are separated by ______. A whole column can be used too, written as ______.

To add up every number in a range, use the ______ function. ______ finds the smallest number and MAX finds the largest. AVERAGE works out the ______, adding the values and dividing by how many there are. COUNT counts only the cells that contain ______, but ______ counts the cells holding anything at all, including text. Empty cells are counted by neither.

PROPER fixes capitalisation, so each word starts with a ______ letter and the rest are lowercase. CONCATENATE ______ the values from several cells into one, so snow and flake become snowflake. Choosing the right function means matching it to the job. Use SUM to find a ______, MIN for the lowest payment and MAX for the highest payment.