Spreadsheet Gap Exercise

Gap-fill exercise

Fill in all the gaps, then press "Check" to check your answers. Use the "Hint" button to get a free letter if an answer is giving you trouble. You can also click on the "[?]" button to get a clue. Note that you will lose points if you ask for hints or clues!
Spreadsheets can hold 3 types of information. 'Total' is an example of . '75' is an example of a or value. =A1+A2 is an example of a .

Each box in a spreadsheet is called a .

We use a cell to identify each cell in the spreadsheet. It is made up of a column letter and a .

This formula would add cells A5 and A6 together .

This formula would divide cells C2 and C3 .

This formula would multiply cells G6 and G7 together .

The function adds all the numbers up within the specified range.

The function finds the average number within the specified range.

The function would display the lowest number within the specified range.

The function would display the highest number in the specified range.

This function would display the word 'PASS' if the value in cell B2 was above 50 or 'FAIL' if the value was not above 50 =(B2,"","").

This function would add up all the numbers between cells D3 to D13 =().

This function would display the smallest number between cells J7 to J35 =().

We can change the way the spreadsheet looks by it. We can do this in many ways such as changing the column or changing the cell to display values as currency or a percentage etc. We can even set the number of places we want to display which is useful when displaying currency.

Cell can be used to stop the contents of cells from getting changed accidentally.

To make data easier to understand we can display the data in a .

In a chart, data is displayed in sections in a circle.

A common chart is a bar chart, however Excel calls a bar chart a chart.

Charts should also be fully so that they can be fully understood.

If the data in a chart is automatically changed when the data in the spreadsheet is chaged then data linkage is being used. If it is not automatically changed then data linkage is being used.

The feature of the spreadsheet which involves copying and pasting (usually a formula) is called .

With replication the formula automatically changes. With replication a sign is used before the column letter and row number to stop it from changing.