Answers
Gives 5.4 for 4, 9, 2, 7, 5
Gives 5 for 12, Apple, 8, empty, Pear, 5
Replaces =J4+J5+J6 all the way to J34
Gives 2 for 4, 9, 2, 7, 5
Mean booking rating from a survey
Gives 3 for 12, Apple, 8, empty, Pear, 5
Finds the largest number in a range
How many cells contain numbers
Gives 9 for 4, 9, 2, 7, 5
Number of customers who paid a price
Adds up every number in a range
Highest payment made by a customer
Finds the smallest number in a range
Number of names in a list
Lowest payment made by a customer
Counts Apple and Pear as well
Gives 27 for 4, 9, 2, 7, 5
Adds numbers then divides by how many
Works out the mean of a range
How many cells contain anything at all
Counts 12, 8 and 5 but not Apple