Answers
Returns the largest value in a range of cells.
A ready-made formula built into a spreadsheet that performs a calculation on cell values.
Counts how many cells in a range contain any data, including text, but not empty cells.
Returns the smallest value in a range of cells.
A group of cells from a start cell to an end cell, shown with a colon.
The symbol written first in a cell to show the spreadsheet should work out the value.
Adds together all the numbers in a given range, ignoring text and empty cells.
Joins together the text from several cells into one piece of text.
Changes text so the first letter of each word is a capital and the rest are lowercase.
Works out the mean by adding the numbers and dividing by how many there are.
Counts how many cells in a range contain numbers, ignoring text and empty cells.