Spreadsheet Matching Exercise

Matching exercise

Match the items on the right to the items on the left.
The name of the spreadsheet application you have been using
This is used to carry out basic calculations
This is an example of a cell reference
This stops data in cells from getting changed accidentally
This is used to perform a calculation on many cells
This would find the average number between cells A1 and A10
Information could be shown on this to make it more understandable
When this is option is selected, the information is calculated only when the user tells it to
This is an example of absolute replication
This adds up all the numbers between cells F5 and F12