Basic Functions - Crossword

Clues

1. A built-in spreadsheet tool written with a name and brackets after an equals sign. (8)
2. Adds together all the numbers in a selected range of cells. (3)
3. Calculates the mean of a range of numbers. (7)
4. Tells you how many cells in a range contain numbers. (5)
5. Tells you how many cells in a range contain any data, including text. (6)
6. Finds the smallest value in a selected range of cells. (3)
7. Finds the largest value in a selected range of cells. (3)
8. Changes text so each word begins with a capital letter and the rest are lowercase. (6)
9. Joins together the contents of multiple cells into a single piece of text. (11)
10. The cells from a first reference to a last one, separated by a colon. (5)